If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
freeze 2 panes help please
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 |
#2
|
|||
|
|||
freeze 2 panes help please
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 -- Regards Frank Kabel Frankfurt, Germany *k* wrote: 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 |
#3
|
|||
|
|||
freeze 2 panes help please
On Thu, 10 Jun 2004 13:30:27 +0200, "Frank Kabel"
wrote: 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 :-( |
#4
|
|||
|
|||
freeze 2 panes help please
Hi
not possible in Excel :-( -- Regards Frank Kabel Frankfurt, Germany *k* wrote: On Thu, 10 Jun 2004 13:30:27 +0200, "Frank Kabel" wrote: 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 :-( |
#5
|
|||
|
|||
freeze 2 panes help please
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 "Frank Kabel" wrote in message ... Hi not possible in Excel :-( -- Regards Frank Kabel Frankfurt, Germany *k* wrote: On Thu, 10 Jun 2004 13:30:27 +0200, "Frank Kabel" wrote: 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 :-( |
#6
|
|||
|
|||
freeze 2 panes help please
Hi David
good idea! -- Regards Frank Kabel Frankfurt, Germany David McRitchie wrote: 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 "Frank Kabel" wrote in message ... Hi not possible in Excel :-( -- Regards Frank Kabel Frankfurt, Germany *k* wrote: On Thu, 10 Jun 2004 13:30:27 +0200, "Frank Kabel" wrote: 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 :-( |
#7
|
|||
|
|||
freeze 2 panes help please
Hi
Sometimes I think my answers are too simplistic and I'm not understanding the question, however........ how about using split instead of freeze panes. KR TGHCOGO --- Message posted from http://www.ExcelForum.com/ |
#8
|
|||
|
|||
freeze 2 panes help please
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 :-) On Fri, 11 Jun 2004 12:02:43 -0500, tghcogo wrote: Hi Sometimes I think my answers are too simplistic and I'm not understanding the question, however........ how about using split instead of freeze panes. KR TGHCOGO --- Message posted from http://www.ExcelForum.com/ |
Thread Tools | |
Display Modes | |
|
|