How do I freeze column names to view when scrolling?
Hi Stephan,
Put your cursor where you are wanting the column/row frozen at, then click
window/freeze panes. i.e. if you are wanting the first row to stay there as
well as column A & B, put your cursor in cell C2. That will freeze both the
first row as well as columns A & B from moving.
Hope that helps.
Tami
"Stephan" wrote in message
...
Aloha Julie,
I tried to freeze a column and a row and it will only freeze one. I cannot
get them both to freeze. Do you have any suggestions?
Thanks,
Stephan
"JulieD" wrote:
Hi Tom
click in the first cell under your titles (ie A2) choose window / freeze
panes
use window / unfreeze panes to remove
you can also freeze columns & rows at the same time - click underneath &
to
the right of what you want to stay "frozen" and then use the window /
freeze
panes menu option.
Cheers
JulieD
"Tomt39" wrote in message
...
I have created some large lists on a spreadsheet. I would like the
titles
of
the columns to stay in view as I scroll down but cannot find how to do
this.
|