Basic tasks in Excel for the web (2024)

Office 365 operated by 21Vianet Office 365 operated by 21Vianet - Small Business Admin Office 365 operated by 21Vianet - Admin More...Less

With Excel for the web you use your web browser to create, view, and edit your workbooks.

Create an online workbook

  1. From your OneDrive, click Create > Excel workbook.

Basic tasks in Excel for the web (1)

  1. To rename the workbook, click the default file name and type a new one.

Basic tasks in Excel for the web (2)

Share workbooks online

To share a workbook, click Share and either type email addresses of people you want to share with or get a link that you can email to your contacts.

Basic tasks in Excel for the web (3)

Edit in the browser

If you try to enter data, set up a formula, add charts, or apply basic formatting and nothing happens, you’re probably in read-only view. Switch to editing view:

Click Edit Workbook > Edit in Excel for the web.

For more advanced editing options, click Edit in Excel.

Excel for the web saves your work automatically however, if you change your mind about any changes you’ve just made, use Undo or press Ctrl+Z.

Work together on the same worksheet

When you’re working with others in Excel for the web you can edit the worksheet as you usually would. If others are also editing the worksheet, Excel for the web shows their presence and the updates right away. Everyone has to be working in Excel for the web (not in the Excel desktop application).

Basic tasks in Excel for the web (4)

Print in Excel for the web

  1. Select the cells or chart you want to print, and then go to File > Print. To print the whole worksheet, don’t select anything before going to the Print command.

Basic tasks in Excel for the web (5)

  1. Click Print for a preview.

  2. If you change your mind about printing a selected area, choose the Entire Sheet print option and click Print.

  3. If the final print preview looks right, click Print.

    Basic tasks in Excel for the web (6)

Need more help?

Want more options?

Discover Community

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.

Basic tasks in Excel for the web (2024)
Top Articles
Latest Posts
Article information

Author: Msgr. Benton Quitzon

Last Updated:

Views: 5432

Rating: 4.2 / 5 (63 voted)

Reviews: 86% of readers found this page helpful

Author information

Name: Msgr. Benton Quitzon

Birthday: 2001-08-13

Address: 96487 Kris Cliff, Teresiafurt, WI 95201

Phone: +9418513585781

Job: Senior Designer

Hobby: Calligraphy, Rowing, Vacation, Geocaching, Web surfing, Electronics, Electronics

Introduction: My name is Msgr. Benton Quitzon, I am a comfortable, charming, thankful, happy, adventurous, handsome, precious person who loves writing and wants to share my knowledge and understanding with you.