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?
--
Dave
Temping with Staffmark
in Rock Hill, SC

Try saving the workbook.

Hth,
Merjet

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.
--
Dave
Temping with Staffmark
in Rock Hill, SC


"merjet" wrote:

Try saving the workbook.

Hth,
Merjet

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

Merjet

Deleted the rows.
--
Dave
Temping with Staffmark
in Rock Hill, SC


"merjet" wrote:

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

Merjet

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


On Jul 23, 10:14 am, Dave Birley
wrote:
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.
--
Dave
Temping with Staffmark
in Rock Hill, SC



"merjet" wrote:
Try saving the workbook.

Hth,
Merjet- Hide quoted text -

- Show quoted text -

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
Temping with Staffmark
in Rock Hill, SC


"Susan" wrote:

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


On Jul 23, 10:14 am, Dave Birley
wrote:
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.
--
Dave
Temping with Staffmark
in Rock Hill, SC



"merjet" wrote:
Try saving the workbook.

Hth,
Merjet- Hide quoted text -

- Show quoted text -

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

Dave Birley wrote:

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?
--
Dave
Temping with Staffmark
in Rock Hill, SC

--

Dave Peterson

That would be a major "WOW!!!!!" What a great resource! Thanks for passing it
along.
--
Dave
Temping with Staffmark
in Rock Hill, SC


"Dave Peterson" wrote:

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

Dave Birley wrote:

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?
--
Dave
Temping with Staffmark
in Rock Hill, SC

--

Dave Peterson