| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Column Headings Scroll out of view
Hi,
How can I get my column headings to stay put when I scroll up and and list? Thanks in Advance G |
|
#2
|
|||
|
|||
|
Select A2 (usually), and hit Window--Freeze Panes. Everything above the
selected cell will freeze in place; everything to the left will freeze in place. ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "Grd" wrote in message ... Hi, How can I get my column headings to stay put when I scroll up and and list? Thanks in Advance G |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Column Headings Scroll out of view
The first time that I tried this in Sheet 1 it works - i.e., freezes top and
left side of page. Then in Sheet 2 I tried to repeat and it only freezes the top and not also the left side of the page. What has gone wrong? Georgea "Anne Troy" wrote: Select A2 (usually), and hit Window--Freeze Panes. Everything above the selected cell will freeze in place; everything to the left will freeze in place. ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "Grd" wrote in message ... Hi, How can I get my column headings to stay put when I scroll up and and list? Thanks in Advance G |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Column Headings Scroll out of view
If you want to freeze row 1 and column A you would select cell B2 before
freezing. If you selected A2, only row 1 would be frozen. tyro "Georgea" wrote in message ... The first time that I tried this in Sheet 1 it works - i.e., freezes top and left side of page. Then in Sheet 2 I tried to repeat and it only freezes the top and not also the left side of the page. What has gone wrong? Georgea "Anne Troy" wrote: Select A2 (usually), and hit Window--Freeze Panes. Everything above the selected cell will freeze in place; everything to the left will freeze in place. ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "Grd" wrote in message ... Hi, How can I get my column headings to stay put when I scroll up and and list? Thanks in Advance G |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Column Headings Scroll out of view
Select B2 if you want to freeze row 1 and column A
Rule is: everything above and to the left of the selected cell will be frozen when you WindowFreeze Panes Gord Dibben MS Excel MVP On Sun, 6 Jan 2008 14:53:01 -0800, Georgea wrote: The first time that I tried this in Sheet 1 it works - i.e., freezes top and left side of page. Then in Sheet 2 I tried to repeat and it only freezes the top and not also the left side of the page. What has gone wrong? Georgea "Anne Troy" wrote: Select A2 (usually), and hit Window--Freeze Panes. Everything above the selected cell will freeze in place; everything to the left will freeze in place. ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "Grd" wrote in message ... Hi, How can I get my column headings to stay put when I scroll up and and list? Thanks in Advance G |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Scroll the screen view with the scroll bar | Excel Discussion (Misc queries) | |||
| Renaming Column Headings | Excel Discussion (Misc queries) | |||
| How to hide the column headings displayed by Excel at the left of. | Excel Discussion (Misc queries) | |||
| copy excel worksheet into msword with row, column headings and gr. | Excel Discussion (Misc queries) | |||
| how do you change column headings in excel? | Excel Discussion (Misc queries) | |||
Hybrid Mode
