![]() |
|
|
|
#1
|
|||
|
|||
|
you can select different cells, but you cannot use cut function, you can only use copy-paste selection, but you can select again the cells and delete, move cells up.
Or you can use a macro, to do this. You can start with this: Sub CopyPasteDelete() Range("D8,D9,D13,D17").Select Selection.Copy Range("H8").Select ActiveSheet.Paste Range("D8,D9,D13,D17").Select Selection.Delete End Sub |
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Getting Plain Text into Excel Columns | binar | Excel | 1 | 11-05-2010 01:46 PM |
moving data from single to multiple columns?
|
mzimmers | Excel | 3 | 08-23-2010 08:20 AM |
How to compare 2 columns with other two columns in EXECL 2007?
|
Learner7 | Excel | 5 | 06-12-2010 09:54 AM |
| Excel 2003 formatting issue when moving to new WB | aramsey | Excel | 2 | 04-22-2010 02:34 PM |
| Sorting columns in Excel - please advise | Jonre | Excel | 2 | 08-21-2009 02:38 AM |