Excel: Printing with Headers on Each Page

On the heels of yesterday’s post on Freezing rows and columns, today’s post is on printing with columns and/or rows repeated on each page in Excel.

It’s pretty easy –

For 2007 and 2010:

  • Decide which column(s) and/or row(s) you want to repeat
  • Click on the “Page Layout” tab. A box will pop up that you may recognize from earlier versions of Excel “Page Setup” (below)

  • Click on the grid icon to the right end of the line “Rows to repeat at top,” and select the row you want to repeat. (Excel fills in the information in the box automatically.) Do the same for “Columns to repeat at left.”
  • Click Print Preview or Print.

For earlier versions:

Go to “File”, then “Page Setup” and follow the steps after the screen pictured above.

Hope this was helpful. Please subscribe and comment!

Thanks for coming by!


Leave a comment

Filed under MS Excel

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s