How To Remove Unwanted Rows From Excel For Mac 2011

Row 1: [ x ][ x ][ x ][ x ][ x ] row 2: [ x ][ x ][ o o ][ x ] row 3: [ o o ][ x ][ o o ] Where x's are single cells and o's are merged together What I want to do is unmerge all the rows (which I could do fairly easy with the unmerge button), but for where the merged cell was, have the data duplicated across the 2 cells. Control click on tab of unwanted sheet wait for context menu to come up. Choose delete. A modal window comes up asking if you wish to delete this sheet. Control Click⬆ If you don't see the tabs check this: My arrow pointer is on top of the top of the item you grab. Not the kind of behavior that occurs in Excel for Windows. How to Delete Cell and Range Contents in Excel for Mac. The trick is to remember that fn+Delete is really a keyboard shortcut to the Delete key on a Mac. Then the world rights itself and the planets align. Quickbooks for mac 2012 small business accounts. Frustration abates.
Read more...