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
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".
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
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.
