Excell Freeze Frames

K

KenS

Version: 2008
Operating System: Mac OS X 10.4 (Tiger)
Processor: Intel

If you place the cursor in the cell below and at the right margin of the row you want to freeze, the preservation of the row works during scrolling. However, with a large spreadsheet the slider becomes unable to move all the way to one side of the spreadsheet. How do I preserve access to the entire width of the sheet?
 
C

CyberTaz

I'm not sure I'm clear on what you mean, but your description sounds like
appropriate behavior. Both the Horizontal & Vertical scroll bar [slider]
buttons in Excel are geared to the furthest used portion of the sheet. IOW,
if column AB is the last used column dragging the scroll bar button won't
take you any farther. Vertical scrolling works the same way, and that is the
behavior regardless of Freeze Panes or Split.

If you want to scroll farther use the scroll bar arrow rather than dragging
the scroll bar button or use some other navigation technique.

HTH |:>)
Bob Jones
[MVP] Office:Mac
 
K

KenS

Let me restate. Sorry for the vagueness.
The spread sheet is large and I need to freeze the column titles. If I zoom out to include all of the width, place cursor in the last column, 2nd row (just below titles) and freeze, the titles will be frozen for vertical scrolling (correct). However, horizontal scrolling is frozen. Slider "lengthens" so it can't move and the arrow key won't move the screen horizontally either. Zooming works but horizontal scrolling is still frozen.
 
J

JE McGimpsey

Let me restate. Sorry for the vagueness.
The spread sheet is large and I need to freeze the column titles. If I zoom
out to include all of the width, place cursor in the last column, 2nd row
(just below titles) and freeze, the titles will be frozen for vertical
scrolling (correct). However, horizontal scrolling is frozen. Slider
"lengthens" so it can't move and the arrow key won't move the screen
horizontally either. Zooming works but horizontal scrolling is still frozen.

Could you give some more detail (e.g., zoom, # of columns, etc)?

From the way I read your description, it sounds like XL is behaving
correctly. If all the columns with data are frozen, then XL can't, and
shouldn't, scroll any of them off the screen horizontally.

If you just want to freeze the titles on the first row, select cell A2
and freeze panes.
 
C

CyberTaz

As I understand it JE is perfectly right. If all columns that will fit in
the viewing are left of the freeze line they cannot - by definition of the
feature - go anywhere to make room for more columns to appear.

In actuality, the arrow button *is* causing the columns right of the freeze
line to scroll but you just don't have any available screen real estate in
which to see it happening. As John suggested, put the selector in column A
or B... Or at least somewhere that allows you to view a minimum of one
column to the right of the vertical freeze line.

HTH |:>)
Bob Jones
[MVP] Office:Mac
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Freeze panes not there 5
notepad to excell 1
Freeze bottom row 5
Freeze row 2
cell display 2
Freeze panes 3
Zoom Slider 1
toolbar view 2

Top