converting website visitors
Microsoft Office Tip & Tricks Menu
Tip & Tricks Menu

Autofilling Dates in Excel

Tuesday August 5, 2014 at 10:06am
Do you ever need to enter dates of all working days in your spreadsheet? Try entering a date into a cell, and then use the autofill handle to fill down or across. Initially, Excel will include all dates, including weekends, but you can change this by using the Autofill Options button. This button appears to the right of the last filled cell. Click on the Autofill Options button and select the Fill Weekdays option.
» Categories: Microsoft Excel


There aren't any comments for this post yet. Why not be the first to comment?

Leave a Comment

Your Name
Email Address (kept hidden)

So that we can check that you are a real person (and not a crafty computer),
answer this simple sum:

What is 13 - 2?
Intec Business Colleges - Established For Over 30 Years
Microsoft Office Specialists - Approved Microsoft Courseware
Intec Business Colleges Ltd, Old School, Pennington Court, Rugby, Warwickshire, CV21 2BB, UK. VAT Number: 695223026 Company Number: 2494959
tel:01788 575090 fax:01788 575411
Website Design by ZARR Ltd