• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 29. Recording and Editing a Macro > Macros to Help You Work Faster

Macros to Help You Work Faster

This section provides some helpful suggestions for macros that can speed up your work. Be sure to store them in the Personal Macro Workbook so that they'll be available for playback in all your workbooks. Consider assigning each a keyboard shortcut or toolbar button for faster playback.

  • Print the current region. This macro selects all the cells in the current region and prints them. The current region is defined as a range of contiguous cells bounded by blank columns and blank rows (or positioned at the edge of the worksheet). When recording this macro, use Edit, Go To, click the Special button, and select Current Region to select the current region.

    Author's Note

    To take full advantage of the "print current region" macro, don't include any blank spacing rows or columns between titles, subtitles, or within the data. If you need to add spacing, change row heights and column widths instead.


  • AutoFormat. Record a macro to apply your favorite AutoFormat for quick and professionally formatted worksheets. You can record the macro one of two ways: It can apply an AutoFormat to the current selection or apply it to the current region. As you may know, if a range of cells is selected, the AutoFormat command applies the AutoFormat to the selection. If a single cell is selected, the AutoFormat command applies an AutoFormat to the current region. Regardless of how you choose to record it, select a range or single cell before you turn on the recorder.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint