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

Comments

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)
  
Website
 
Comment
  

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

What is 18 - 7?
  
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 email:tracey.chaplin@getoncourse.net
Website Design by ZARR Ltd