Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-26-2011, 01:41 AM
Catalin.B Catalin.B is offline moving columns in excel 2007 Windows Vista moving columns in excel 2007 Office 2007
Expert
 
Join Date: May 2011
Location: Iaşi, Romānia
Posts: 386
Catalin.B is on a distinguished road
Default

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
Reply With Quote
Reply



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 columns in excel 2007 moving data from single to multiple columns? mzimmers Excel 3 08-23-2010 08:20 AM
moving columns in excel 2007 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

Other Forums: Access Forums

All times are GMT -7. The time now is 01:23 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft