[Excel] Deleting cells and moving columns in Excel for Mac When I use Excel (Windows) 2010 at work, I can highlight a series of cells and press delete and all the data from the highlighted cells is removed. When I try the same on my Mac (not sure of version, I'm at work, but it's an equivalent version) the only data that gets deleted is the last cell in the range that I highlighted.
How do I delete all cells in a highlighted range using Excel for Mac?
In addition, using Excel (Windows) when I cut (or copy) a column (or row) and then click the Insert button, the copied (or cut) column (or row) is moved into the area that I clicked to insert (for example, if I copy column C and insert it between A & B, data from A B C becomes A C B...does that make sense?).
In any event, on the Mac, if I do the same and click Insert, a blank column appears between A and B. How do I get the Mac to perform like the Windows version and move the column to the new location?