You probably know that you can use Excel's AutoFill handle to fill a range with the elements of a series. For instance, to fill a range with the days of the week, simply enter Monday into a cell. Then, click the fill handle and highlight the range you want to fill. Excel will fill that range with the days of the week from Monday through Sunday. Now, what if you want only the days of the work week — Monday through Friday? Can you get Excel's AutoFill handle to do that?
Last week we asked:
Where's the Save All command in Office 2007? Happymedia_dz was the first to mention adding the command to the Quick Access Toolbar (QAT) — and that's what I did as well. The instructions for adding Save All to the QAT follow:
- Click the drop-down arrow at the right end of the QAT and choose More Commands.
- Choose Commands Not In The Ribbon from the Choose Commands From drop-down list.
- Scroll down and select Save All.
- Click Add and then click OK.
Sub SaveAllWorkbooks()
'Save all open workbooks.
Dim wb As Workbook
For Each wb In Workbooks
wb.Save
Next wb
End Sub
It's easy to add a macro to the QAT. Use the above instructions, except in step 2, choose Macro. Then, highlight the macro in question.
Have you added any macros to the QAT? Consider starting a new thread and sharing those macros with the rest of us!
About Susan Harkins
Susan Sales Harkins is an IT consultant, specializing in desktop solutions. Previously, she was editor in chief for The Cobb Group, the world's largest publisher of technical journals.
Full Bio
Susan Sales Harkins is an IT consultant, specializing in desktop solutions. Previously, she was editor in chief for The Cobb Group, the world's largest publisher of technical journals.
