The data is now centered without merging any cells.Ĭurrently there is no keystroke shortcut for this Command.

Under the Horizontal drop-down choose Center Across Selection.

In the box that opens choose the Alignment tab.

In the menu bar and select Format>Cells….

When you want to center data across rows: You can avoid this by using Center Across Selection. Excel cannot perform certain functions on merged cells. This looks perfect, but can cause problems later on. When you want to center a spreadsheet title across rows, the quick option is to highlight those rows and use the Merge Cells command. 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 🙂

Excel 2013 mac