moderated Re: Re arranging columns in Excel
Van Lant, Robin
Brian, we are both correct, I was just expanding on your comment. I’m simply saying that you don’t have to select the second column before doing the “paste cut cells”, as long as your cursor is at the top of that column. Your method of selecting the second column is a nice trick I didn’t know for being able to insert the cut column without moving to the top of the desired column first. I can see how that would be really valuable when I’m working in some of my massive spreadsheets and I look forward to using that.
And, indeed, our method of using insert cut cells is better because it doesn’t’ leave the empty column after pasting. I made that comment because someone else responded that they first insert a blank column then copy and paste the data they want to move, which you and I both know would leave an empty column.
From: firstname.lastname@example.org <email@example.com> On Behalf Of Brian Vogel
Sent: Tuesday, October 8, 2019 12:36 PM
Subject: 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.
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
This communication may contain privileged and/or confidential information. It is intended solely for the use of the addressee. If you are not the intended recipient, you are strictly prohibited from disclosing, copying, distributing or using any of this information. If you received this communication in error, please contact the sender immediately and destroy the material in its entirety, whether electronic or hard copy. This communication may contain nonpublic personal information about consumers subject to the restrictions of the Gramm-Leach-Bliley Act. You may not directly or indirectly reuse or redisclose such information for any purpose other than to provide the services for which you are receiving the information.
127 Public Square, Cleveland, OH 44114