A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

freeze 2 panes help please



 
 
Thread Tools Display Modes
  #1  
Old June 10th, 2004, 11:42 AM
*k*
external usenet poster
 
Posts: n/a
Default 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  
Old June 10th, 2004, 12:30 PM
Frank Kabel
external usenet poster
 
Posts: n/a
Default 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  
Old June 10th, 2004, 12:34 PM
*k*
external usenet poster
 
Posts: n/a
Default 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  
Old June 10th, 2004, 12:40 PM
Frank Kabel
external usenet poster
 
Posts: n/a
Default 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  
Old June 10th, 2004, 02:21 PM
David McRitchie
external usenet poster
 
Posts: n/a
Default 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  
Old June 10th, 2004, 02:33 PM
Frank Kabel
external usenet poster
 
Posts: n/a
Default 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  
Old June 11th, 2004, 06:02 PM
tghcogo
external usenet poster
 
Posts: n/a
Default 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  
Old June 11th, 2004, 07:38 PM
*k*
external usenet poster
 
Posts: n/a
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:19 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.