Fill Up Cells Quick in Excel
To fill cells quickly in MS Excel, simply try these steps on for size:
First of all let's try filling in the weekdays Monday through Friday quickly. Select the first cell and enter in the start date. For example, let's say you enter in Monday February 9, 1989 (02/09/89).
Now select the first cell and other cells that you want to fill such as selecting 5 cells in a vertical pattern or horizontal (which ever your desire). If you select more than required you can delete them later.
With all the cells selected, choose Edit, Fill, Series. Now select Date and Weekday and click on OK. The column will fill with the series of dates that represent weekdays in November.
Be sure to try other cell fills to build a quick spreadsheet. Office 95/97 Tipmenu