You can save time by creating an AutoFill series in Excel 2003 as follows: Enter the values and then select the list. Choose Options from the Tools menu. Click the Custom Lists tab. Click Import.

While working with Excel sheets, it is very common to fill increment cells. Increment cells are cells in which numerical values are arranged with a fixed increment value across a column.

If you select the "Fill Series" radio button, Excel fills the cells with dates that increment by one day, starting from the date you typed.

Can Excel sort by color? Absolutely. In addition to sorting by values, Excel can sort by cell color, font color, and cell icon. First, you must you must define the colors for your sort columns ...

Counting records or values in Microsoft Excel is easy. Counting individual cells by their fill color definitely isn't. Using an old function and a matrix tames the problem.