At times, you will want to enter the same information repeatedly in a spreadsheet.
It could be employee names, products or State names.
Here is a way to produce the information when needed.
Make a list of the items.
Enter the data in, say, A1, B1, C1 etc.
Be sure to enter in the right order; maybe Supervisor and then team members in alphabetic order.
Select all of the cells.
Go to Tools>Options and choose the Custom lists tab.
OK your way out.
Now you can delete the entries on the spreadsheet.
Choose any cell and type one of the items that are on your Custom List.
Click and drag on the fill handle; the tiny square at the bottom right corner of the selected cell.
As you pull, Excel will duplicate your list.
(In Excel 2007+, go to the Office Logo. Choose Excel Options. Edit Custom Lists will be on the Popular page.)
The First Shall Be Last
by Dick Kusleika
Sorting by Color
by Chip Pearson
See all Topics