Introduction
Video: Getting to Know Excel
Excel 2013 is a spreadsheet program that allows you to store, organize, and analyze information.
While you may believe Excel is only used by certain people to process
complicated data, anyone can learn how to take advantage of the
program's powerful features. Whether
you're keeping a budget, organizing a training log, or creating an
invoice, Excel makes it easy to work with different types of data.
Getting to know Excel 2013
Excel 2013 is similar to Excel 2010. If you've
previously used Excel 2010, Excel 2013 should feel familiar. If you are
new to Excel or have more experience with older versions, you should
first take some time to become familiar with the Excel 2013 interface.
The Excel interface
When you open Excel 2013 for the first time, the Excel Start Screen will appear. From here, you'll be able to create a new workbook, choose a template, and access your recently edited workbooks.
- From the Excel Start Screen, locate and select Blank workbook to access the Excel interface.
Click the buttons in the interactive below to become familiar with the Excel 2013 interface.
Working with the Excel environment
If you've previously used Excel 2010 or 2007, Excel 2013 will feel familiar. It continues to use features like the Ribbon and Quick Access toolbar, where you will find commands to perform common tasks in Excel, as well as Backstage view.The Ribbon
Excel 2013 uses a tabbed Ribbon system instead of traditional menus. The Ribbon contains multiple tabs, each with several groups of commands. You will use these tabs to perform the most common tasks in Excel.
Click the arrows in the slideshow below to learn more about the different commands available within each tab on the Ribbon.
- The Home tab gives you access to some of the most commonly used commands for working with data in Excel 2013, including copying and pasting, formatting, and number styles. The Home tab is selected by default whenever you open Excel.
Certain programs, such as Adobe Acrobat Reader, may install additional tabs to the Ribbon. These tabs are called add-ins.
To minimize and maximize the Ribbon:
The Ribbon is designed to respond to your current task, but you can choose to minimize it if you find that it takes up too much screen space.- Click the Ribbon Display Options arrow in the upper-right corner of the Ribbon.
- Select the desired minimizing option from the drop-down menu:
- Auto-hide Ribbon: Auto-hide displays your workbook in full-screen mode and completely hides the Ribbon. To show the Ribbon, click the Expand Ribbon command at the top of screen.
- Show Tabs: This option hides all command groups when they're not in use, but tabs will remain visible. To show the Ribbon, simply click a tab.
- Show Tabs and Commands: This option maximizes the Ribbon. All of the tabs and commands will be visible. This option is selected by default when you open Excel for the first time.
- Auto-hide Ribbon: Auto-hide displays your workbook in full-screen mode and completely hides the Ribbon. To show the Ribbon, click the Expand Ribbon command at the top of screen.
To learn how to add custom tabs and commands to the Ribbon, review our Extra on Customizing the Ribbon.
To learn how to use the Ribbon with touch-screen devices, review our Extra on Enabling Touch Mode.
The Quick Access toolbar
Located just above the Ribbon, the Quick Access toolbar lets you access common commands no matter which tab is selected. By default, it includes the Save, Undo, and Repeat commands. You can add other commands depending on your preference.To add commands to the Quick Access toolbar:
- Click the drop-down arrow to the right of the Quick Access toolbar.
- Select the command you want to add from the drop-down menu. To choose from more commands, select More Commands.
- The command will be added to the Quick Access toolbar.
The Quick Access toolbar
Located just above the Ribbon, the Quick Access toolbar lets you access common commands no matter which tab is selected. By default, it includes the Save, Undo, and Repeat commands. You can add other commands depending on your preference.
To add commands to the Quick Access toolbar:
- Click the drop-down arrow to the right of the Quick Access toolbar.
- Select the command you want to add from the drop-down menu. To choose from more commands, select More Commands.
- The command will be added to the Quick Access toolbar.
Worksheet views
Excel 2013 has a variety of viewing options that change how your workbook is displayed. You can choose to view any workbook in Normal view, Page Layout view, or Page Break view. These views can be useful for various tasks, especially if you're planning to print the spreadsheet.- To change worksheet views, locate and select the desired worksheet view command in the bottom-right corner of the Excel window.
Click the arrows in the slideshow below to review the different worksheet view options.
- Page Layout view: This view can help you visualize how your worksheet will appear when printed. You can also add headers and footers from this view.
Worksheet views
Excel 2013 has a variety of viewing options that change how your workbook is displayed. You can choose to view any workbook in Normal view, Page Layout view, or Page Break view. These views can be useful for various tasks, especially if you're planning to print the spreadsheet.
- To change worksheet views, locate and select the desired worksheet view command in the bottom-right corner of the Excel window.
Click the arrows in the slideshow below to review the different worksheet view options.
- Page Break view: This view makes it easy to change the location of page breaks in your workbook, which is especially helpful when printing a lot of data from Excel.
