mac microsoft excel 2011 keyboard shortcuts

If you don’t see this box, click View > Formula Bar. Name box and formula bar: The address of the active cell appears here. The Home tab has the most commonly used commands for formatting workbook data. Ribbon: The tabbed command bar at the top of a window or work area that organizes features into logical groups. Standard toolbar: The toolbar that displays the name of the workbook (in this case, Workbook1) and buttons for some of the most common tasks, such as opening, saving, and printing a workbook. Menu bar: The area at the top of the screen where all menus are displayed.The File, Edit, and View menus have the most commonly used menu commands. Let's take a look at some of the Excel user interface elements. However, before you begin entering data, you should familiarize yourself with some of the user interface elements that you can use in all workbooks.

Explore the Excel interface In a new blank workbook, you can simply click in a cell and begin entering data. Use the Excel Workbook Gallery to create a new blank workbook.Ģ. To show the Excel Workbook Gallery at any time while using Excel, click File > New from Template.īefore you move on Make sure that you can do the following: To create a new blank workbook at any time in Excel, on the File menu, click New Workbook (also written as File > New Workbook in this tutorial). Notice that a blank workbook (Workbook1) appears. Tip To always start with a blank document when you open Excel, select the Don't show this when opening Excel check box. Click Excel Workbook, and then click Choose. Tip If you don't see the Workbook Gallery, quit and then reopen Excel. In the Excel Workbook Gallery, under Templates, click All. If you have not already opened Excel, on the Dock, click Excel. Let's use the Excel Workbook Gallery to open a blank workbook. It provides a variety of template choices and quick access to recent workbooks. When you open Excel, the Excel Workbook Gallery opens. You can start with a blank workbook, an existing saved workbook, or a template. Create a new blank workbook In Excel, you create and save data in a workbook. Microsoft Office for Mac 2011 tutorial: Excel basicsġ. Identify user interface elements that you can use to accomplish basic tasks.

21īefore you begin What you'll learn After completing this tutorial, you'll be able to: This tutorial introduces some of the tasks and features that you can use in all workbooks.īefore you begin. Excel basics Excel is a powerful spreadsheet and data analysis application, but to use it most effectively, you first have to understand the basics.

Mac microsoft excel 2011 keyboard shortcuts