Add a Custom List to the Fill Handle

Once you have created a few of your own Custom Lists, it can be hard to remember the first item in the list that must be entered in a cell. This tutorial adds the list to the Fill Handle.

Added: 07.06.2010 | | Votes (0) | Category: MS Office / Excel

Address Data by Name

Although cell numbers are at the foundation of everything Excel does, it s much easier to remember names, such as Item Number and Quantity, than it is to remember cell numbers, such as A1:A100. Excel  ...

Added: 07.06.2010 | | Votes (0) | Category: MS Office / Excel

Make Your Formulas Increment by Rows When You Copy

Make Your Formulas Increment by Rows When You Copy Across Columns
Added: 07.06.2010 | | Votes (0) | Category: MS Office / Excel

Create Custom Functions Using Names

Although referencing data by name is convenient, it s sometimes more helpful to store a constant value or even a formula, especially if you ve been creating custom functions in VBA.
Added: 07.06.2010 | | Votes (0) | Category: MS Office / Excel

Fill All Blank Cells in a List

Many of Excel s functions are designed to be used on lists. For most of these functions to work correctly, lists should not contain any blank cells, and column headings should be formatted differentl  ...

Added: 07.06.2010 | | Votes (0) | Category: MS Office / Excel

Sort by More Than Three Columns

Excel s Sort feature is limited in that it enables you to nominate no more than three data fields by which to sort.
Added: 07.05.2010 | | Votes (0) | Category: MS Office / Excel

Random Sorting

The easiest and fairest way to do this is to use Excel s RAND function in combination with its sorting capabilities.
Added: 07.05.2010 | | Votes (0) | Category: MS Office / Excel

Create 3 D Effects in Tables or Cells

It is easy to create this illusion yourself by applying formatting to a cell or range of cells.
Added: 07.02.2010 | | Votes (0) | Category: MS Office / Excel

Highlight Every Other Row or Column

You ve surely seen Excel spreadsheets that have alternating row colors. For instance, odd-numbered rows might be white, while even-numbered rows might be gray. Conditional formatting makes this easy.  ...

Added: 07.02.2010 | | Votes (0) | Category: MS Office / Excel

Identify Formulas with Conditional Formatting

Once a formula is entered into a cell, you can tell whether the cell is a static value or a value derived from a formula only by clicking in each cell and looking in the Formula bar, or by pressing C  ...

Added: 07.01.2010 | | Votes (0) | Category: MS Office / Excel