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?
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.
Updating your subscription status