Tips for Excel for the web
Create a form to collect data
-
Select Forms > New Form.
-
Add your questions and responses.
Freeze columns and rows at the same time
Freeze columns and rows to keep them in view while you scroll through your data.
-
Select the cell below the rows, and to the right of the columns you want to freeze. For example, select cell B3 if you want to freeze the first two rows and the first column.
-
Click View > Freeze Panes, and then select Freeze at selection.
Let AutoSum detect your range — no selection needed
If you have numbers in continuous cells, use the AutoSum button 
-
Select the cell below or to the right of the range to sum.
-
Select Home >
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.
Learn more
Excel help and learning
Need more help?
Want more options?
Explore subscription benefits, browse training courses, learn how to secure your device, and more.
Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.
