Freezing Panes

mtp9302

New Member
Joined
Aug 1, 2006
Messages
22
Hi all,

I wish to do something a little different with the "freeze panes" option, and I'm not sure if it's possible. I know that normally, say to always show row 5, you must select row 4 and choose "freeze panes" from the "Window" menu.

What I want to do is to have rows 56-60 show all of the time. Is there any way to freeze just these rows, such that rows 1-55 and 61+ scroll and 56-60 remain constantly in view?

Any help would be appreciated. Thanks.

-Matt
 

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying

TimmiT

Board Regular
Joined
Dec 15, 2006
Messages
77
A way I can think of to do this, if all you want to do is see the cell values (not be changing them right there, is to copy the section and pase it in at the top of your sheet. ie, shift things down 5 rows and copy the portion you want to see. After you copy it in, freeze the pane to allways show the cells.

From Excel Help:


On the worksheet, select the cells you want to make into a picture.


Click Copy .


Click the worksheet or other document where you want to paste the picture.


To paste the picture to another worksheet, hold down SHIFT and click Paste Picture Link on the Edit menu. The picture is linked by a formula that refers to the copied cells.
To paste the picture to a document created in another Office program, click Paste Special on the Edit menu. In the As box, click Picture, click Paste link, and then click OK.

You can use the Picture toolbar to change the image.
 

pgc01

MrExcel MVP
Joined
Apr 25, 2006
Messages
19,887
Hi Matt

Is there any way to freeze just these rows, such that rows 1-55 and 61+ scroll and 56-60 remain constantly in view?

Yes, you can, using another window for the same workbook:

- Create a new window for your workbook (Windows>New window)

- Arrange the 2 windows Horizontally (Windows>Arrange>Horizontal)

- On the top window hide rows 1:55 and 61:Last row

- On the bottom windows hide rows 56:60

- Adjust the height of the windows

This way the rows 56-60 show all the time in the top window and you can scroll all the other rows in the bottom window.

Remark: the location of the menus with the window commands that I used is the one in xl2000. In later versions of xl you may have to look for the menu commands under another header.

Hope this helps
PGC
 

Forum statistics

Threads
1,181,648
Messages
5,931,213
Members
436,784
Latest member
amuljono

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top