Excel Online Quick Start

See tips

See tips for Excel Online

Tip 1: The Home tab has the most frequently used features

Home tab with cut, copy, paste, paste formatting buttons; formatting options like font, alignment, and number formats; Inserting rows/columns; Sum and sort

  • Clipboard features like cut, copy, and paste.

  • Formatting features for fonts, alignment, and numbers.

  • Features to work with tables and cells.

  • Editing features to autosum, sort, and find data.

Tip 2: Use the Insert tab for 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

Tip 3: Create a form to collect data

  1. Select Forms > New Form.

  2. Add your questions and responses.

Forms > New Form

Tip 4: Freeze columns and rows

Freeze columns and rows to keep them in view while you scroll through your data.

  1. Select the cell below the rows, and to the right of the columns you want to freeze.

  2. Click View > Freeze Panes > Freeze Panes.

View tab, Freeze panes menu, Freeze panes command

Tip 5: 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

Tip 6: Let AutoSum detect your range

If you have numbers in continuous cells, use the AutoSum button AutoSum button to automatically detect the range and sum the numbers.

  1. Select the cell below or to the right of the range to sum.

  2. Select Home > AutoSum button AutoSum.

Range of cells automatically detected with the AutoSum button

Tip 7: Work offline

OneDrive syncs files to your computer.

  • Open File Explorer or the Mac Finder. You'll see OneDrive is on the left.

  • Copy files into this folder, move them around, or rename them.

If you disconnect from the Internet, you can open and edit these files offline. When you reconnect, they'll get synced to OneDrive.

Windows Explorer, OneDrive folder, Excel files

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.

×