Very Minor "Cosmetic" Question

[Guest]

I just noticed that on a particular active WS, the "elevator" in the vertical
scrolling "shaft" was very small. The amount of data on this warticular WS
had recently been winnowed down from some 7.000 rows to about 800. Grabbing
hold of the "elevator", and clicking into the area just above it are both
quite tricky when it's this small, so I wanted to adjust it to a size
appropriate to the number of active rows.

In the end I copied all the active rows to a new WS, deleted the old WS, and
renamed the new WS to the old one's name.

Is there an easier way to do this?

 

[merjet]

Try saving the workbook.

Hth,
Merjet

 

[Guest]

The WB has been opened and closed (with Save) multiple times since the extra
rows were removed, and this didn't seem to have made any difference.

 

[merjet]

Did you delete the contents of the rows or the rows themselves
(highlighting the row labels to the far left)?

Merjet

 

[Guest]

Deleted the rows.

 

[Susan]

i've run into this myself.
the only cure i've found is to copy the data into an entirely new
workbook.

susan

 

[Guest]

Ah, then it wasn't just me <g>! I found that creating a new WS (which would
receive the default name of sheet[n] and be located immediately to the left
of the offending one), and copying the data to that, then selecting Rename on
the offending WS and capturing its name with Ctrl+C, then deleting the baddie
and renaming sheet[n] to the captured name did the trick Ok.

No doubt the gurus in Redmond will have modified this "Feature" in v2007 <g>!

 

[Dave Peterson]

Debra Dalgleish does share some techniques for resetting that usedrange:
http://contextures.com/xlfaqApp.html#Unused

 

[Guest]

That would be a major "WOW!!!!!" What a great resource! Thanks for passing it
along.