When you print your Excel worksheets, do the headers and
footers print over your data? If so, they may be overriding the worksheet’s
margins. Excel automatically positions headers and footers a half-inch from the
edge of the page and another half-inch from the data. If your header or footer
is more than one line, or if you decrease the top or bottom margins, the header
and footer will likely overrun the margins. You don’t have to reduce the size
of your header and footer to avoid overrun, just increase the margins. Follow
these steps:

  1. Go to File | Print Preview.
  2. Click the Margins button.
  3. Drag the margin indicators up or down to increase the
    bottom and top margins, respectively.
  4. Click Close.

Miss a tip?

Check out the Microsoft Excel archive, and catch up on our most recent Excel tips.

Help users increase productivity by automatically signing up for TechRepublic’s free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.

Subscribe to the Developer Insider Newsletter

From the hottest programming languages to commentary on the Linux OS, get the developer and open source news and tips you need to know. Delivered Tuesdays and Thursdays

Subscribe to the Developer Insider Newsletter

From the hottest programming languages to commentary on the Linux OS, get the developer and open source news and tips you need to know. Delivered Tuesdays and Thursdays