Freezing a Pane

  • Thread starter Thread starter BH
  • Start date Start date
B

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
 
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
 
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:
 
Back
Top