moderated Re: Re arranging columns in Excel


 

But the instructions I gave do not leave the cut column in place (or a vacated column in the same place as the cut column), otherwise it wouldn't be doing what was asked for.

If you select a column in its entirety, cut it, select another column in its entirety, and then use Insert Cut Cells the column cut is moved wholesale and the letter designations for the columns are reset.  The cut column will be moved immediately to the left of the column selected immediately prior to doing the insert.  This is the only thing that can make sense, as if one wishes to put a column first (in the Column A position) instead of what's there you have to select column a in its entirety, then insert.  Then the inserted column becomes Column A, the former Column A becomes B, etc., etc., etc.
--

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 main@jfw.groups.io to automatically receive all group messages.