Microsoft Office Tutorials and References
In Depth Information
Create a Custom Fill
Timesaver
To quickly fill a cell with the contents of the cell above or to the left of
it, press Ctrl+D or Ctrl+R.
Did You Know?
You can suppress AutoFill. Hold down Ctrl while you drag the fill
handle of a selection of two or more cells. The values are copied to the
adjacent cells, and Excel does not extend a series.
Create a Custom Fill
If you want to use an existing list, select the list of items.
Click the File tab, and then click Options .
In the left pane, click Advanced .
Click Edit Custom Lists .
Click the option you want.
New list. Click NEW LIST , type the entries you want, press Enter after
each. Click Add .
Existing list. Verify the cell reference of the selected list that appears in the
Import list, and then click Import .
Click OK , and then click OK again.
Search JabSto ::




Custom Search