Freezing a Pane

[BH]

I froze a horizontal pane and it works nicley- Now I want
to be able to print out the frozen colomun as (kinda of a
header column) for each page with data. How do you do
that? Thanks
bh

 

[Chip Pearson]

BH,

Select cell B1 and choose Freeze from the Window menu.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Debra Dalgleish]

To print selected rows on each page --

Choose File>Page Setup
Select the Sheet tab
In 'Rows to Repeat at top', enter the rows, e.g.: $1:$1
Click OK

 

[George Gee]

BH

Courtesy of RWN

If you are referring to having the headings on the pages when printed,
then;
"File->Page Setup->Sheet" and click in the "Rows to repeat at top" box.
If the headings are in Row 1 then enter "$1:$1" (no quotes).
Click "OK"

Whatever range you entered (row 1, in the ex) will automatically print
on each page.

George Gee



*BH* has posted this message:

 

[David McRitchie]

File, Page Setup, Sheet, Columns to Repeat at Left: $A:$A

Debra and George gave you for repeating the row at the top for
printing , but did put you in the correct area.

More information on Freezing Rows/Columns for display
and Repeating Rows/Columns for printing in
http://www.mvps.org/dmcritchie/excel/freeze.htm