Excel Digest

  Excel help for the rest of us

Archive for March, 2008

31 Mar

Automatically fill data in adjacent cells (Autofill)

You can save yourself allot of typing if you know how to make use of autofill feature in Excel.
Suppose you want to enter names of days in cells A1 to A7 (Sun, Mon, …. Sat). Here is what you do:

Enter “Sun” on cell “A1”.
Drag the fill handle across the [...]

29 Mar

How to create a custom date format

Excel provides a vast number of common date formats. However if you do need a format that is not included in the built-in list then you can create your own custom format as follows:

Right-click on the cell where the date is.
Select Format Cells.
When the dialogue box opens select the Number tab.
In the Category [...]

© 2008 Excel Digest | Entries (RSS) and Comments (RSS)

GPS Reviews and news from GPS Gazettewordpress logo