| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Keep Top Row and Side Column always visible
I have a simple spreadsheet which has many rows, most of which are
outside the visible area on my screen. The top row (number 1) has my column headings, trouble is as soon as you scroll down the headers disappear off the top of the screen. Is there any way to lock them, so they do not scroll with the rest of the sheet. Thanking you in anticipation. Mark in Spain. XP Pro Excel version 2002 XP Office Pro |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Keep Top Row and Side Column always visible
Place the cursor in cell B2 and do Windows Freeze Panes
Vaya con Dios, Chuck, CABGx3 "Anti-Spam" wrote: I have a simple spreadsheet which has many rows, most of which are outside the visible area on my screen. The top row (number 1) has my column headings, trouble is as soon as you scroll down the headers disappear off the top of the screen. Is there any way to lock them, so they do not scroll with the rest of the sheet. Thanking you in anticipation. Mark in Spain. XP Pro Excel version 2002 XP Office Pro |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Keep Top Row and Side Column always visible
On Tue, 15 Jan 2008 12:29:02 -0800, CLR
wrote: Place the cursor in cell B2 and do Windows Freeze Panes Vaya con Dios, Chuck, CABGx3 "Anti-Spam" wrote: I have a simple spreadsheet which has many rows, most of which are outside the visible area on my screen. The top row (number 1) has my column headings, trouble is as soon as you scroll down the headers disappear off the top of the screen. Is there any way to lock them, so they do not scroll with the rest of the sheet. Thanking you in anticipation. Mark in Spain. XP Pro Excel version 2002 XP Office Pro Thanks mate it was driving me nuts. |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Keep Top Row and Side Column always visible
Happy to help............thanks for the feedback
Vaya con Dios, Chuck, CABGx3 "Anti-Spam" wrote: On Tue, 15 Jan 2008 12:29:02 -0800, CLR wrote: Place the cursor in cell B2 and do Windows Freeze Panes Vaya con Dios, Chuck, CABGx3 "Anti-Spam" wrote: I have a simple spreadsheet which has many rows, most of which are outside the visible area on my screen. The top row (number 1) has my column headings, trouble is as soon as you scroll down the headers disappear off the top of the screen. Is there any way to lock them, so they do not scroll with the rest of the sheet. Thanking you in anticipation. Mark in Spain. XP Pro Excel version 2002 XP Office Pro Thanks mate it was driving me nuts. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How2 setup one page distribution report side by side results | Charts and Charting in Excel | |||
| Can you set dual axis side by side column charts? | Charts and Charting in Excel | |||
| Display columns side by Side in the Data Area of a Pivot table | Excel Discussion (Misc queries) | |||
| How do I Move column A, B, etc. to left side. | New Users to Excel | |||
| How do I make a stacked column chart with side-by-side comparison. | Charts and Charting in Excel | |||
Linear Mode
