Microsoft Excel 2007 Version Overview

The following is a list of key new features in Microsoft Excel 2007.

For other versions of Excel, check out the following:

Microsoft Excel 2016 Version Overview

Microsoft Excel 2013 Version Overview

Microsoft Excel 2010 Version Overview

Looking for Excel training courses?


Microsoft Excel 2007 New Features

Applies to: Microsoft Excel 2007 for Windows

The following are some of the key new features available in Microsoft Excel 2007.

The Ribbon

The Ribbon first appeared in 2007 and offers a new way of navigating compared to the traditional Excel menus. The Ribbon tabs are arranged in groups and certain tabs only appear when you have a specific item selected such as a picture.

Office Button (Backstage View)

The Office button replaced the traditional File menu and is also called the Backstage View. Here you'll be able to open, close, save and print your documents.

Customize the Quick Access Toolbar

In Excel 2007, you have the ability to customize the Quick Access Toolbar and add your favorite buttons.

Improved Sorting and Filtering

Excel 2007 includes significant improvements for filtering lists, Check boxes now appear automatically for filtering most fields. You can filter multiple items and also filter in pivot tables. You can also sort by more fields and sort by color and dates.

Format Using Themes and Styles

Excel 2007 includes themes which are tied to styles. A theme is a predefined set of colors, fonts and effects that can be applied to your entire workbook. There are predefined styles that are based on the theme that you can choose to apply to tables, charts, shapes and cells. You can also create your own themes and styles.

Enhanced Conditional Formatting

Several changes have been made to conditional formatting. You can now apply data bars, icon sets and other types of conditional formatting.

Larger Spreadsheets

You now have 16,284 columns and 1,058,576 rows. This is a significant increase from Excel 2003.

Resizable Formula Bar and AutoComplete

In Excel 2007, the formula bar now resizes so a formula doesn't cover data in the cells. Excel 2007 also now has an Autocomplete feature where a drop-down menu appears when you start to type in a function.

New Functions

A few new functions were added in Excel 2007 including SUMIFS, COUNTIFS and IFERROR.



Contact us to discuss any of our custom options.

Check out our blog for more Excel tips, tricks and shortcuts.

Public courses are delivered at our downtown Toronto location at 1 Yonge Street, Suite 1801 (Toronto Star Building), Toronto, Ontario, Canada.

Avantix Learning Excel Courses | Frequently Asked Questions (FAQs)

Do you need more information? Contact us!

Copyright 2017 Avantix Learning Inc.

To request this page in an alternate format, contact our staff.

^ Back to top

Microsoft Excel training courses in Toronto. with instructor creating a virtual graph.

You may like

Excel XLOOKUP Function (Overview, Syntax + Formula Examples)

Excel XLOOKUP Function (Overview, Syntax + Formula Examples)

The XLOOKUP function is a replacement for Excel's traditional VLOOKUP function (as well as HLOOKUP and INDEX / MATCH functions). It has a new set of arguments and is available in Excel 2021 and 365. It allows you to look up a value from an array in a range or table and return one or more results. One of the primary benefits of XLOOKUP is that it can look up from columns to the left in a data set and return a range.

How to Lock Cells in Excel (3 Ways)

How to Lock Cells in Excel (3 Ways)

It's easy to lock and protect cells in Microsoft Excel to prevent users from changing data or formulas. This involves a two-step process …

You may also like

How to View Document Statistics in Microsoft Word

How to View Document Statistics in Microsoft Word

Microsoft Word automatically tracks statistics about your documents. These statistics appear in Word Properties and include the file name, directory, template, author, editing time, last print date and the user who last modified the document.

How to Center Text Vertically on a Page in Word

How to Center Text Vertically on a Page in Word

You can center text vertically on a page in Word using the Page Setup dialog box. The strategies to center text are different if the document is a single section or multi-section document. As a best practice, you should NOT use extra blank returns or paragraphs to center text vertically on a page. If you want to center align text horizontally, simply select the text and then click any of the Alignment commands in the Paragraph group on the Home tab in the Ribbon.

Microsoft, the Microsoft logo, Microsoft Office and related Microsoft applications and logos are registered trademarks of Microsoft Corporation in Canada, US and other countries. All other trademarks are the property of the registered owners.

Avantix Learning | 1 Yonge Street, Suite 1801 (Toronto Star Building), Toronto, Ontario, Canada M5E 1W7 |

Pin It on Pinterest