ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   spreadsheets (https://www.excelbanter.com/excel-worksheet-functions/151998-spreadsheets.html)

ray shoey

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

Pete_UK

spreadsheets
 
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




Don Guillett

spreadsheets
 
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




All times are GMT +1. The time now is 10:29 PM.

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