Dragging Columns


Posted by Ed Crist on January 04, 2001 12:10 PM

Is there a way to re-arrange columns in Excel by dragging and dropping??

Thanks!!



Posted by Bruce on January 05, 2001 12:06 PM

Yes. Try this

Select the column to move by clicking in the column heading. The entire column will be selected. Move the curser into the upper left hand corner of the first cell, move until the curser until it changes from a plus (+) to an arrow. Now hold down the shift key, and then press and hold the left mouse button. Drag the column to the desired location, release the mouse button, then release the shift key.