How do you get Excel to AutoFill a column?
Put the mouse pointer over the bottom right-hand corner of the cell until it's a black plus sign. Click and hold the left mouse button, and drag the plus sign over the cells you want to fill. And the series is filled in for you automatically using the AutoFill feature.
Insert the same data into multiple cells using Ctrl+Enter
Select all the blank cells in a column. Press Ctrl+Enter instead of Enter. All the selected cells will be filled with the data that you typed.
Autofill to End-of-Data in Microsoft Excel
There is a quick trick to making this more efficient. Here's how to auto-populate large areas in Excel. Open the Excel worksheet and select any two cells in a column. Instead of dragging all the way down the column, just hold down the shift key on the keyboard.
Click File > Options. In the Advanced category, under Editing options, select or clear the Enable fill handle and cell drag-and-drop check box.
Click File > Options. Click Advanced, and then under Editing options, select or clear the Enable AutoComplete for cell values check box to turn this option on or off.
- Select one or more cells you want to use as a basis for filling additional cells. For a series like 1, 2, 3, 4, 5..., type 1 and 2 in the first two cells. ...
- Drag the fill handle .
- If needed, click Auto Fill Options. and choose the option you want.
- Type the data into the a worksheet cell and Enter.
- Click in the cell with the data and, keeping the left mouse button pressed, drag to select the rest of the cells in the row or column that you would like autofilled.
- Release the mouse button.
On the Excel menu, click Preferences. Under Formulas and Lists, click AutoComplete. In the Show the menu only after I've typed box, enter the number of letters that you want to type before the AutoComplete menu appears. Tip: You can also show the AutoComplete menu by pressing CONTROL + OPTION + DOWN ARROW .
Press one of the following keyboard shortcuts: To AutoFit column width: Alt + H, then O, and then I. To AutoFit row height: Alt + H, then O, and then A.
- Click File > Options.
- Click the Advanced in the left pane, and ensure that the Automatically Flash Fill box is checked.
- Click OK.
- Close and restart Excel.
How do I use AutoFill without formatting?
- Select File > Options.
- Select Advanced in the navigation pane on the left.
- Scroll down to the section 'Cut, copy, and paste'.
- Make sure that the check box 'Show Paste Options button when content is pasted' is ticked.
- Click OK.