Want to save some typing when working on a Microsoft Excel spreadsheet? Microsoft Excel can automatically continue a series of numbers, number/text combinations, dates or time periods based on a pattern you establish. You can begin a sequence in one cell (such as "Monday") and use the auto-fill feature to continue the sequence in other cells (such as "Tuesday," "Wednesday," etc).

• Enter data in a cell
• Next, drag the bottom right corner...to automatically fill other cells with the rest of the sequence

By dragging the fill handle of a cell, you can continue the data series of a cell to other cells in the same row or column eg.  Mon, Tue, Wed or Day 1, Day 2, Day 3...and so on.

Q.  Ever wondered how to enter numerical data, that starts with zero, in to an Excel spreadsheet?

A. In Excel, cells take on the format 1, 2 etc instead of 001 or 002.  To change this, or similar, use the following steps -

• Click on the cell or cells
• Right click and choose Format Cells
• In the Category tab click Custom
• Click in the 'Type' box, delete what is there and enter 000 (or as many zeros, as you want depending on how many digits are in your data)