Working with Excel Sheet Types in Office 2011 for Mac - dummies

Working with Excel Sheet Types in Office 2011 for Mac

By Geetesh Bajaj, James Gordon

If you’re working in Office 2011 for Mac, you’ll find that Excel sheets can be general or dedicated to a specific purpose. You don’t have to be an expert in Excel 2011 for Mac to use the various sheet types, but you should know their names and each sheet type’s purpose.

You can mix different sheet types within a single workbook.

Here’s the rundown of the kinds of specialized sheets in Excel:

  • Blank sheet: This general-purpose standard worksheet has cells, rows, and columns; the cells can hold text, formulas, and data. You can place objects such as charts, WordArt, SmartArt graphics, objects from the Media browser, pictures, sounds, and even movies in layers on worksheets.

  • Chart sheet: A chart sheet contains a single graph or chart.

  • Excel 4.0 Macro sheet: Before VBA, there was the Excel 4.0 XLM macro language. Excel 2011 supports the Excel 4.0 macro language. If this applies to you, search Excel Help for Excel 4 and then download the entire Excel 4.0 Macro Language Reference; click the Download link in the Excel 4.0 (XLM) Macro Commands topic.

  • Excel Dialog sheet: Excel dialog sheets let you customize your own dialogs. You could make your own wizard or devise an input form for your database. Dialog sheets make use of VBA.

Ledger Sheet and List Sheet types are discontinued. When you open a workbook that contains either of these, Excel will automatically convert these to standard Excel worksheets. Each data range will be formatted into an Excel Table using the new Excel Table feature. Don’t be flustered by the dialogs you get when you open one of these older style workbooks.