Switch to Excel from Sheets


Tips for Excel

You'll notice some differences between Google Sheets and Excel for the web. Here are some tips that will make your transition to Excel for the web easier.

Tip 1: The Home tab has what you need

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

The Home tab has the most frequently used buttons and features: Clipboard buttons (like cut, copy, paste) and formatting options (like colors, alignment, and number formatting).

Make sure you check out the right side of the Home tab. That's where you can insert rows and columns, sum numbers, and sort.

Tip 2: The Insert tab is for tables, charts, etc.

The Insert tab is the place to insert special things, like tables, charts, hyperlinks, and so on.

If you need to insert rows, columns and cells, then go to the right side of the Home tab.

Insert tab, charts menu

Tip 3: Need a form? Start with a survey.

If you want to insert a form that collects data, first create a survey in OneDrive, by clicking New > Excel survey. Then you'll have both a survey and a workbook that collects the data from the survey.

New menu, Excel survey command

Tip 4: Freezing columns and rows at the same time

If you want to freeze columns and rows at the same time, select a cell that is below the rows you want to freeze, and to the right of the columns you want to freeze. Then click View > Freeze Panes > Freeze Panes.

View tab, Freeze panes menu, Freeze panes command

Tip 5: You can filter, with a table

If you need to filter, click inside some data, and then click Insert > Table. That will give you filter buttons to work with.

Insert tab, Table button, Filter menus

Tip 6: Let AutoSum detect your range — no selection needed

If you have numbers in continuous cells, then the AutoSum button AutoSum button makes things easier. It will detect the range to be summed automatically. In this example, it detected that cells C2 through C7 needed to be summed. There's no need to type in the cell references, like in Sheets.

Range of cells automatically detected with the AutoSum button

Tip 7: Work offline

Just like the Drive app, the OneDrive app syncs files to your computer. Open File Explorer or the Mac Finder and you'll see the OneDrive folder on the left. Copy files into this folder, move them around, and so on. 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.