Excel Autofill Variations

Excel Autofill Variations

By Allen Wyatt for Excel.Tips.Net

Everyone knows that when you are working on a spreadsheet and entering text, Excel attempts to be helpful and will suggest AutoFill based on the letters you type. There may, however, be times when you don’t remember the exact beginning of the text, so the AutoFill feature is of little value.

One way around this conundrum that allows you to still take advantage of AutoFill is to right-click on the cell where you want to enter information and choose Pick From List from the resulting Context menu. Excel displays a drop-down list that shows the other items you have entered in the column, thereby allowing you to select from the list.

If you need still faster access article continued here:

This post appears with permission from Allen Wyatt and Excel.Tips.Net.

(Visited 8 times, 1 visits today)

One thought on “Excel Autofill Variations

  1. Why, why click on “article continued here”? Only to view again in full on the next page. How much money are you getting on the first page? I clicked once to view the article only to click again. I have this to say… article continued here

Leave a Reply

Your email address will not be published. Required fields are marked *