freeze 2 panes help please

[*k*]

hi all...... i hope this is an easy ? I want to make a worsheet kind
of like a framed web page, like this


-------------------------------------------------||----------------------------|
| title || date |
|____________________________|| |
| || |
| info 1 || |
| || |
|___________________________||________________|

please excuse crude picture but I hope you get the idea..... i want to
have title part fixed and be able to scroll around the info1 and date
parts of the worksheet, any help on how to do this please?

tia
K

 

[Frank Kabel]

Hi
maybe not exactly what you want but have a look at 'Windows - Freeze
Panes'. It will freeze the part to the top and left of your current
cursor position

 

[*k*]

Hi
maybe not exactly what you want but have a look at 'Windows - Freeze
Panes'. It will freeze the part to the top and left of your current
cursor position

I tried that, but I actually need 2 different "freeze panes" on my
worksheet :-(

 

[Frank Kabel]

Hi
not possible in Excel :-(

 

[David McRitchie]

But you can open a new window from the
Excel Window menu. Don't have the Workbook maximized
in the Excel Window and you can align one view under the
other -- keeping in mind that they are two independent views
and could be looking at two different worksheets.

You will notice :1 and :2 in the Title Bars. To eliminate
a view simply close the that view with the [x] not the "X" above it
that would close Excel.

More on Freezing Panes and viewing multiple windows in Excel
http://www.mvps.org/dmcritchie/excel/freeze.htm

 

[Frank Kabel]

Hi David
good idea!

--
Regards
Frank Kabel
Frankfurt, Germany

But you can open a new window from the
Excel Window menu. Don't have the Workbook maximized
in the Excel Window and you can align one view under the
other -- keeping in mind that they are two independent views
and could be looking at two different worksheets.

You will notice :1 and :2 in the Title Bars. To eliminate
a view simply close the that view with the [x] not the "X" above it
that would close Excel.

More on Freezing Panes and viewing multiple windows in Excel
http://www.mvps.org/dmcritchie/excel/freeze.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

Hi
not possible in Excel :-(

 

[tghcogo]

Hi

Sometimes I think my answers are too simplistic and I'm no
understanding the question, however........ how about using spli
instead of freeze panes.

KR

TGHCOG

 

[*k*]

haha....its not the answer that are TOO simplisitic......just hard to
know WHAT the question is some times..... I know what i am trying to
acheive...... but its how to tell others....or worse still for a new
user.....how to tell excell! but yes ........ split is what i need
without really knowing what that was...... so thanks to all those that
helped