Related topics
Switch to Excel for the web from Sheets
Sign in with Microsoft
Sign in or create an account.
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

Create a form to collect data

  1. Select Forms > New Form.

  2. Add your questions and responses.

Forms > New Form

Freeze columns and rows at the same time

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

Let AutoSum detect your range — no selection needed

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 buttonAutoSum.

Range of cells automatically detected with the AutoSum button

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

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.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!