Where to find fill handle in excel

When you fill down, the reference to A1 stays fixed but Excel changes the reference of B1, to B2 and B3. Under Edit Options , check the Allow fill handle and cell drag-and-drop box. In Calculation Options , ensure that Automatic is selected. Need more help? Expand your skills. Get new features first. Was this information helpful?

Yes No. Thank you! You can do this by selecting both cells, then clicking the fill handle the small black box with the left mouse button. While holding the left mouse down, drag the mouse down the spreadsheet in column A. If you dragged down to cell A50 and release the mouse button, cells A1 through A50 would now be sequentially numbered 1 to 50 without having to type each number individually. You can either fill down by dragging it down or fill up the dragging it upwards. You can use fill handle in Excel to autocomplete weekday names.

It could either be the three alphabets nomenclature Mon, Tue… or the full name Monday, Tuesday…. Note that it fills the cells with 7 weekdays names and then start over with the same name where you started.

For example, in the above example, it starts with Monday, and after Sunday it again automatically inserts Monday. You can easily autofill dates using the fill handle in Excel. Any date format that is recognized by Excel can be used by the fill handle.

While fill handle recognizes patterns and fills the list, it also gives some additional options you can use. As soon you drag the mouse or double click and autocomplete the list, you will see the Autofill option icon at the bottom right of the list. Cell formulas. Selecting cell A1.

Inserting cell content. Selecting a cell. Deleting cell content. Selecting a cell to delete. Clicking the Delete command. Cells shifted to replace the deleted cell. Selecting a cell to copy. Clicking the Copy command. Pasting cells. Clicking the Paste command. The pasted cell content. Selecting a cell range to cut.

Clicking the Cut command. The cut and pasted cells. Additional Paste options. Right-clicking to access formatting options. Hovering over the cell border. Dragging the selected cells. The dropped cells. Locating the fill handle. Dragging the fill handle. The filled cells.