Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I downloaded the inventory sheet and there is a feature which I cannot seem
to duplicate. The first two rows appear to be frozen. The data can be scrolled without the top two lines moving. How do I set this up for other spreadsheets? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
If you want to freeze the top 2 rows, select A3, click on Window, the Freeze
Panes. If you also want to freeze Column A, to be visible when you scroll right, select B3 in stead -- Hth Kassie Kasselman "Grillin'" wrote: I downloaded the inventory sheet and there is a feature which I cannot seem to duplicate. The first two rows appear to be frozen. The data can be scrolled without the top two lines moving. How do I set this up for other spreadsheets? |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Select A1 (so you can see rows 1 and 2)
Select A3 Window|freeze panes. Everything above A3 will be frozen. If you had selected B3, then everything above B3 would be frozen and everything to the left of B3 (column A) would be frozen. And if you have data|Filter applied, show all first--else you may be freezing in the wrong cell. And window|Unfreeze Panes to get rid of it. Grillin' wrote: I downloaded the inventory sheet and there is a feature which I cannot seem to duplicate. The first two rows appear to be frozen. The data can be scrolled without the top two lines moving. How do I set this up for other spreadsheets? -- Dave Peterson |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Goto Tools ~ Options ~ General Tab. Verify that the "At Startu[p..." field is
empty. "Grillin'" wrote: I downloaded the inventory sheet and there is a feature which I cannot seem to duplicate. The first two rows appear to be frozen. The data can be scrolled without the top two lines moving. How do I set this up for other spreadsheets? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I build a excel sheet that counts item in an inventory | Excel Worksheet Functions | |||
Inventory Sheet | Excel Discussion (Misc queries) | |||
Inventory sheet to track, order & reduce quantity from master. | New Users to Excel | |||
how do i set u a inventory sheet for a vending mahine | Excel Discussion (Misc queries) | |||
Inventory Wash-Out sheet | Excel Worksheet Functions |