View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Nelson[_2_] Nelson[_2_] is offline
external usenet poster
 
Posts: 2
Default 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.