Freezing pains

J

John Wilson

Jason,

I have freezing pains everytime I have to shovel snow.

To freeze both the column and row select the cell directly
to the right and directly below where you want the pane frozen.
Then from the menu bar ... Window/Freeze Panes

John
 
P

PTT, Inc.

Can't do it that I know of. You can set the "freeze" for both, but as you
scroll only one will stay put. I would assume you know this, but if Row 1
and Column A are your items to freeze, place your cursor in B2, click
"Window", "Freeze Panes".

I do like the Freudian slip though (pains)! HA!

Bill Foley
www.pttinc.com
 
G

GerryK

Highlite the cell where you want the freeze to take place
below the row and to the left of the column. Go
to 'Windo' 'Freeze panes' on the tool bar.
HTH
 
K

Ken Wright

Click on any cell and hit Window / Freeze Panes, and then both the rows and the
columns to the left and above will be frozen.
 

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

Freeze Panes loss 3
Macro to Select text from a point given to a specific word 2
Unable to freeze panes 15
freeze column and row on same spread sheet 2
WHY IS FREEZE PAINS GREYED OUT 8
Dragging a formula in a column 1
I selected row 1 and row 2 to freeze and it is freezing at row 12 2
Format column widths from one table to a separate table on same page 1

Top