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

Excel in Practice

A common task in Excel is applying custom headers and footers to a sheet in a workbook. To record the macro, follow these steps:

  1. Turn on the Macro Recorder. Store this macro in the Personal Macro Workbook, and call it CustomHeaderFooter or something similar.

  2. Choose File, Page Setup to open the Page Setup dialog box. Then, use the Custom Header and Custom Footer buttons to set the headers and footers (see Figure 31.22).

    Figure 31.22. Set the header and footer using the Custom Header and Custom Footer buttons.

  3. Stop the recorder.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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