Printing titles

rlovingjr

New Member
Joined
Feb 28, 2002
Messages
12
Why is it that sometimes the boxes for Rows to repeat at top and columns to repeat at left are ghosted and other times they are not?? These option are located in the print setup window on the sheet tab.
 

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.
When you activate page setup from within print preview, there are a few changes that are inaccessible (print titles, print area, whether to print comments). When you activate page setup directly, all features are available.

I hope that it made sense to the programmers, because it seems silly now.
 
Upvote 0
It does seem silly - I found that if I highlight the rows I want to print on each page and then activate print setup it allows me to establish rows to print at the top of each page.

Big run on sentence - yikes anyway thanks for the information
 
Upvote 0

Forum statistics

Threads
1,214,384
Messages
6,119,201
Members
448,874
Latest member
Lancelots

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