Home › pages

How to Move Columns in Microsoft Excel on Mac

Created: 2023-07-09 08:56:34 UTC

Option 1: Using the Mouse/Macbook Trackpad

Steps:

  • Step 1: Open the Excel Spreadsheet on using Excel for Mac.
  • Step 2: Now select the complete column or columns that you want to move by clicking on the column letter at the top of the spreadsheet e.g. B, C, D...
  • Step 3: Now just move the cursor to the edge of any of the selected cells, and you will see the cursor change from an arrow to a "Grabbed Glove" one, now if you press your mouse (if using iMac, or Mac Studio with a mouse) or press and hold your Macbook trackpad, you can simply move the column to the left or the right.
  • Step 4: Leave holding the cursor once you get the columns where you want them.

To better understand how this works, follow the below gif (refresh the page if you do not see the gif in action)

Move Columns in Excel for Mac Demo

Note: If you try to move the column(s) over to existing data column(s) you will get an alert that the data will be replaced.

Alert - There already data here. Do you want to replace it - Excel

Let's take another way to achieve the same.


Option 2: Using Cut & Paste

Steps:
Copyright © Code2care 2024 | Privacy Policy | About Us | Contact Us | Sitemap