ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how to leave column 1 and move all other colums up or down rows. (https://www.excelbanter.com/excel-discussion-misc-queries/154390-how-leave-column-1-move-all-other-colums-up-down-rows.html)

socks

how to leave column 1 and move all other colums up or down rows.
 
Am putting clients name in column 1...column 2, 3 etc are address, phone,
email and other data. Somehow have managed to get names 1 row below where
they should be. help please.

Max

how to leave column 1 and move all other colums up or down rows.
 
Try this on a spare copy ..

Right click on A1 choose "Delete"
Select "Shift cells up" OK
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"socks" wrote:
Am putting clients name in column 1...column 2, 3 etc are address, phone,
email and other data. Somehow have managed to get names 1 row below where
they should be. help please.



All times are GMT +1. The time now is 04:13 PM.

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