Explore AutoFill Options

Here are the steps to follow for today’s lesson:

1) Click the drop-down arrow for AutoFill options.

2) Experiment with the different options e.g. Fill Weekdays only; Fill Formatting only, etc.

3) To increment numbers: establish the increment by typing the values in 2 cells; select both of the cells and then AutoFill

4) If you have a Formula that is adjacent to a series of numbers or text, then Double-Click the AutoFill Handle and Excel will fill the formula into all cells.

Find the video lesson that you want – Index to all Excel Topics

NEW! I invite you to view a short video introduction to The Company Rocks Excels Blog