How do I freeze two different rows in same sheet.


--
Naidu

You can't


--


Regards,


Peo Sjoblom




"Naidu" wrote in message
...
How do I freeze two different rows in same sheet.


--
Naidu

Put the two rows together at the top of the sheet.
--
David Biddulph

"Naidu" wrote in message
...
How do I freeze two different rows in same sheet.


--
Naidu

Hi,
If i've to create a hierarchial structure within excel sheet...like
A
a1
a2
a3
B
b1
b2
b3

So, as I scroll down the row heading A has to be retained and as we proceed
down, B should also be retained...How can I do this?
--
Naidu


"David Biddulph" wrote:

Put the two rows together at the top of the sheet.
--
David Biddulph

"Naidu" wrote in message
...
How do I freeze two different rows in same sheet.


--
Naidu

Naidu,

as the previous posters said you can't do that in basic excel (well, not
EXACTLY)

However you could do something similar. I'm not sure which version of Excel
you are using, so I've put a couple of ideas in:
- The best thing is probablt to group the data together using Outlining.
Basically this will give you a little + or - box next to Item A and Item B.
If you click the - button next to A then rows a1, a2, a3 will be hidden and
pressing the + will show them again. You can have all the rows visible, or
just the headings, or any combination of groups you need at any time.
Note that your headings will always be visible all the time, but this does
sound like your best bet. Outline is something it's maybe best to learn and
difficult to follow on a brief posting. To learn how to use outline I'd
suggest having a look at help or the following part of the microsoft site:
http://office.microsoft.com/en-us/ex...CL100570551033
If you try this and find problems then send in your a note of where you are
getting stuck and maybe someone can help move you forward.
- If you can't use outline then you are going to have to freeze or split
your sheet multiple times. Freeze or split Heading A, then when you get to
Heading B make a note of the cell reference. You should unfreeze/remove
split and then you can use GoTo to get back to Heading B quite quickly.

I guess the best solution for you will depend on how often you use the
sheet, how many other people use it, how long you would be keeping it for etc.

Good Luck.
M-A

"Naidu" wrote:

Hi,
If i've to create a hierarchial structure within excel sheet...like
A
a1
a2
a3
B
b1
b2
b3

So, as I scroll down the row heading A has to be retained and as we proceed
down, B should also be retained...How can I do this?
--
Naidu


"David Biddulph" wrote:

Put the two rows together at the top of the sheet.
--
David Biddulph

"Naidu" wrote in message
...
How do I freeze two different rows in same sheet.


--
Naidu

I am trying on it !
Thanks a lot !
--
Naidu


"M-A" wrote:

Naidu,

as the previous posters said you can't do that in basic excel (well, not
EXACTLY)

However you could do something similar. I'm not sure which version of Excel
you are using, so I've put a couple of ideas in:
- The best thing is probablt to group the data together using Outlining.
Basically this will give you a little + or - box next to Item A and Item B.
If you click the - button next to A then rows a1, a2, a3 will be hidden and
pressing the + will show them again. You can have all the rows visible, or
just the headings, or any combination of groups you need at any time.
Note that your headings will always be visible all the time, but this does
sound like your best bet. Outline is something it's maybe best to learn and
difficult to follow on a brief posting. To learn how to use outline I'd
suggest having a look at help or the following part of the microsoft site:
http://office.microsoft.com/en-us/ex...CL100570551033
If you try this and find problems then send in your a note of where you are
getting stuck and maybe someone can help move you forward.
- If you can't use outline then you are going to have to freeze or split
your sheet multiple times. Freeze or split Heading A, then when you get to
Heading B make a note of the cell reference. You should unfreeze/remove
split and then you can use GoTo to get back to Heading B quite quickly.

I guess the best solution for you will depend on how often you use the
sheet, how many other people use it, how long you would be keeping it for etc.

Good Luck.
M-A

"Naidu" wrote:

Hi,
If i've to create a hierarchial structure within excel sheet...like
A
a1
a2
a3
B
b1
b2
b3

So, as I scroll down the row heading A has to be retained and as we proceed
down, B should also be retained...How can I do this?
--
Naidu


"David Biddulph" wrote:

Put the two rows together at the top of the sheet.
--
David Biddulph

"Naidu" wrote in message
...
How do I freeze two different rows in same sheet.


--
Naidu

you're welcome; Keep us posted!

"Naidu" wrote:

I am trying on it !
Thanks a lot !
--
Naidu


"M-A" wrote:

Naidu,

as the previous posters said you can't do that in basic excel (well, not
EXACTLY)

However you could do something similar. I'm not sure which version of Excel
you are using, so I've put a couple of ideas in:
- The best thing is probablt to group the data together using Outlining.
Basically this will give you a little + or - box next to Item A and Item B.
If you click the - button next to A then rows a1, a2, a3 will be hidden and
pressing the + will show them again. You can have all the rows visible, or
just the headings, or any combination of groups you need at any time.
Note that your headings will always be visible all the time, but this does
sound like your best bet. Outline is something it's maybe best to learn and
difficult to follow on a brief posting. To learn how to use outline I'd
suggest having a look at help or the following part of the microsoft site:
http://office.microsoft.com/en-us/ex...CL100570551033
If you try this and find problems then send in your a note of where you are
getting stuck and maybe someone can help move you forward.
- If you can't use outline then you are going to have to freeze or split
your sheet multiple times. Freeze or split Heading A, then when you get to
Heading B make a note of the cell reference. You should unfreeze/remove
split and then you can use GoTo to get back to Heading B quite quickly.

I guess the best solution for you will depend on how often you use the
sheet, how many other people use it, how long you would be keeping it for etc.

Good Luck.
M-A

"Naidu" wrote:

Hi,
If i've to create a hierarchial structure within excel sheet...like
A
a1
a2
a3
B
b1
b2
b3

So, as I scroll down the row heading A has to be retained and as we proceed
down, B should also be retained...How can I do this?
--
Naidu


"David Biddulph" wrote:

Put the two rows together at the top of the sheet.
--
David Biddulph

"Naidu" wrote in message
...
How do I freeze two different rows in same sheet.


--
Naidu