Microsoft Excel Basics: The Ribbon

Microsoft Excel Basics: The Ribbon




In this article, we’ll cover the main functions in the Ribbon, which is what the main menu bar in Excel is called. Items in the ribbon contain groups of icons that perform similar functions. These include:

File
Home
Insert
Page Layout
Formulas
Data
Review
View

File:

The File menu is the leftmost item in the Excel ribbon. The File ribbon items enable you to perform file management functions, including open, save, close, and print. You also use the File menu to import from external sources into Excel, along with options that allow you to tweak Excel itself.

Pro Tip: The File menu does not appear as a ribbon in Excel for Mac. Instead, the File menu appears in the Application Menu Bar.

Home

The Home menu is the second menu in the Excel menu bar. The Home ribbon items include options for formatting font, color, conditional formatting, filter, number type, and more. All these functions help one in performing various effective calculations.

Pro Tip: Try the Format Painter. It allows you to copy the formatting from one cell to another, which can be a great time saver.

Insert

As the name suggests, the Insert menu helps you insert various options and items into an Excel spreadsheet. You can insert a variety of things ranging from pivot table to picture, clip art, shapes, screen shots, charts and graphs, text box, header and footer, symbols, equation, and more.

Pro Tip: You can also insert hyperlinks and even maps using the Insert menu.

Page Layout

Again, the name suggests the collection of functions on the Page Layout menu. You’ll see many options for configuring pages for viewing and printing—including page size, margins, colors and fonts, and so forth. You can also customize cell height and width on the Page Layout menu.

Pro Tip: You can add a background to a collection of cells—or even your entire spreadsheet. Just click Background and select the image you want to use.

Formulas 

The Formulas menu is where you find all the number-crunching options. Excel comes with lots of formulas including financial, logical, text, date & time, lookup & reference, and math & trigonometry.

Pro Tip: You can name cells or ranges of cells—this can make it easier to customize your formulas.

Data

The Data menu also contains many important functions in Excel, including imports and connections with databases. You also access the sort, filter, remove duplicates, data validation, consolidation, group, ungroup, and subtotal functions on the Data menu.

Pro Tip: Use the Data Validation function to ensure consistency in cells.

Review

Earlier in this article, we mentioned Excel’s ability to collaborate on spreadsheets. The Review menu is where many of those tasks take place. You can make comments in cells for your colleagues, check spelling, track changes, and even restrict permission using items in the Review menu.

Pro Tip: Use the Share Workbook link to share with your coworkers!