In fact, they work for the first four columns in our example. The four steps above will work in a lot of cases. Excel fills the cells with the right stuff. Click the lower right-hand corner with that black plus, hold the mouse button down, and drag down (or to the right). Move the mouse over that until the cursor looks like a little black “+” as shown below.Ĥ.
Look for a little box at the lower right-hand corner of the selected cell. Click on the cell again to select it, and let go.ģ. Type something into a cell and hit Enter (or Return).Ģ. All I did was type the first row of data. Actually, I let Excel do most of the typing for me, using a feature called Auto Fill. That’s one cell of data per second– very, very, very quick, and it’s not because I’m such an amazing typist.
It took me 59.4 seconds to enter this data. Notice anything? Of course you did– each column is a series, progressing from a starting item to an ending item in some sort of regular way. How to Save Time with Auto-Fill in Excel.
