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).
- Clear Screen shortcut macOS Terminal
- What is macOS Ventura?
- [fix] How to Show file extensions on all files on Mac
- How to Find Where Mac Terminal App is Located?
- AutoSave button not working on Office on Mac (Word, Excel or Powerpoint)
- macOS say command text to speech using various voices and languages
- How to change Ping TTL value on macOS
- Open .bash_profile File in TextEdit using Terminal
- How to know the Safari Version on Mac
- How to Copy full Absolute Path of a File on Mac
- 13.0 MacOS Ventura release date
- Enable spell check in Sublime Text (macOS)
- How to Display Analog Clock on Mac Menu Bar
- How to turn off Location Services macOS Ventura 13
- How to Open VS Code on Mac
- Add Bookmark macOS Safari
- How to Fix cd: too many arguments Error in Terminal: A Step-by-Step Guide
- How to install wget on macOS
- Select Line Number TextEdit on Mac
- Strikethrough Text in Excel for Mac
- How to Enable or Disable Dark Mode on macOS Ventura 13
- How to hide or display Wifi icon in macOS Bug Sur Menu Bar
- How to install Yarn on Mac (macOS)
- How to fix command not found brew (bash, zsh) on macOS Terminal
- How to Schedule Mails in macOS Ventura
- Fix: Sorry, we cant sync this folder, Youre already syncing a shortcut to a folder from this shared library [OneDrive] - Windows
- Know installed PowerShell Version on Mac - Powershell
- How to track and download Microsoft Teams meeting attendance report of participants/students - Teams
- reCAPTCHA Implementation Tutorial - CSS
- How to create Toast messages in Android? - Android
- How to get current URL Location using Javascript HTML - JavaScript
- Python: Replace the First Occurrence of String in a String - Python
- How to Show Path of Files or App in Mac Spotlight Search - MacOS
-
Facing issues? Have Questions? Post them here! I am happy to answer!
More Posts related to MacOS,
More Posts:
