Tips for Excel
You'll notice some differences between Google Sheets and Excel Online. Here are some tips that will make your transition to Excel Online easier.
Tip 1: The Home tab has what you need
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.
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.
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.
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.
Tip 6: Let AutoSum detect your range — no selection needed
If you have numbers in continuous cells, then the 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.
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.