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)
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.
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).
- How to show line numbers in Nano on Mac
- How to install Jupyter Notebook on macOS Sonoma
- How to Disable Remote Management using Mac Terminal
- Test internet speed using macOS Terminal command
- Docker Desktop needs privileged access macOS
- Google Search Hot Trends Screensaver for Mac OS X
- How to do calculations in Mac Terminal
- How to make TextEdit the default text Editor on Mac
- How to Show Full Website Address on Safari for Mac (Ventura/Sonoma)
- The Zsh Shell - Mac Tutorial
- Opening mac Terminal
- How to change the name of your Mac running on macOS Ventura 13
- How to find the Battery Cycle Count on macOS Ventura
- How to set an emoji as Zsh terminal prompt in macOS
- How to access Trash Folder using Mac Terminal Command
- macOS Ventura XCode Command Line Tools Installation
- Hide Bluetooth icon on Mac Menu Bar macOS Ventura 13
- How to run .sh file in Mac Terminal
- Terminal Command to get the list of available shells in macOS
- How to see Storage Information on macOS Ventura
- How to Go To /usr/local/bin on Mac Terminal?
- How to do screen recording on Mac
- How to Find File and Directory Size in Mac Terminal
- Open .bash_profile File in TextEdit using Terminal
- Remove Now Playing icon from macOS Big Sur Menu Bar
- How to Change Notepad++ Toolbar Icons and size - NotepadPlusPlus
- Mac - Steam Needs to Be Online to Update. Please confirm your network connection and try again error - News
- How to resolve Failed to create interpreter PyCharm Error - Python
- Windows 365: Restore Deleted Distribution Group using Admin Center (Active Directory) - Windows
- Fix - ssh-copy-id no identities found error - Linux
- Microsoft Teams Error - You cannot add another work account to Teams at the moment - Teams
- Fix: Failed in attempting to update the source: winget - Windows
- How to Replace delimiter with new line in Notepad++ - NotepadPlusPlus
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: