Moving columns

[Dick7Access]

I do not use Excel much but occasionally I have to paste a MS Word doc into excel. Is there a way to drag and drop columns like we do in Access?

 

[boerbende]

select column by clicking on column letter
Right mouse, cut,
goto new place,
right mouse, insert cut cells

 

[stopher]

You can drag the column by highlighting the column (click on the column title). Then move the mouse to either the left or right edge of the column, left click and drag. Note the column being dragged will replace the destination column.

 

[Dick7Access]

You can drag the column by highlighting the column (click on the column title). Then move the mouse to either the left or right edge of the column, left click and drag. Note the column being dragged will replace the destination column.

Thanks. So easy when you know how. Up until now I have had to cut and paste. A pain in the ***

 

[Rx_]

In my past life, I was a Microsoft Certified Trainer that included Excel Object Model Programming.Users ranged from Excel power users, VB programmers, to C++, ...
A lot of these users were stuck in the ways they learned.
For some of the courses, they asked me for a prerequisite. After evaluation my recommendation was Microsoft Excel YEAR Step by Step (Microsoft Press).
Since then, I had many managers assign it to key middle managers.
the older years may be only a few dollars and should have the same basic material.

Since you have expressed an interest in learning programming, let me strongly suggest getting this or a book like it. It has a small project with a specific objective, like moving columns / rows/ worksheets - that last 5 minutes. Add up several dozen 5 minute lessons, and you will be able to be a resident expert.

Then, get the Microsoft Excel Programming step-by-step. You will quickly learn more about programming and be able to kick out useful things.

The best part is, MS Access can attach to a MS Excel data as if it was a table for both read/write.

Bottom line, it will give you instant gratification and useful tools.