freeze 2 panes help please

  • Thread starter Thread starter *k*
  • Start date Start date
K

*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
 
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
 
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
Click to expand...

I tried that, but I actually need 2 different "freeze panes" on my
worksheet :-(
 
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
 
Hi David
good idea!

--
Regards
Frank Kabel
Frankfurt, Germany


David said:
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 said:
Hi
not possible in Excel :-(
Click to expand...
Click to expand...
 
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
 
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 :-)
 
Back
Top