Excel 2011 for Mac: Track Changes in a Worksheet
Office 2011 for Mac: Making a Scroll Bar for Excel Forms
Make a Form on a Dialog Sheet in Excel 2011 for Mac

Working with Excel Sheet Types in Office 2011 for Mac

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.

blog comments powered by Disqus
Making List Boxes for Excel Forms in Office 2011 for Mac
Making Pop-up Menu Buttons for Excel Forms in Office 2011 for Mac
Choosing Excel File Formats in Office 2011 for Mac
Office 2011 for Mac: Save Excel Workbooks in Old File Formats
Office 2011 for Mac: Making Spin Buttons for Excel Forms

Inside Dummies.com