Getting Started with Excel

This Excel 2010 tutorial includes everything you need to know to get started with Microsoft Excel.

Working with your Excel environment

Video: Exploring Your Excel 2010 Environment

Launch video!Watch the video (3:16).

The Ribbon and Quick Access toolbar are where you'll find the commands you need to perform common tasks in Excel. If you are familiar with Excel 2007, you will find that the main difference in the Excel 2010 Ribbon is that commands such as Open and Print are now housed in Backstage view.

The Ribbon

The Ribbon contains multiple tabs, each with several groups of commands. You can add your own tabs that contain your favorite commands.

Overview of the Ribbon The Ribbon

Certain programs—such as Adobe Acrobat Reader—may install additional tabs to the Ribbon. These tabs are called add-ins.

To customize the Ribbon:

You can customize the Ribbon by creating your own tabs that house your desired commands. Commands are always housed within a group, and you can create as many groups as you need to keep your tabs organized. You can also add commands to any of the default tabs as long as you create a custom group within the tab.

  1. Right-click the Ribbon, then select Customize the Ribbon. A dialog box will appear.
    Right-clicking the Ribbon to customize it Right-clicking the Ribbon to customize it
  2. Click New Tab. A new tab will be created with a new group inside it.
  3. Make sure the new group is selected.
  4. Select a command from the list on the left, then click Add. You can also drag commands directly into a group.
  5. When you are done adding commands, click OK.

    Customizing the Ribbon The dialog box where you can customize the Ribbon

If you do not see the command you want, click the Choose commands drop-down box and select All Commands.

Displaying All Commands Displaying All Commands

To minimize and maximize the Ribbon:

The Ribbon is designed to be easy to use and responsive to your current tasks; however, if you find that it's taking up too much of your screen space, you can minimize it.

  1. Click the arrow in the upper-right corner of the Ribbon to minimize it.
    Overview of the Ribbon Minimizing the Ribbon
  2. To maximize the Ribbon, click the arrow again.

When the Ribbon is minimized, you can make it reappear by clicking a tab. However, the Ribbon will disappear again when you're not using it.