Excel mac move column
![excel mac move column excel mac move column](https://cdn.ablebits.com/_img-blog/graph-excel/axis-labels-format-numbers.png)
Your final dataset should look like this: You can remove them by right-clicking on the blank column(s) and selecting the ‘ Delete column’ option from the context menu that appears.
![excel mac move column excel mac move column](https://i.ytimg.com/vi/RAlYTuJrSXQ/maxresdefault.jpg)
To move column B and have it take the place between columns D and E using this technique, follow the steps below: The method is ideal if you want to simply swap columns or a set of columns. You can use this method to move your column either left or right by one column at a time. Using the ‘Move left’ / ‘Move right’ Tool to Move Columns In Google Sheets Note: If you are moving the column towards the left, then all the columns after and including your destination column will shift right to make space for the newly moved column. You should see the Product column (originally column B) now moved to the column between Delivery date and Price. This will cause all the columns before and including column D to shift left, to make space for the column that has been moved.In our example, we drag column B and stop right between columns D and E.
![excel mac move column excel mac move column](https://www.techonthenet.com/excel/columns/images/width2011_003.gif)
Use the translucent guiding bar to see exactly where your selected column is going to go. Then, press down on your selected column with the left mouse pointer and drag it till you reach the column you want your selected column to move to.Wait till the pointer/cursor turns into a hand icon.You can do this by selecting the column header, as shown below: To move column B and have it take the place between columns D and E, follow the steps below: This is the quickest and easiest method as it only involves a swift movement with the pointer. Using Drag-and-drop to Move Columns in Google Sheets Using Cut, Insert, Paste and Delete to Move Columns In Google Sheets.Using the ‘Move left’ / ‘Move right’ Tool to Move Columns In Google Sheets.Using Drag-and-drop to Move Columns in Google Sheets.