On the Layout tab, under Print , select the Headings check box.
You can see how your sheet will print before you print it by clicking Preview. On the Layout tab, under Print , click Repeat Titles. Click in the Columns to repeat at left box, and then on the sheet, select the column that contains the row titles. Under Print titles , click in the Rows to repeat at top box, and then on the sheet, select the row that contains the column titles. Print part of a sheet. Print with landscape orientation. Scale the sheet size for printing.
Preview pages before you print. Print row and column headings Click the sheet.
How to print row and column headers of Excel spreadsheets on every page
On the File menu, click Print. Freeze or lock rows and columns in an Excel worksheet. Scale your spreadsheet to fit on one page when printing from Excel. Search for a lesson. Similar lessons Print an Excel spreadsheet with page numbers. Join our mailing list Get smarter in just five minutes! Join our mailing list it's free! I want to learn more about: Microsoft Excel. Microsoft Word. Google Analytics. Google Adwords. Facebook Marketing. Our Comment Policy. Add a comment to this lesson.
- top 5 scariest games for mac!
- How to freeze header rows in Excel.
- How to Repeat Specific Rows or Columns on Every Printed Page in Excel!
- Office 2011 for Mac All-in-One For Dummies;
- Repeat specific rows or columns on every printed page.
Comments on this lesson Concise and complete. I'm bookmarking this website. Notify me when new comments are posted. All comments.
How do you create column headers in Excel?
Replies to my comment. Web page addresses and e-mail addresses turn into links automatically. Lines and paragraphs break automatically. Related files optional. You can share the file you are working on by uploading it here. Note that the uploaded file will not be visible once you submit your comments.
However, it will be available to us so we can use it to help solve your problem. Files must be less than 1 MB. Reply to: Repeat as header row at the top of each page - Not working.
Print headings or titles on every page - Excel for Mac
This post has been flagged and will be reviewed by our staff. Thank you for helping us maintain CNET's great community. Sorry, there was a problem flagging this post.
- Related articles:.
- Print row or column titles on every page.
- boot mac pro from cd!
- flash movie not loaded mac!
Please try again now or at a later time. If you believe this post is offensive or violates the CNET Forums' Usage policies , you can report it below this will not automatically remove the post.
Once reported, our moderators will be notified and the post will be reviewed. Disruptive posting: Flaming or offending other users Illegal activities: Promote cracked software, or other illegal content Offensive: Sexually explicit or offensive language Spam: Advertisements or commercial links. Prev 1 2 Next. Does this happen Repeat as header row at the top of each page. Table disconnect? How do you disconnect the main table from the previous one with the gridlines described? RE: Table disconnect?
I selected the relevant rows, Ctrl-X then Ctrl-V into a separate area on the page.
Re: thanks. That solved the problem! I've been fighting with that problem for a while now and your solution fixed the issue. And if all else fails Thanks Mathlion, that worked! Thank you for this solution! Your solution worked A little more information. Word Here's how to fix it. Thanks a lot. Your solution worked for me. NT Brilliant!
Works great in Crapola Word This worked for me Good call. MS should show a message. Another potential solution. Check to make sure you're table isn't "nested" in another. Same issue another solution. Discussion Type.