Excel - Quick Way to Move a Column in Excel - Episode 543
887 views · Published 29 July 2009 · 1:36 · Indexed 10 November 2026
Channel: MrExcel.com · 2009 · Education
Microsoft Excel Tutorial: Quick Way to Move a Column in Excel Welcome back to another MrExcel netcast! In this video, we'll be discussing a handy trick for rearranging columns in Excel. This is a question that came up during one of my recent power Excel seminars in Chicago. A participant asked if there was a faster way to move a column to a different location on a worksheet, rather than using the traditional method of inserting and cutting and pasting. And the answer is yes, there is a much quicker way to do this! First, select the column that you want to move. In this example, we'll be moving the amount in column H and placing it between the invoice number and customer number in columns B and C. Next, use the shortcut CTRL X to cut the column. Then, click on the column where you want to insert the cut column, in this case, column C. Finally, go to the insert menu and choose "cut cells". And just like that, the entire column will be moved to the desired location, saving you time and effort. This feature is a great time-saver and can be used for rearranging columns in any order on a worksheet. No more tedious steps of inserting and cutting and pasting. With just a few clicks, you can easily solve the problem. Thanks for tuning in to this MrExcel netcast. Don't forget to subscribe to our channel for more helpful Excel tips and tricks. See you next time!" Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/ You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/ Mary from Chicago asked how to rearrange columns in a dataset. In Episode 543, learn how to cut and Insert Cut Cells to rearrange the columns. This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book! Table of Contents: (00:00) Introduction (00:11) Question from Power Excel Seminar (00:21) Rearranging columns on a worksheet (00:35) Faster way to rearrange columns (00:47) Using "insert cut cells" feature (01:07) Solving the problem in a few clicks (01:17) Clicking Like really helps the algorithm #excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial This video answers these common search terms: Efficient column rearrangement in Excel Excel column manipulation Excel column rearrangement Excel insert cut cells feature Excel tips for column management Faster way to rearrange columns in Excel How to move columns in Excel Insert cut cells between columns Insert cut cells in Excel Move columns in Excel Quick way to rearrange columns in Excel Shortcut for Cut in Excel Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1152539/
More from this channel
-
2:13
Excel Calculate Decimal Hours from two Time Cells - Episode 902
-
3:57
Excel 2007 - Color of Selected Sheets is too much like unselected sheets - Episode 907
-
2:48
Excel - Adding Equals Icon to Excel QAT - Build Formula with Mouse - Episode 911
-
3:30
Excel Grouping Percentages into Buckets for a Pivot Table - Method 2 - Episode 913
-
2:04
Excel Change Color of Selected Cells - Episode 914
-
4:38
Excel - Auto Numbering a List with Frequent Inserts & Deletes - Episode 916
-
2:37
Excel - Enhance Your Excel Charts: Add a Picture as a Background in Excel - Episode 917
-
2:00
Excel Hiding Data in Plain Site - Episode 919