If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
freeze horizontal and vertical panes at the same time in Excel
|
#2
|
|||
|
|||
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 ... |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How do I get both horizontal and vertical frozen panes in Excell | CraigScherer | General Discussion | 3 | April 27th, 2005 05:22 PM |
how do i freeze a vertical column & horizontal row in excel? | Lainey | General Discussion | 1 | February 3rd, 2005 04:06 PM |
horizontal to vertical | JR | General Discussion | 0 | July 12th, 2004 03:15 PM |
Page Setup: Horizontal and Vertical Page Alignment | Frustrated | Page Layout | 1 | April 26th, 2004 06:22 PM |
freeze panes?? | Peter | Worksheet Functions | 4 | November 23rd, 2003 01:16 AM |