The keystroke shortcut is Command Shift J. To Ungroup, highlight a grouped area then go to the menu bar and click Data>Group and Outline>Ungroup… On the spreadsheet above we grouped columns E through H.Ĭlicking the plus symbol reveals grouped columns or rows.Ĭlicking the minus symbol hides those same columns and rows. In the menu bar and click Data>Group and Outline>Group… The keystroke shortcut is Command Shift K.

Highlight columns or rows that you wish to group.The solution is to stop using Hide, and start using the Group command: Unfortunately, this makes it difficult for others to detect that our spreadsheet contains hidden data. When we need to hide columns or rows most of us right-click and use the Hide command. Once you try this, you’ll find all kinds of uses for it. Choose what you want to Paste from the dialog box.In the menu bar click Edit>Paste Special. The keystroke shortcut is Control Command V.Paste Special lets you choose what part of the data you paste: formulas, formats, values, comments, column widths, or 10 other data types. We’re using Microsoft Excel for Mac 2011, but these tips should work in all other versions.Ĭopy and Paste copies and pastes all the data from one cell to another. Over the next few months we’re going to provide basic tips to help you save time, reduce errors, resolve common problems, and create slick looking spreadsheets.Įven if you absolutely hate Excel… we think you’ll get something out of this 🙂

Macos big sur excel