on spread sheet after deleting row or row can I automatically move other rows
up without using cut and paste

If you use Edit | Delete to remove the row then the data from the rows
below will automatically be moved up. However, if you use the <delete
key to remove data, then all you are doing is clearing the contents of
the cell(s) and not deleting the rows.

Hope this helps.

Pete

On Jul 27, 1:22 pm, ray shoey <ray
wrote:
on spread sheet after deleting row or row can I automatically move other rows
up without using cut and paste

Click on the row NUMBER at the leftright clickdelete

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"ray shoey" <ray wrote in message
...
on spread sheet after deleting row or row can I automatically move other
rows
up without using cut and paste