×
Engelsk
Vi beklager. Denne artikel er ikke tilgængelig på dit sprog.
Hurtig start til Excel

Analysér og formatér

Analyze and format in Excel

Automatically fill a column with Flash Fill

For example, automatically fill a First Name column from a Full Name column.

  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.

    Select Flash Fill Options Flash Fill Options Icon for more options.

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 .

  3. Press Enter.

Tip   For more calculations, select the down arrow next to AutoSum, and select a calculation.
You can also select a range of numbers to see common calculations in the status bar. See View summary data on the status bar.

Using AutoSum

Create a chart

Use the Quick Analysis tool to pick the right chart for your data.

  1. Select the data you want to show in a chart.

  2. Select the Quick Analysis button button image to the bottom-right of the selected cells.

  3. Select Charts, hover over the options, and pick the chart you want.

Try it!    Select File > New, select Take a tour, and then select the Chart Tab. For more information, see Create charts.

Charting with Quick Analysis

Use conditional formatting

Use Quick Analysis to highlight important data or show data trends.

  1. Select the data to conditionally format.

  2. Select the Quick Analysis button button image to the bottom-right of the selected cells.

  3. Select Formatting, hover over the options, and pick the one you want.

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

Freeze the top row of column headings so that only the data scrolls.

  1. Press Enter or Esc to make sure you're done editing a cell.

  2. Select View > Freeze Top Row.

For more information, see Freeze panes.

The first row is locked when you click Freeze Top Row

Next:    Collaborate in Excel

Udvid dine Office-færdigheder
Gå på opdagelse i kurser
Få nye funktioner først
Bliv Office Insider

Var disse oplysninger nyttige?

Tak for din feedback!

Tak for din feedback! Det lyder, som om det vil kunne hjælpe, hvis du bliver sat i forbindelse med en af vores Office-supportteknikere.

×