Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ann in Italy
 
Posts: n/a
Default Keeping first line visible

I would like to keep the first line of my excel sheet visible when I scroll
down. I can't figure this out.
  #2   Report Post  
Posted to microsoft.public.excel.misc
Paul Mathews
 
Posts: n/a
Default Keeping first line visible

If the first line of your spreadsheet is row 1, then click on cell A2, then
click WindowFreeze Panes

"Ann in Italy" wrote:

I would like to keep the first line of my excel sheet visible when I scroll
down. I can't figure this out.

  #3   Report Post  
Posted to microsoft.public.excel.misc
starguy
 
Posts: n/a
Default Keeping first line visible


point your mouse below the row you want visible then in Window menu,
click Freeze Panes.
this is done what you want.


Ann in Italy Wrote:
I would like to keep the first line of my excel sheet visible when I
scroll
down. I can't figure this out.



--
starguy
------------------------------------------------------------------------
starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=552184

  #4   Report Post  
Posted to microsoft.public.excel.misc
Ann in Italy
 
Posts: n/a
Default Keeping first line visible

PAUL THANK YOUUUUUUUUUUUUUUUUUUUU!!!!!!

"Paul Mathews" wrote:

If the first line of your spreadsheet is row 1, then click on cell A2, then
click WindowFreeze Panes

"Ann in Italy" wrote:

I would like to keep the first line of my excel sheet visible when I scroll
down. I can't figure this out.

  #5   Report Post  
Posted to microsoft.public.excel.misc
starguy
 
Posts: n/a
Default Keeping first line visible


follow paul because I missed to tell you to point your cursor in First
Colums i-e Col A below the row you want visible.


--
starguy
------------------------------------------------------------------------
starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=552184

Reply
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
Excel 2003 - Drawing a Simple Line - Dissapears SCPU173 Excel Discussion (Misc queries) 0 March 12th 06 11:48 PM
Line Chart Aurora Charts and Charting in Excel 3 February 16th 06 11:24 PM
10 000 Line, every 2 Lines need a border and a open line inbet. e. annalie Excel Discussion (Misc queries) 2 January 30th 06 03:15 PM
A 2 line text showing up in the Cell in Excel prints in 1 line Danny Excel Discussion (Misc queries) 6 July 12th 05 08:47 PM
pivot table multi line chart souris Charts and Charting in Excel 2 December 7th 04 03:56 AM


All times are GMT +1. The time now is 05:44 PM.

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"