Calling all writers, especially those who wax poetic! If you have a way with words, here's your chance to put pen to paper and try your hand at writing an award-winning piece for us. Find all the details on our contest page.

Excel configure problem

Saint Bonifacius, MN(Zone 4a)

I am fairly a decent user of excel, but I must have inadvertently done something "wrong." I've never seen this before and haven't a clue what to do about it. I am using Excel 2000:

In the screenshot below you can see the spreadsheet screen is divided into quadrants (the problem), and that there are more columns (A-D) not showing. The slide bar at the bottom right can be moved left and right, but has no effect. The slide bar at the right can be moved up and down, and scrolls only the lower left quadrant. The other three are "locked" no matter what I try.

The other pages in the book show normally: no quadrants, scrolling up and down, left to right is unimpeded.

I imagine it is very simple to get back to a regular spreadsheet without quadrants. I just have no idea what to click!

Thanks for any advice,

Thumbnail by Leftwood
Urbana, IL

It looks like your freeze frame is active. You may be able to drag the dividers to the edges. If not, look in the menus for freeze (I have a later version of Excel, so I can't be more specific).

Celaya, Mexico(Zone 10a)

Excel Menu Bar ---> Window ---> Unfreeze Panes

Saint Bonifacius, MN(Zone 4a)

That is exactly it. Thanks.
I was purposely freezing paning row 1 in all the sheets around that time, but had never thought about freezing columns, or rows and columns as a possibilities - just rows. Certainly, I must have "freeze paned" when a wrong cell was highlighted.

All better now,

Celaya, Mexico(Zone 10a)

If you select a single cell then it will put the freeze split above and to the left of the selected cell.
If you select a whole column then the split will be to the left of the selected column and if you select a whole row then the split will be above the selected rows.

Powder Springs, GA(Zone 7b)

Freezing panes is great! To get to the rows above the freeze or columns to the left of a freeze, just click in a cell (above or to the left of the freeze) and then you can scroll to the topmost row or leftmost column (without unfreezing).

Beware of another similar problem - when you use your directional keys (arrows, page up, down, home, end) and the rows (or columns) move but your location doesn't. This happens when the scroll lock is turned on.

Post a Reply to this Thread

Please or sign up to post.