why does Excel add more rows than I have selected

T

tch

I am inserting rows on a spreadsheet. I am highlighting from the left hand
side of the sheet on the pre numbered column.
I high light 4 rows to insert and the spreadsheet inserts 30 +
What is wrong?
 
R

Richard Buttrey

I am inserting rows on a spreadsheet. I am highlighting from the left hand
side of the sheet on the pre numbered column.
I high light 4 rows to insert and the spreadsheet inserts 30 +
What is wrong?

It sounds like the range of rows you are highlighting contains 26
hidden rows.

HTH. If not post back

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________
 
D

Dave Peterson

Do you have any hidden rows in that selection (either hidden manually or via
filter)?
 
Top