moderated Re: Re arranging columns in Excel


Van Lant, Robin
 

The directions below are good, but you do not need to select the column beside which you want to insert.  It is best to be at the top of the column, though, before hitting the context menu and selecting.  The benefit of using this method to insert cut cells is that it automatically deletes the empty column you just vacated.  If you use the method of cutting a column and pasting it into a blank one, the original column will still be there.  That’s fine if it’s at the end of a table, but probably not what you want if you  are moving columns within the middle of a table.

 

 

 

From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Brian Vogel
Sent: Tuesday, October 8, 2019 11:57 AM
To: main@jfw.groups.io
Subject: Re: Re arranging columns in Excel

 

From:  https://support.office.com/en-us/article/Keyboard-shortcuts-in-Excel-1798d9d5-842a-42b8-9c99-9b7213f0040f#bkmk_selectwin

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



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


If you prefer not to receive future e-mail offers for products or services from Key
send an e-mail to mailto:DNERequests@... with 'No Promotional E-mails' in the SUBJECT line.

Join main@jfw.groups.io to automatically receive all group messages.