moderated Re: Re arranging columns in Excel



Select an entire column in a worksheet         CTRL+Spacebar
Select an entire row in a worksheet               SHIFT+Spacebar

Once you have the column selected you want to move, hit CTRL+X to cut it.

Move to the column where you wish to have the cut column inserted to its left, and select it.

Bring up the context menu and then either arrow down to the Insert Cut Cells item and hit enter, or just hit E, which activates that choice directly.

The column you selected first will now be to the immediate left of the column you had selected when performing the insert.


The same basic principle applies to rows, and I believe the insertion point is above the row selected when the insert is done.


Brian - Windows 10 Pro, 64-Bit, Version 1903, Build 18362  

Many of the insights of the saint stem from his experience as a sinner.

         ~ Eric Hoffer

Join to automatically receive all group messages.