ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Inserting rows (https://www.excelbanter.com/excel-discussion-misc-queries/209122-inserting-rows.html)

Raynelle

Inserting rows
 
I have a spreadsheet that I need to insert rows. However, after i insert
rows, then go to enter data in a cell, everytime i start to type data, a new
row is inserted. how do i stop this?

Sheeloo[_3_]

Inserting rows
 
Can you disable macros on the worksheet and see whether the problem persists?

Also you can Right-Click on the Tab name and choose View Code

If you see any code between
Private Sub Worksheet_Change(ByVal Target As Range)
End Sub
with something which says Insert...
then delete everything
and test

You may make a copy of the workbook first so that you can go back to what
you had...

"Raynelle" wrote:

I have a spreadsheet that I need to insert rows. However, after i insert
rows, then go to enter data in a cell, everytime i start to type data, a new
row is inserted. how do i stop this?



All times are GMT +1. The time now is 09:01 PM.

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