Autofill Excel How To Use Fill

Save time and increase accuracy by copying data to other cells.

Former Lifewire writer Ted French is a Microsoft Certified Professional who teaches and writes about spreadsheets and spreadsheet programs.

Jessica Kormos is a writer and editor with 15 years experience writing articles, copy, and UX content for Tecca.com, Rosenfeld Media, and many others.

Inputting numbers, text, and formulas in Excel spreadsheets can be tedious and prone to error if you enter each cell text or value separately.

When you need to input the same data into a number of adjacent cells in a column, the Fill Down command can quickly perform the task by using just the keyboard.

Autofill Excel How To Use Fill

Follow these steps to see how to use Fill Down in your own Excel spreadsheets.

With most versions of Excel, you can use your mouse to select the cell that contains the number that you want to duplicate in the cells beneath it.

You can then select the last cell of a range to highlight the first and last cells and all the cells between them.

Click and hold the fill handle in the bottom right corner of the cell that contains the number.

Drag the fill handle downward to select the cells that you want to contain the same number.

Release the mouse and the number is copied into each of the selected cells.

The AutoFill feature also works horizontally to copy a number of adjacent cells in the same row.

Just click and drag the fill handle across the cells horizontally.

When you release the mouse, the number is copied into each selected cell.

Autofill Excel For Mac