Creating, Editing and Saving Workbooks using Excel Online
Article by Avantix Learning Team
Posted: June 26, 2016
Applies to: Microsoft® Excel® Online
Like PowerPoint and Word, you can access a free online version of Microsoft Excel and create simple workbooks online or open workbooks you or a colleague has created in the desktop version of Microsoft Excel in the online version. This is a great tool for collaborating. If you haven’t set up a free Microsoft account, you can set up an account when you go to office.com or log in with your Microsoft account and a password. Excel Online is a light version of Excel and runs in your web browser so you don’t need to install any software to use it. You won’t need Sharepoint or an Office 365 subscription to access the free version of Excel Online.
Since the online version is free, it has limited functionality (for example, you can’t create a pivot table in this version but you can view a file with a pivot table that was created in the desktop version of Excel). For those already using the desktop version of Excel, creating a workbook in the online version is very similar.
Note: Since this is an online version, features and functionality will change. Also, you may notice features that you may not have in your older desktop version of Excel (such as new chart types).
You can access Excel Online at office.com. Below is a new blank workbook in Excel Online:
Recommended article: Extracting Data with Excel’s Amazing Flash Fill
Accessing Excel Online
To access the free version of Excel Online:
- Go to office.com. Scroll down and you’ll see the icons for the free versions of PowerPoint, Excel and Word as well as a few other tools.
- Click on the Excel icon/tile.
- Sign in with a Microsoft account and password or create a new free account. If you have Hotmail, you can sign in with that account as your ID.
- Click on a template (usually the blank template). Excel creates a new workbook. It is saved automatically in Microsoft’s cloud storage (OneDrive).
- If you’re comfortable working with the desktop version of Excel, you can create, edit and format workbooks easily as the interface is very similar to the desktop version of Excel.
Switching to the desktop version of Excel
You can switch over to the full desktop version of Excel (if you have it installed) to take advantage of all of the features in Excel (such as pivot tables):
To switch to the desktop version of Excel:
- In a workbook in Excel Online, click on Edit in Excel in the Ribbon.
- A message asks you if you want to allow this website to open a program on your computer. Click on Allow.
- A message appears indicating that some files may harm your computer. To open the file, click on OK.
- A message may appear asking you to login with your Windows credentials. Enter your Windows ID and password and then click on OK. Check Sign me in automatically to avoid this message in the future.
- A message may appear asking you to choose the application to open the file. Select Microsoft Office and your current version, check Remember my choice for ms-excel links and click on OK.
- In Excel, click on Enable Editing in the bar below the Ribbon.
- Edit the Excel file and then you can save it as you normally would on your c: drive or a shared drive.
Saving an Excel workbook created online in OneDrive
If you have created a workbook with the online version of Excel, it is saved automatically on OneDrive, but you will probably want to save the file with a new name.
To save a workbook with a new name in Excel Online:
- In a workbook in Excel Online, click on the File tab on the Ribbon.
- Choose Save As and then click on the Save As icon. A dialog box appears with the folders in your OneDrive account. If necessary, create a new folder by clicking on the New Folder button, entering a name and clicking on Ok.
- Choose a folder location for your workbook and click on Save.
- Enter a name for the workbook.
- Click on Save. The file will be saved in your OneDrive cloud storage location. All users with a Microsoft account are provided with a OneDrive storage account. The size of the OneDrive storage varies depending on the type of account.
Saving an Excel workbook created in Excel Online on a desktop computer
If you want to save a workbook created in Excel Online on your desktop computer or laptop, you’ll need to download a copy.
To save a workbook on your desktop computer:
- In Excel Online, click on the File tab on the Ribbon.
- Choose Save As and then click on Download a Copy. The copy will be placed in your Downloads folder on your c: drive (if pop-ups are disabled in your browser). If pop-ups are enabled, you will be able to save a copy to a specific folder.
- Enter a name for the workbook.
- Navigate to the desired location (if pop-ups are enabled in your browser).
- Click on Save. You will now be able to open the file with the desktop version of Excel.
Uploading an Excel workbook created in the desktop version of Excel to open or edit in Excel Online
To upload an Excel workbook created in the desktop version of Excel to open or edit online:
- Open the workbook in the desktop version of Excel.
- Click on the File tab on the Ribbon and select Save As.
- Navigate to OneDrive.
- Select the desired folder.
- Click on Save.
Alternatively, you can also log in to OneDrive and upload an Excel workbook:
- Go to OneDrive.com.
- Sign in using your Microsoft account.
- On the OneDrive page, click on Upload near the top of the page and then upload your files.
Opening an Excel workbook saved in OneDrive
To open a workbook saved in OneDrive (other than using File and then Open in the desktop version of Excel):
- If you’re not logged onto Office Online, go to office.com and click on the Excel icon/tile and then sign in with a Microsoft account and password.
- Click on the File tab on the Ribbon.
- Click on Open. A menu will appear with recent documents. Click on one of the workbooks or click on More from OneDrive to choose another file. In OneDrive, click on the appropriate folder and then click on the desired file.
The free online version of Excel does have limited functionality if you’re creating a new workbook in that environment, but you can open a workbook created in the desktop version of Excel and make minor editing changes online without losing functionality.
Did you find this article helpful? If you would like to receive new articles, join our email list.
Recommended Microsoft Excel training courses
Our instructor-led classroom courses are delivered at our downtown Toronto location at 1 Yonge Street, Suite 1801 (Toronto Star Building), Toronto, Ontario, Canada (some courses may also be delivered at an alternate downtown Toronto location).
Do you want to arrange for a course to be offered at your location? Contact us and we can arrange custom training at your office on a date that’s convenient for you.
To request this page in an alternate format, contact us.
Copyright 2017 Avantix Learning Inc.
You may also like
You can delete blank rows in Microsoft Excel worksheets manually or you can use several tricks to delete multiple blank rows quickly. First, it’s essential that Excel users know how to select rows quickly using shortcuts or by using Excel commands such as Go to Special, Filter and Sort.
Moving a pivot table is not as simple as moving other objects in an Excel worksheet or workbook. You will typically need to use the Move PivotTable command in the Ribbon to move a pivot table to a different area on a worksheet or to a different sheet in the same workbook.
You can hide rows and columns in Excel using the context menu, using a keyboard shortcut or by using the Format command on the Home tab in the Ribbon. If you have hidden rows or columns, you can unhide them as well.
Microsoft, the Microsoft logo, Microsoft Office and related Microsoft applications and logos are registered trademarks of Microsoft Corporation in Canada, US and other countries. All other trademarks are the property of the registered owners.
Avantix Learning | 1 Yonge Street, Suite 1801 (Toronto Star Building), Toronto, Ontario, Canada M5E 1W7 | firstname.lastname@example.org