dslreports logo
site
 
    All Forums Hot Topics Gallery
spc

spacer




how-to block ads


Search Topic:
uniqs
425
share rss forum feed


haroldo

join:2004-01-16
united state
kudos:1

[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?
Thanks!



haroldo

join:2004-01-16
united state
kudos:1

answered here »Re: Deleting cells and moving columns in Excel for Mac