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!