|
| 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
January 6th, 2006, 02:30 AM
posted to microsoft.public.excel.newusers
|
|||
|
|||
Fixed Heading
I was wondering is anyone can tell me to how to have a fixed header row. By that I mean, I have a pretty long spreadsheet. I want the first row (row 1) that has my headers in it to remain fixed when I go down the page. The rest of the rows (row 2 onwards) need to scroll down when I move my scroll bar. thanks -- bombayterror ------------------------------------------------------------------------ bombayterror's Profile: http://www.excelforum.com/member.php...o&userid=22855 View this thread: http://www.excelforum.com/showthread...hreadid=498573 
|
|
#2
January 6th, 2006, 03:00 AM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Fixed Heading
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 -- keithl816 ------------------------------------------------------------------------ keithl816's Profile: http://www.excelforum.com/member.php...o&userid=21287 View this thread: http://www.excelforum.com/showthread...hreadid=498573
|
|
#3
January 6th, 2006, 03:16 AM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Fixed Heading
thanks larry.... that's exactly what I needed. -- bombayterror ------------------------------------------------------------------------ bombayterror's Profile: http://www.excelforum.com/member.php...o&userid=22855 View this thread: http://www.excelforum.com/showthread...hreadid=498573
|
|
#4
January 6th, 2006, 03:25 AM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Fixed Heading
your welcome, glad to be able to help -- keithl816 ------------------------------------------------------------------------ keithl816's Profile: http://www.excelforum.com/member.php...o&userid=21287 View this thread: http://www.excelforum.com/showthread...hreadid=498573
|
|
#5
January 6th, 2006, 03:26 AM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Fixed Heading
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). -- Cheers JulieD julied_ng at hctsReMoVeThIs dot net dot au "bombayterror" wrote: I was wondering is anyone can tell me to how to have a fixed header row. By that I mean, I have a pretty long spreadsheet. I want the first row (row 1) that has my headers in it to remain fixed when I go down the page. The rest of the rows (row 2 onwards) need to scroll down when I move my scroll bar. thanks -- bombayterror ------------------------------------------------------------------------ bombayterror's Profile: http://www.excelforum.com/member.php...o&userid=22855 View this thread: http://www.excelforum.com/showthread...hreadid=498573
|
|
#6
January 6th, 2006, 04:08 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Fixed Heading
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 "keithl816" wrote: your welcome, glad to be able to help -- keithl816 ------------------------------------------------------------------------ keithl816's Profile: http://www.excelforum.com/member.php...o&userid=21287 View this thread: http://www.excelforum.com/showthread...hreadid=498573
|
|
#7
January 6th, 2006, 05:11 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Fixed Heading
Try clicking on cell d4 then go to Windows/Freeze Panes Is this what you are trying to do? Larry -- keithl816 ------------------------------------------------------------------------ keithl816's Profile: http://www.excelforum.com/member.php...o&userid=21287 View this thread: http://www.excelforum.com/showthread...hreadid=498573
|
|
#8
January 6th, 2006, 07:22 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Fixed Heading
I didn't realize that that function worked like that. Thanks, that's exactly
what I was trying to achieve. Gord "keithl816" wrote: Try clicking on cell d4 then go to Windows/Freeze Panes Is this what you are trying to do? Larry -- keithl816 ------------------------------------------------------------------------ keithl816's Profile: http://www.excelforum.com/member.php...o&userid=21287 View this thread: http://www.excelforum.com/showthread...hreadid=498573
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How to generate bilingual docments with captions and toc | Markus | General Discussion | 1 | November 19th, 2005 07:11 AM |
| Tab character in table of contents when using heading styles | Rob Nicholson | Page Layout | 4 | December 13th, 2004 10:26 AM |
| Chapter Headings "continued" | db | Formatting Long Documents | 2 | November 5th, 2004 09:34 PM |
| Inserting Outlines into Powerpoint 2000 | Jim | Powerpoint | 2 | September 19th, 2004 04:49 AM |
| promoting/demoting heading styles | la mcgee | General Discussion | 3 | July 27th, 2004 07:17 PM |
Linear Mode
