|
|
|
Find out how to save time using AutoFill instead of retyping words
Q I use an Excel spreadsheet to record events that only
happen on week days. It would be good to use AutoFill to save the inconvenience
of typing in every date by hand. But AutoFill includes weekends. Is there a way
to change this?
Tony Dickson
A There is, but the change is made after using AutoFill to add the information to the spreadsheet.
Type the first date into the first cell and move the mouse to the bottom-right corner of the cell. There will be a small black square in the corner and the cursor will change to a cross when it is in the right place.
Press and hold down the left mouse button and drag the mouse down to fill all the cells with the dates. Let go of the mouse button and a new icon will appear at the bottom-right of the cells.
Left-click on this and then on the Fill Weekdays option. Excel will automatically remove all the weekend dates from the list. This menu can also be used to fill a list with the same day of every month or year.
Article tags
Related articles
Shut down Windows 8 faster, get the Start button back, play DVDs, get email working, tweak Internet Explorer and more
Learn how to add and manage information effectively using Microsoft Word tables
Try our secret Office tricks to get more from the document, spreadsheet and presentation tools and programs you use most often
Content Recommendation
Q.Why is Windows Backup skipping files?
Q.Why do my scanned documents display gibberish?
Q.How can I convert MTS files to edit in Windows Movie...
Updating your subscription status 
Save money by switching to fast 3G broadband
