Switch columns in excel mac

Click and drag the selected column s to the location where you want to move it, and then release the mouse button.

Table of contents

Method 2. The column data will remain in its place until you paste it into its new location. You can also cut the column by clicking the scissors icon on the Home tab. If you cut the wrong column, press Esc to return the data to its original location. Right-click the letter above the column to the right of where you want to move the data.

3 Ways to Transpose Excel Data (Rotate data from Vertical to Horizontal or Vice Versa)

A drop-down menu will expand. Click Insert Cut Cells on the right-click menu. Excel will insert the cut column to the left of the one on which you right-clicked. Alternatively, you can click the drop-down icon next to the Insert button on the Home toolbar at the top, and select Insert Cut Cells or Insert Cells here.

Your Answer

This will also insert and move your data the same way. Include your email address to get a message when this question is answered. Already answered Not a question Bad question Other. Edit Related wikiHows.

Excel keyboard shortcuts for Windows and Mac | Office Hack

Article Summary X 1. Did this summary help you? Yes No. Article Info This article was co-authored by our trained team of editors and researchers who validated it for accuracy and comprehensiveness. Is this article up to date?

How to swap columns by dragging and other ways to move columns in Excel

Can you please put wikiHow on the whitelist for your ad blocker? Additionally, although we focused on columns, these instructions will also work when you need to move rows within your Excel spreadsheet. There are a few other ways to move columns in Excel, but they typically require the use of a plug-in or creating a Macro.

  1. how to use spaces in mac!
  2. format external hard drive mac mountain lion.
  3. force quit safari browser mac.
  4. How To Swap Values Between Cells, Rows, Or Columns In MS Excel!

This is doable, but requires more advanced knowledge, so you should proceed with columns. Plug-ins can create more headaches by adding unnecessary toolbars and duplicate functions to an already robust program.

How to transpose columns and rows

Macros may be potentially useful in some circumstances. But these tend to be highly specific and are usually best used by those with an in-depth knowledge of Excel.

There are very few issues you can run into when moving columns, with the main one being choosing Copy instead of Cut as your initial move method. This is a common message when pasting information, so it comes in handy should you use the drag and drop method without holding the shift key. With the drag and drop option, it is essential to be careful when selecting either edge of the column you want to move. If you see a clear, block plus sign instead of the four-arrow cursor, the highlight cursor is active.

Subscribe to RSS

A black, block plus sign means the single cell drag and drop tool is active. When these tools are active, they can create some issues that could require correction of your data. The ability to move columns is undoubtedly one of them. Excel makes it a cinch to get your info where it needs to be. Your email address will not be published. Notify me of followup comments via e-mail. Save my name, email, and website in this browser for the next time I comment. This site uses Akismet to reduce spam. Learn how your comment data is processed.