MrExcel Publishing
Your One Stop for Excel Tips & Solutions

insert a row in excel


Posted by George Grund on October 19, 2000 2:43 AM

Does anyone know how to insert a row in excel but that it won't affect the number of the rows bellow, i.e. I want to add a row between rows 12 and 13 but I want that row number to be the next row number, ie row 50.

Thanks


Posted by DoughBoy on October 19, 2000 4:19 AM

insert a column and number the rows like that instead of depending on row numbers. You can't change row numbers themselves

Posted by Cathie on October 19, 2000 12:43 PM


When you insert a row it will renumber your rows below the new row automatically. You will need to click on the row number not the cell. The new row will appear above the row number you selected.

If you physically typed the number labels in Column A instead of using the Column numbers in the gray you could use the number series from the last point that your at. (Example, since you want a row in between 12,13 you would insert the row and do your number series starting with 11, 12. Other than that I'm not sure.