ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   why does Excel add more rows than I have selected (https://www.excelbanter.com/excel-worksheet-functions/98342-why-does-excel-add-more-rows-than-i-have-selected.html)

tch

why does Excel add more rows than I have selected
 
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?

Richard Buttrey

why does Excel add more rows than I have selected
 
On Mon, 10 Jul 2006 04:48:02 -0700, tch
wrote:

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
__________________________

Dave Peterson

why does Excel add more rows than I have selected
 
Do you have any hidden rows in that selection (either hidden manually or via
filter)?

tch wrote:

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?


--

Dave Peterson


All times are GMT +1. The time now is 10:08 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com