Removing empty rows?

Hi There

If I remove data from a row, can I delete row without affecting the order of the numbers on left of row.

Hello Frenchman96,

Whenever you delete a row, Excel will shift the remaining to close any gaps. If you have 10 rows ( numbered 1- 10), and delete row 7, all rows below 7 are shifted up to close the gap. You will then see data in rows 1 to 9.

Sincerely,
Leith Ross