Freezing Cells

I

Illusvfyre

Here's the problem, I like the idea about being able to freeze the the panes of a worksheet. However I would like to freeze certain cells, for example I want to just freeze I1 through I10. The freeze panes option grabs A1 through I10 which is not what I want. Any ideas on how I could get around this?

Scott
 
C

Chip Pearson

Scott,

You can't freeze only part of a row or column. Freeze works only
on entire rows and/or columns.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


Illusvfyre said:
Here's the problem, I like the idea about being able to freeze
Click to expand...
the the panes of a worksheet. However I would like to freeze
certain cells, for example I want to just freeze I1 through I10.
The freeze panes option grabs A1 through I10 which is not what I
want. Any ideas on how I could get around this?
 
S

Stephen Bullen

Hi Illusvfyre,
Here's the problem, I like the idea about being able to freeze the the panes of a worksheet. However I would like to freeze
Click to expand...
certain cells, for example I want to just freeze I1 through I10. The freeze panes option grabs A1 through I10 which is not what I
want. Any ideas on how I could get around this?

Scroll the screen first, so only row I is showing, then freeze the pane.

Regards

Stephen Bullen
Microsoft MVP - Excel
www.BMSLtd.co.uk
 
I

Illusvfyre

Thanks Stephan

When I do that though, I can't see the data in columns A through H. I still want to be able to see the other data I just want I1 through I10 to not move when I scroll down

Scott
 
D

David McRitchie

For that you might want to open a new window
so you have two views at the same time.
Window, New Window

You can switch views on the Window menu when you have
maximized your view..

To eliminate either view, use the [x] in upper right of the
spreadsheet (not the topmost [X] which would close Excel).

---
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

Illusvfyre said:
Thanks Stephan,

When I do that though, I can't see the data in columns A through H. I still want to be able to see the other data I just want I1
Click to expand...
through I10 to not move when I scroll down.
 
Top