Excel inserts too many rows

When I highlight a group of rows and click "Insert" it
inserts 100's of rows instead of the 5 I highlighted. I
am using Office 2000 SP-3

dewey

Is it possible that the 5 rows you highlighted have a great whack of hidden
rows within the range? Like maybe you are selecting rows 2 through 200 with
only 5 rows visible?

Gord Dibben Excel MVP

On Wed, 12 May 2004 16:10:37 -0700, "dewey47"
<anonymous@discussions.microsoft.com> wrote:

>When I highlight a group of rows and click "Insert" it
>inserts 100's of rows instead of the 5 I highlighted. I
>am using Office 2000 SP-3

I had thought of that, but the problem is that is does
not do it consistently. Within the same document on the
same 5 rows it does it often enough to be a pain, but not
often enough to recreate whenever I want it to. Which
then rules out hidden rows causing the problem. Any
other ideas?
>-----Original Message-----
>dewey
>
>Is it possible that the 5 rows you highlighted have a
great whack of hidden
>rows within the range? Like maybe you are selecting
rows 2 through 200 with
>only 5 rows visible?
>
>Gord Dibben Excel MVP
>
>On Wed, 12 May 2004 16:10:37 -0700, "dewey47"
><anonymous@discussions.microsoft.com> wrote:
>
>>When I highlight a group of rows and click "Insert" it
>>inserts 100's of rows instead of the 5 I highlighted.
I
>>am using Office 2000 SP-3
>
>.
>