Switch to Excel for the web from Sheets

Analyze data

Analyze data with Excel for the web

Add tables, charts, etc.

Use the Insert tab to insert functions, forms, tables, pictures, shapes, charts, and hyperlinks.

To insert rows, columns and cells, see the right side of the Home tab.

Insert tab, charts menu

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

Filter data with a table

Make your data into a table to create filters:

  1. Click inside your data.

  2. Select Insert > Table.

Insert tab, Table button, Filter menus

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 Panes > Freeze Top Row.

The first row is locked when you click Freeze Top Row

Next: Share and collaborate in Excel

Expand your Office skills
Explore training
Got It
Get instant Excel help
Connect to an expert now
Subject to Got It terms and conditions

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.

×