Software

Office challenge: Can you get Excel's AutoFill feature to fill a range with just workdays - excluding Saturday and Sunday?

This week, show off your Excel expertise and learn the solution to last week's missing Save All command in the 2007 applications.

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:

  1. Click the drop-down arrow at the right end of the QAT and choose More Commands.
  2. Choose Commands Not In The Ribbon from the Choose Commands From drop-down list.
  3. Scroll down and select Save All.
  4. Click Add and then click OK.

I also mentioned that the Save All command isn't available in Excel. Your Excel users will get the same benefit if you add the following macro to the QAT:
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 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.

Editor's Picks