The column heading (B) and row heading (2) appear in dark gray, and a highlight appears around the cell to indicate that it is the active cell. Let's explore some of the ways that you can move between cells.Ĭlick cell B2. You can use a mouse, keyboard, or menus to get to any cell.
#Excel 2011 for mac menu grayed out how to#
To enter data, you first need to know how to move between worksheet cells. Identify the user interface elements that you can use in all workbooks. To see a tip for a button on the ribbon or toolbar, rest the pointer over the button. To hide the ribbon while you work, on the right side of the ribbon, click. Microsoft Office for Mac 2011 tutorial: Excel basics 5 The active cell has a blue highlight around it. Each cell has an address (for example, cell A1 is the intersection point of column A, and row 1). Each workbook can have multiple worksheets, or "sheets."Ĭell: The intersection point between a column (A, B, C) and a row (1, 2, 3). If you dont 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.
Microsoft Office for Mac 2011 tutorial: Excel basics 4Ģ. 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. Microsoft Office for Mac 2011 tutorial: Excel basics 3 Tip To always start with a blank document when you open Excel, select the Don't show this when opening Excel check box. Tip If you don't see the Workbook Gallery, quit and then reopen Excel.Ĭlick Excel Workbook, and then click Choose. 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 2ġ. Identify user interface elements that you can use to accomplish basic tasks. 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. Use your favourite spreadsheet app on both platforms without fear.Microsoft Office for Mac 2011 tutorial: Excel basics 1Įxcel basics Excel is a powerful spreadsheet and data analysis application, but to use it most effectively, you first have to understand the basics.
#Excel 2011 for mac menu grayed out windows#
All you wanted to know about Microsoft Excel on Mac is here! Learn what basic modifications this version of Excel has and what is missing in comparison with Windows version.
0 kommentar(er)
