 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / January 2006Fixed Heading
I was wondering is anyone can tell me to how to have a fixed heade row. By that I mean, I have a pretty long spreadsheet. I want the first ro (row 1) that has my headers in it to remain fixed when I go down th page. The rest of the rows (row 2 onwards) need to scroll down when move my scroll bar. thank How about Freezing the row. Click the number 2 on the left, Make sure the row is highlighted then go to Windows/Freeze Pane Hope this helps Larry  Signaturekeithl816 thanks larry.... that's exactly what I needed. Signaturebombayterror your welcome, glad to be able to help Signaturekeithl816 I'm having a similar problem. I have a large spreadsheet, with multiple rows and columns, and I want to freeze columns A,B and C along the horizontal plane, but not the vertical. Conversely I want to freeze rows 1,2 and 3 vertically, but not horizontally. Is this possible? Gord > your welcome, glad to be able to help Try clicking on cell d4 then go to Windows/Freeze Panes Is this what you are trying to do? Larry Signaturekeithl816 I didn't realize that that function worked like that. Thanks, that's exactly what I was trying to achieve. Gord > Try clicking on cell d4 then go to Windows/Freeze Panes Is this what you > are trying to do? > > Larry Hi the "feature" is called "freeze panes" and is found on the window menu. Click in cell B1 choose window / freeze panes from the menu. (to clear just choose window / unfreeze panes) note - this does not affect how the spreadsheet prints (to print a header row use file / page setup / sheet tab - rows to repeat at top). SignatureCheers JulieD julied_ng at hctsReMoVeThIs dot net dot au > I was wondering is anyone can tell me to how to have a fixed header > row. [quoted text clipped - 5 lines] > > thanks |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.