Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how can i freeze first coloumn & first row of exel sheet
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how can i freeze first coloumn & first row of exel sheet
Hi
Select cell B2 then go to Window Freeze Panes. HTH John "sthakur" wrote in message ... |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how can i freeze first coloumn & first row of exel sheet
the only way i see in office 07 is to select view on the top ribbon and then
selct the freeze pane icon- this give you only 3 options- the top row, the top column or unfreeze. thus, i can not select both- only one. How do i get both the top column and far right row BOTH to freeze in 07? "John" wrote: Hi Select cell B2 then go to Window Freeze Panes. HTH John "sthakur" wrote in message ... . |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
how can i freeze first coloumn & first row of exel sheet
It shows UNfreeze because you have already frozen panes. So click
UNfreeze, then select B2 and then Freeze Panes. dshak wrote: the only way i see in office 07 is to select view on the top ribbon and then selct the freeze pane icon- this give you only 3 options- the top row, the top column or unfreeze. thus, i can not select both- only one. How do i get both the top column and far right row BOTH to freeze in 07? "John" wrote: Hi Select cell B2 then go to Window Freeze Panes. HTH John "sthakur" wrote in message ... . |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
how can i freeze first coloumn & first row of exel sheet
To OP, not Bob
What is the "far right row" and "top column"? Are you confused with rows and columns? Rows above and columns left of selected cell will remain frozen. Gord Dibben MS Excel MVP On Wed, 05 May 2010 14:01:39 -0500, Bob I wrote: It shows UNfreeze because you have already frozen panes. So click UNfreeze, then select B2 and then Freeze Panes. dshak wrote: the only way i see in office 07 is to select view on the top ribbon and then selct the freeze pane icon- this give you only 3 options- the top row, the top column or unfreeze. thus, i can not select both- only one. How do i get both the top column and far right row BOTH to freeze in 07? "John" wrote: Hi Select cell B2 then go to Window Freeze Panes. HTH John "sthakur" wrote in message ... . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sort one coloumn according to another coloumn on another worksheet | Excel Worksheet Functions | |||
exel spread sheet | Excel Discussion (Misc queries) | |||
Exel work sheet | Excel Worksheet Functions | |||
How do i add up every other coloumn in a linked sheet | Excel Worksheet Functions | |||
How to make Unique coloumn in Excel sheet ? | Excel Discussion (Misc queries) |