To begin automating headers and footers in Excel using VBA, you’ll first need to access the Developer tab. This tab provides the tools necessary to write and run VBA code.

A. In Excel’s custom headers and footers box, the ampersand character (&) is used as a marker to indicate that a special formatting code follows. For example, inserting the characters &[Date]&[Time] ...

If all your document footer needs are page numbers, try this quick field code approach to inserting them. You'll save time and mouse clicks in the process.

Your Excel spreadsheet may look great onscreen, but when you go to print it, headers and footers may be a problem. Mary Ann Richardson explains how to increase margins and include all your data ...