Inserting rows

R

Raynelle

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?
 
S

Sheeloo

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top