Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 3rd 06, 04:56 PM posted to microsoft.public.excel.newusers
vapor77
 
Posts: n/a
Default Freeze column and row


Can someone please tell me how to freeze a column and a row at the same
time?

Thanks


--
vapor77
------------------------------------------------------------------------
vapor77's Profile: http://www.excelforum.com/member.php...o&userid=31132
View this thread: http://www.excelforum.com/showthread...hreadid=508190


  #2   Report Post  
Old February 3rd 06, 05:05 PM posted to microsoft.public.excel.newusers
Pete
 
Posts: n/a
Default Freeze column and row

If you want Row 1 and column A to be visible on screen all the time as
you scroll around, position the cursor in cell B2 and click Window |
Freeze Panes.

Hope this helps.

Pete

  #3   Report Post  
Old February 3rd 06, 05:15 PM posted to microsoft.public.excel.newusers
vapor77
 
Posts: n/a
Default Freeze column and row


Now that was a lot easier than I thought it would be. Thank you for the
help Pete!


--
vapor77
------------------------------------------------------------------------
vapor77's Profile: http://www.excelforum.com/member.php...o&userid=31132
View this thread: http://www.excelforum.com/showthread...hreadid=508190

  #4   Report Post  
Old February 3rd 06, 05:44 PM posted to microsoft.public.excel.newusers
Pete
 
Posts: n/a
Default Freeze column and row

That's ok, thanks for getting back.

Pete



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



All times are GMT +1. The time now is 01:09 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017