Guess what time it is? It's time for the DG County Fair! Now in it's sixth year, enter your blue-ribbon photos or mouth-watering recipes for a chance to win a gift subscription! Click here here to get all the details, dates and entry rules.
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!
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.
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.
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.