Tips and Tricks for Excel 2011 for Mac

By Geetesh Bajaj, James Gordon

Part of Office 2011 for Mac All-in-One For Dummies Cheat Sheet

When you work frequently with Excel 2011 for Mac, you’ll want to gather some tricks for staying in charge of spreadsheets. Use these quick tips for your most common activities using Excel 2011:

  • Rename a worksheet: Double-click a sheet tab to change its name.

  • Edit cells: Double-click a cell to edit the cell formula or cell contents on the worksheet.

  • File timesaver: Save your files as Excel Binary Workbook (.xlsb) to get a much smaller file that opens and saves faster.

  • Create table rows and columns: Choose Insert→List to start the List Wizard, which helps you create row and column tables for your data.

  • Alternative menu options: Hold down the Shift key while navigating Excel’s menus to see alternative options.