Shopping Cart

Quickest way to move a column

Quickest Way To Move A Column

Most times using a keyboard shortcut is quicker than using a mouse. Sometimes though, it’s a nifty combination of the two that does the trick! Let’s look at the quickest way to a move a column in Excel.

The standard way of moving a column within a range of data is to right-click on the column header, select “Cut”, then right click on the Column to the right of where you want to insert it and select “Insert Cut Cells”.

The quickest way to move a column? Use your mouse – to Drag and Drop! The trick though is to hold down the shift key at the same time to force an insert as opposed to an overwrite.

If you found this useful and would look to learn more, check out our beginner Excel training course, which will give you a firm grasp of the fundamentals, and help take your skills to the next level.

MS Excel Advanced Course

R 1,550

Course Length: 79 Lessons | 7.5 Hours of Videos

Content Covered

  • Key Essentials
  • Spreadsheet Integrity
  • Cell References
  • Forecasting
  • CSV Import
  • Merging Data
  • Splitting Data
  • Data Validation
  • Worksheet Protection
  • Advanced Formula
  • Text Formula
  • Date Formula
  • Logical Formula
  • Lookup Formula
  • Maths Formula
  • Pivot Tables & Charts
  • Excel Automation (Macros)

MS Excel Intermediate Course

R 1,350

Course Length: 55 Lessons | 5.5 Hours of Videos

Content Covered

  • Key Essentials
  • Series Generation
  • Advanced Copy and Paste
  • Formula
  • Cell Referencing
  • Rounding
  • View Optimization
  • Find and Replace
  • Sort and Filter
  • Graphs
  • Conditional Formatting
  • Ranges vs Tables
  • Pivot Tables
  • VLOOKUP
  • Data Manipulation
  • Keyboard Shortcuts
  • Tips and Tricks

MS Excel Beginner Course

R 1,150

Course Length: 56 Lessons | 4 Hours of Videos

Content Covered

  • Excel Overview
  • Key Essentials
  • Data Input
  • Excel Autofill
  • Formatting Cells
  • Number Formatting
  • Formatting Worksheets
  • Formulas
  • Printing
  • Basic Sort and Filter
  • Visualizing Data
  • Excel’s Golden Rule
  • Pivot Tables Sneak Peek
  • Keyboard Shortcuts
  • Tips and Tricks

This draw is closed. Keep checking back, for the next draw.