How to repeat column names on printed pages

K

keithmc

New Member
Joined
Sep 15, 2010
Messages
2
I am wondering how to repeat column names on printed pages for a multi page printout in Excel 2010.

This is under File Print --->Page Setup ---> print titles "rows to repeat at top" is not accessible.
 

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).
Sort by date Sort by votes
I found the answer. You go into Page Layout in the header and click Print Titles --- then you can change it.
Thanks
 
Upvote 0
You must log in or register to reply here.

Similar threads

N
  • Solved
Delete Name Ranges Except Print Area and Print Titles
Replies
8
Views
272
nhinx
N
Skrej
  • Question Question
Random page margin spilling over
Replies
4
Views
178
Skrej
Skrej
S
  • Question Question
VBA code to determine InDesign Layout
Replies
6
Views
344
Akuini
Akuini
A
  • Question Question
VBA for setting up the printing pages per sheet
Replies
0
Views
398
Aurum1
A
R
  • Question Question
[VBA] - Need to add File Location and Print Page Setup in Extract PDF Sub
Replies
3
Views
229
Domenic
D

Forum statistics

Threads
1,222,902
Messages
6,168,938
Members
452,227
Latest member
sam1121

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top