LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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.




 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Keeping column name in view when scrolling Geoman Excel Worksheet Functions 2 July 27th 07 05:44 AM
picture disappears from view when scrolling. KimnJasonG Excel Discussion (Misc queries) 9 March 8th 07 03:51 AM
???is there a way to keep one row in view while scrolling down??? Jennie Excel Worksheet Functions 1 July 14th 05 09:32 PM
View row headers while scrolling Newsgirl Excel Discussion (Misc queries) 2 April 22nd 05 05:48 PM
Can you keep column (field) names visible while scrolling downwar. MichaelG1947 Excel Worksheet Functions 4 January 13th 05 02:50 AM


All times are GMT +1. The time now is 07:34 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"