Excel is a spreadsheet program that allows you khổng lồ store, organize, và analyze information. In this lesson, you will learn your way around the Excel 2010 environment, including the new Backstage view, which replaces the Microsoft Office button thực đơn from Excel 2007.

Bạn đang xem: Microsoft excel 2010 vs 2013 vs 2016 vs 2019: complete guide

We will show you how to use and modify the Ribbon và the Quick Access toolbar, as well as how to lớn create new workbooks & open existing ones. After this lesson, you will be ready to lớn get started on your first workbook.

Getting khổng lồ know Excel 2010

The Excel 2010 interface is similar khổng lồ Excel 2007. There have been some changes we'll review later in this lesson, but if you're new khổng lồ Excel first take some time khổng lồ learn how khổng lồ navigate an Excel workbook.

The Excel interface

Click the buttons in the interactive below for an overview of how to navigate an Excel workbook.


A row is a group of cells that runs from the left of the page lớn the right. In Excel, rows are identified by numbers. Row 15 is selected here.


The name box tells you the location or the name of a selected cell. In the image below, cell B4 is in the name box. Chú ý how cell B4 is where column B & row 4 intersect.


The Quick Access toolbar lets you access common commands no matter which tab you are on. By default, it shows the Save, Undo, and Repeat commands. You can địa chỉ cửa hàng other commands lớn make it more convenient for you.


Click and drag the slider khổng lồ use the zoom control. The number to the left of the slider bar reflects the zoom percentage.


There are three ways khổng lồ view a spreadsheet. Click a page view button to lớn select it.

• Normal view is selected by default & shows you an unlimited number of cells and columns. It is highlighted in this image.

• Page Layout view divides your spreadsheet into pages.

• Page Break view lets you see an overview of your spreadsheet, which is helpful when you're adding page breaks.


You may have more data than you can see on the screen all at once. Click & hold the horizontal scroll bar and slide it to the left or right depending on which part of the page you want khổng lồ see.


Excel files are called workbooks. Each workbook holds one or more worksheets (also known as spreadsheets).

Three worksheets appear by mặc định when you xuất hiện an Excel workbook. You can rename, add, and delete worksheets.


In the formula bar, you can enter or edit data, a formula, or a function that will appear in a specific cell. In this image, cell C1 is selected and 1984 is entered into the formula bar. Note how the data appears in both the formula bar and in cell C1.


A column is a group of cells that runs from the đứng top of the page to the bottom. In Excel, columns are identified by letters. Column L is selected here.


The Ribbon contains all of the commands you will need in order lớn perform common tasks. It has multiple tabs, each with several groups of commands, & you can địa chỉ cửa hàng your own tabs that contain your favorite commands. Some groups have an arrow in the bottom-right corner that you can click to lớn see even more options.


Working with your Excel environment

The Ribbon and Quick Access toolbar are where you'll find the commands you need khổng lồ 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 mở cửa 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.

The Ribbon

Certain programs—such as Adobe Acrobat Reader—may install additional tabs lớn 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, & you can create as many groups as you need lớn keep your tabs organized. You can also showroom commands to any of the mặc định tabs as long as you create a custom group within the tab.

Right-click the Ribbon, then select Customize the Ribbon. A dialog box will appear.
Right-clicking the Ribbon khổng lồ customize it
Click New Tab. A new tab will be created with a new group inside it.Make sure the new group is selected.Select a command from the danh sách on the left, then click Add. You can also drag commands directly into a group.When you are done adding commands, click OK.

The dialog box where you can customize the Ribbon

If you vày not see the command you want, click the Choose commands drop-down box và select All Commands.

Displaying All Commands
To minimize & maximize the Ribbon:

The Ribbon is designed to be easy to lớn use và responsive khổng lồ your current tasks; however, if you find that it's taking up too much of your screen space, you can minimize it.

Click the arrow in the upper-right corner of the Ribbon lớn minimize it.
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.

The Quick Access toolbar

The Quick Access toolbar, above the Ribbon, lets you access common commands no matter which tab you are on. By default, it shows the Save, Undo, và Repeat commands. You can add other commands khổng lồ make it more convenient for you.

To địa chỉ cửa hàng commands to the Quick Access toolbar:Click the drop-down arrow to lớn 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.

Backstage view

Backstage view gives you various options for saving, opening a file, printing, & sharing your document. It is similar khổng lồ the Microsoft Office button menu from Excel 2007 and the File menu from earlier versions of Excel. However, instead of just a thực đơn it's a full-page view, which makes it easier lớn work with.

To get khổng lồ Backstage view:On the Ribbon, click the File tab.
Choose your desired option, or return to lớn your workbook by clicking any tab on the Ribbon.

Click the buttons in the interactive below to learn about the different things you can vì chưng in Backstage view.

Here, you can change various Excel options. For example, you can control the spelling and grammar check settings, AutoRecover settings, & Language preferences.


From the Print pane, you can change the print settings & print your workbook. You can also see a preview of your workbook.

Xem thêm: Tải Game My Craft Pixel Adventure, Game Phiêu Lưu Sinh Tồn Phong


From here, you can create a new blank workbook, or you can choose from a large selection of templates.