Custom Lists

By default Excel contains some built-in lists that can be used for auto-filling cells when you drag a pointer. You can type 1 in a cell and 2 in the cell below. If you select the two cells you can then drag then pointer down while holding down the left mouse button Excel will add numbers in sequence, one for every cell you highlight.

Days of the week and months can also be auto filled in thanks to the built in lists.


You can also customize lists based on your own specific needs. Let’s say you have a set list of items your company produces and you seem to need to add them to your worksheets on a regular basis. Just as with the number example above you can create your own custom list.

In 2007 - From the Office Button select Excel Options

Select the Popular tab and then click on the Edit Custom Lists button.

Just type your list in the List entries window then click the add button. Your list will then display in the Custom Lists window. When done click the OK button.

How can you use custom lists to make your daily job a bit easier?

Change Default Font and Number of tabs

By default Excel will display 3 sheet tabs when you open a workbook. You can then add or delete tabs as needed. Some users never use all three tabs while others use more then 3.

Well you can modify how many tabs open by default.

In 2007 From the Office Button select Excel Options

Select the Popular tab and change the “include this many sheets” number.

You can also change the default font and font size from the popular tab.