View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Stephan Stephan is offline
external usenet poster
 
Posts: 7
Default How do I freeze column names to view when scrolling?

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.