Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Roll Up
If on a Worksheet in col.A I have dates and col.B Items description and
several other cols. are occupied by figures in three cols. per year, is there a way of "Rolling Up" vertically the data starting with col.C as can be "Rolled Up" horizontally under the headings, so that I can use the information in cols. A & B when I have to shift the sheet to the left, when more cols. are not available? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Roll Up
Hi,
I think you are talking about freeze panes, If you select cell C1 and set freeze panes then rows 1 and 2 will be frozen. If you select cell C3 and set freeze panes then rows 1 and 2, and columns A and B will be frozen. In other words anything above and to the left of the selected cell will be frozen. HTH Martin "Zygy" wrote in message ... If on a Worksheet in col.A I have dates and col.B Items description and several other cols. are occupied by figures in three cols. per year, is there a way of "Rolling Up" vertically the data starting with col.C as can be "Rolled Up" horizontally under the headings, so that I can use the information in cols. A & B when I have to shift the sheet to the left, when more cols. are not available? |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Roll Up
Woops let's try that again!
I think you are talking about freeze panes, If you select cell A3 and set freeze panes then rows 1 and 2 will be frozen. If you select cell C3 and set freeze panes then rows 1 and 2, and columns A and B will be frozen. In other words anything above and to the left of the selected cell will be frozen. HTH Martin |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Roll Up
Many thanks. This will do very nicely.
"MartinW" wrote in message ... Woops let's try that again! I think you are talking about freeze panes, If you select cell A3 and set freeze panes then rows 1 and 2 will be frozen. If you select cell C3 and set freeze panes then rows 1 and 2, and columns A and B will be frozen. In other words anything above and to the left of the selected cell will be frozen. HTH Martin |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
roll up a calendar in excel | Excel Worksheet Functions | |||
how can we compare name and roll no lists | New Users to Excel | |||
How to roll up the group of lines? | Excel Discussion (Misc queries) | |||
roll data up from cell | Excel Discussion (Misc queries) | |||
rent roll | Excel Discussion (Misc queries) |