Sign in
Excel 2016 Quick Start

Analyze and format

Analyze and format in Excel 2016

Fill column data with Flash Fill

Use Flash Fill to automatically fill a column, such as First Name, derived from another column, such as Full Name.

  1. In the cell under First Name, type Molly and press Enter.

  2. In the next cell, type the first few letters of Garret.

  3. When the list of suggested values appears, press Return.

  4. Select Flash Fill Options Flash Fill Options Icon to take further action.

Try it!    Select File > New, select Take a tour, and then select the Fill Tab.

Flash filling a column of data

Quickly calculate with AutoSum

  1. Select the cell below the numbers you want to add.

  2. Select Home > AutoSum The AutoSum button (in the Editing group).

  3. In the selected cell, press Return to see the results.

  4. To do other calculations, select Home, select the down arrow next to AutoSum, and then choose a calculation.

Tip    You can also select a range of numbers to see common calculations in the status bar. For more information, see View summary data on the status bar.

Using AutoSum

Use conditional formatting

Highlight important data or show data trends with the Quick Analysis tool.

  1. Select the data you want to conditionally format.

  2. Select the Quick Analysis button button image in the bottom-right corner of the selection.

  3. Select Formatting, hover over a conditional format, such as Icon Set, and then pick the one you prefer.

Try it!    Select File > New, select Take a tour, and then select the Analyze Tab.

Using Quick Analysis to highlight data

Freeze the top row of headings

When you have many rows, you can freeze the top row of column headings so that only the data scrolls.

  1. Open Excel.

  2. Make sure you have finished editing in a cell. To cancel cell editing mode, press Enter or Esc.

  3. Select View > Freeze Top Row (in the Window group).

For more information, see Freeze panes.

The first row is locked when you click Freeze Top Row

Next:    Collaborate in Excel 2016

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.