ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   print headings ? (https://www.excelbanter.com/excel-discussion-misc-queries/162781-print-headings.html)

Boswell

print headings ?
 
I have wrksht, labels for cols along top.
About 50 lns down: a selcted, (rect box), group of cells.

After trying various methods, I still am unable to have the col names print
with the selection.

Any tips?

--
Boswell

Bernard Liengme

print headings ?
 
If you are speaking of labels that you typed into the top row(s)
This being so, use File | PageSetUp ; open Sheet tab; fill in Rows to
Repeat at Top by clicking on the row(s) you want to repeat.

If on the other hand you want the A,B,C column names:
use File | PageSetUp ; open Sheet tab; click the box called Row and Column
Headings

best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Boswell" wrote in message
...
I have wrksht, labels for cols along top.
About 50 lns down: a selcted, (rect box), group of cells.

After trying various methods, I still am unable to have the col names
print
with the selection.

Any tips?

--
Boswell





All times are GMT +1. The time now is 10:49 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com