New Feature

Description

How do I access it?

Cell Merging (IMPROVED)

With the Merge and Center button on the Formatting toolbar, users can unmerge a group of cells just as easily as they can merge a group of cells. It is possible to unmerge even if the Undo option is no longer available.

üHighlight a group of cells and click Merge and Center button.
üClick the Merge and Center button again to undo the merge. 

Narrow Column
Tooltip (NEW)

Excel now displays a tooltip that identifies the contents of a cell that contains "###" because the column is too narrow to display the number.

üType in a large number in a narrow cell.
üHover over the cell to see the value.

Extended AutoSum
(IMPROVED)

The Extended AutoSum has more common functions added to the AutoSum tool. These include Average, Count, CountA, Max, and Min. It also has other enhancements such as providing a path to create any function from the AutoSum user interface (UI).

On the Standard toolbar, drop down the AutoSum menu.

Function Argument
Tooltips (NEW)

Excel displays information about function arguments as users build a new formula. The Tooltips also provide a quick path to Help. Users simply click any function or argument name within the tooltip.

Type a formula in a Excel cell such as=npv( A tooltip appears. If you hover over a component of the formula, you can link to more help. 

Function Wizard
(IMPROVED)

Users can easily search for the function they need by choosing from the list of available functions. The Function Wizard also provides users with a way to access Help on any specific function.

Click Insert–Function or select Function button of the Standard Toolbar 

 Error Checking Smart Tag(NEW)

 This feature alerts users via a Smart Tag of a possible error in a cell. Users can select a command to resolve the error, ignore it, or access further Error Checking options.

üSum a column of cells, leaving out the
last in the group.
üHover over the cell containing the total and view error checking options.

Formula Evaluator (NEW)

Users can easily evaluate the calculations that make up their formula. This function allows users to step through each calculation to understand how Excel is calculating the result.

Sort Text as Numbers (NEW)

This feature prevents unexpected sorting results by detecting mixed lists of numbers and text and enabling sorting text as numbers.

Sort a column that has both numbers and numbers formatted as text.

Excel Border Drawing (NEW)

Using the border-drawing pencil, users can easily draw cell borders in their spreadsheet. Options include changing the line color, weight, and style or even adding a border grid to their sheet.

Click the drop-down menu on the Border Drawing Button select Draw Borders and then draw with a pencil.

Tab Colors (NEW)

Users can keep their workbooks organized by color-coding their worksheet tabs. They can choose from a wide variety of colors.

üRight-click the Worksheet tab.
üSelect the color you want to add.