Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Bridgette
 
Posts: n/a
Default freeze horizontal and vertical panes at the same time in Excel


  #2   Report Post  
David McRitchie
 
Posts: n/a
Default

Hi Bridgette,

see http://www.mvps.org/dmcritchie/excel/freeze.htm

To free both row 1 and column A, you select a cell that is
one past each so select cell B2 and then Window (menu), Freeze Panes.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Bridgette" wrote in message ...



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 - turn a page number in a header from horizontal to vertical pbrookstx Charts and Charting in Excel 1 June 4th 05 01:01 AM
How do I get both horizontal and vertical frozen panes in Excell CraigScherer Excel Discussion (Misc queries) 3 April 27th 05 05:22 PM
Excel moving horizontal columns to vertical doulos Excel Discussion (Misc queries) 1 February 4th 05 06:01 PM
how do i freeze a vertical column & horizontal row in excel? Lainey Excel Discussion (Misc queries) 1 February 3rd 05 04:06 PM


All times are GMT +1. The time now is 04:08 AM.

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

About Us

"It's about Microsoft Excel"