Fill Up Cells Quick in Excel

bar_chain

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.

ball.gif  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).

ball.gif  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.

ball.gif  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.

Home button  Back to Office 95/97 MenuOffice 95/97 Tipmenu