Dreevoo.com | Online Learning and Knowledge Sharing
 
Home | Programs | Microsoft Office | Microsoft Excel | How to make titles visible on every page you print
Guest
Click to view your profile
Topics
Programs
Languages
Recipes
Home
Shortcuts
 
 

How to make titles visible on every page you print

If you want your main Excel column or row visible on every page you print out to make the data easier to read, this is what you need to do.

 
  Author: mat | Version: 2010 | 4th February 2013 |  
 
 
1.
 

In the print preview pane the first page has the title row included ...

 
 
2.
 

... the next page doesn't and when you have a large number of columns and pages it can make the reading quite difficult.


 
 
3.
 

To have the main column or row visible on all printed page, click Page Layout in the menu and then click Print Titles button (see picture).

 
 
4.
 

In the Page Setup window, click the Rows to repeat at top entry field ...

Click the Columns to repeat at left if you want the columns to be visible on every printed page.

 
 
5.
 

... and select the column (row) or cells you want to be printed out on every page.

 
 
6.
 

When you are done selecting, click OK.

 
 
7.
 

That's all.

If you now go back to the print preview (File, Print) and scroll to the second, third,... page of you excel document, there should be the columns or rows you selected visible on every page and as such ready to be printed out.

 
 
 
   
  Please login to post a comment
  Click to open user profile  
eracmenk33, 18th Oct 2025, 3:17 PM
That’s a handy Excel trick—keeping titles visible on every printed page definitely improves clarity when handling large data sheets. Speaking of keeping things clear and organized, https://dnkndonutsmenuph.com/ makes it just as easy to browse Dunkin Donuts’ breakfast menu, with neatly listed prices, combos, and calorie details for every item. Both approaches make sure you never lose track of what matters most, whether it’s your data or your favorite donut choice.
 
 
  Click to open user profile  
Zoyashah, 18th Oct 2025, 4:04 PM
Lock repair provides expert locksmith solutions for residential, commercial, and automotive needs, ensuring your security is never compromised. From emergency lockouts to precision lock repairs, skilled professionals deliver fast and dependable service. Just like learning how to make titles visible on every page you print improves clarity and presentation, proper lock maintenance enhances safety and reliability. Trust Lock repair for efficient, professional service that keeps your property secure and worry-free every day https://lockandkeybradford.co.uk
 
 
  Click to open user profile  
Zoyashah, 19th Oct 2025, 8:52 PM
Door Locks and Handles are essential for both security and style in every home or business. From modern finishes to classic designs, the right hardware adds functionality and elegance to any door. Just like learning how to make titles visible on every page you print ensures consistency and clarity, choosing quality door locks and handles guarantees durability, safety, and visual appeal. Invest in trusted hardware to enhance comfort and protection effortlessly. https://locksandhardwaredirect.co.uk/
 
   
 
 
online learning made for people
Dreevoo.com | CONTRIBUTE | FORUM | INFO