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 Move Columns in Excel for Mac Demo](https://code2care.org/pages/how-to-move-columns-in-excel-on-mac/images/Move Columns in Excel for Mac Demo.gif)
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 Alert - There already data here. Do you want to replace it - Excel](https://code2care.org/pages/how-to-move-columns-in-excel-on-mac/images/Alert - There already data here. Do you want to replace it - Excel.jpg)
Let's take another way to achieve the same.
Option 2: Using Cut & Paste
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 control-click (right-click) and select option Cut.
- Step 4: Again control-click at the column(s) and select Paste to move the column(s).
- Fix: grunt: command not found (Mac/Windows)
- AppleScript Example with TextEdit
- How to copy Password of Wifi on your Mac
- Install OpenJDK Java (8/11/17) versions using brew on Mac (Intel/M1/M2)
- How to check if a port is in use using terminal [Linux or macOS]
- Cut, Copy and Paste Keyboard Shortcuts on Mac Keyboard
- [macOS] NetBeans IDE cannot be installed. Java (JRE) found on your computer but JDK XX or newer is required.
- How to Remove Widgets from macOS Sonoma 14 Desktop
- Turn off Auto-Capitalization on macOS Ventura 13
- How to Go To /usr/local/bin on Mac Terminal?
- How to Open TextEdit on Mac
- Mac: How to Open Android Studio from Terminal
- How to change the default location of Mac Screenshot
- Display Seconds in Digital Clock on Mac Menu Bar [macOS]
- How to install homebrew (brew) on M1 Mac
- Must Know Homebrew Commands for Mac/Linux Users
- Steps to Uninstall Roblox on Mac (macOS)
- How to change the System Settings Sidebar icon size Mac Ventura 13
- How to set Out Of Office (OOO) on Outlook for Mac [Updated 2023]
- Trigger Notification Center Message using Mac Terminal Command
- [fix] macOS Ventura - Python3 xcrun: error: invalid active developer path missing xcrun at CommandLineTools
- How to Install Rust Language on Mac (macOS)
- How to minimize all Windows in Mac
- Display ls command file sizes in KB (kilobytes) MB (megabytes) or GB (gigabytes) [Linux/macOS]
- How to make TextEdit the default text Editor on Mac
- Connect Azure AD (Active Directory) for PowerShell - Powershell
- Get Client IP address from HTTP Response in Java - Java
- How to check about details of Notepad++ text editor - NotepadPlusPlus
- Country ISO Codes List - Java
- How to install Node using Brew on Mac - MacOS
- Java Split String by Spaces - Java
- How to change the Python Default version - Python
- Change the background of Tkinter label or text - Python
Facing issues? Have Questions? Post them here! I am happy to answer!
Author Info:
Rakesh (He/Him) has over 14+ years of experience in Web and Application development. He is the author of insightful How-To articles for Code2care.
Follow him on: X
You can also reach out to him via e-mail: rakesh@code2care.org
More Posts related to MacOS,
More Posts: