Print titles - basic question

G

Gordon Abbot

The "print titles" option under page setup/sheet is grayed out. How can
I get it to work since I have multiple sheets that I need to carry over
the titles when I print out the sheets?

The titles I need are not in the first column or row. I see how it is
done if it was available.

GA
 
S

swatsp0p

If you are accessing Page Setup from the Print Preview screen, thos
options will be grayed out. You need to access it from the main menu
File>Page Setup | Sheet.

Does this work for you
 
A

Art®

I recently came up against the same problem. My question is, why does Excel
gray out the options when viewed from Print Preview? It seems to let you
make just about any other change from that view, why not the print area or
print titles?

Art
 
B

Bernard Liengme

I expect because it would take too much work to 'redraw' the existing print
preview screen.
 
G

Gordon Abbot

swatsp0p said:
If you are accessing Page Setup from the Print Preview screen, those
options will be grayed out. You need to access it from the main menu:
File>Page Setup | Sheet.

Does this work for you?
Click to expand...
Yep. I was accessing it from print preview, since I do most of my page
setup there.

Did not think to use the FILE/page setup since I thought it would be
grayed out there too.

Thanks.
GA
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

comparing 2 columns 8
Disabled "Print column or row titles on every page" on the sheet tab in page setup. 4
Print titles must be contiguous and complete rows or columns 3
Color of sheet tabs question please 2
Repeat the titles across multiple sheets of a workbook. 6
imposiible to print comments, neither titles 3
Print Page Setup|Sheet 3
Keeping column titles for each printed page 2

Top