How to save online Excel sheet
Last week we explored a few techniques to convert Excel spreadsheets to HTML. But nowadays when everyone seems to be moving to the cloud, why not we? The new technologies of sharing Excel data online are a way simpler and provide a handful of new opportunities that you can benefit from. Show
With the emergence of Excel Online, you no longer need cumbrous HTML code to export your tables to the web. Just save your workbook online and access it literally from anywhere, share with other users and work on the same sheet all together. With Excel Online you can also easily embed your worksheet on a web site or blog and let your visitors interact with it to find just the information they are looking for. Further on in this article, we are going to investigate all these and many other capabilities provided by Excel Online. If you are new to the cloud in general, and Excel Online in particular, the easiest way to start is sharing your existing workbook using the familiar interface of Excel desktop. All Excel Online spreadsheets are stored on OneDrive web service (formerly, SkyDrive). As you probably know, this online storage has been around for a while, but now it is integrated in Microsoft Excel as an interface option accessible in a click. In addition, your invitees, i.e. other user users that you are sharing your spreadsheets with, no longer need a Microsoft account to view and edit the Excel files you've shared. If you don't have a OneDrive account yet, you can sign up now. This service is easy, free and definitely worth your attention because most Office 2013 and 2016 applications, not just Excel, support OneDrive. Once you are signed in, proceed with the following steps. 1. Sign into your Microsoft accountMake sure your are also signed into your Microsoft account from within Excel. On your Excel workbook, look at the top right-hand corner. If you see your name and a photo there, you can skip this step, otherwise click the Sign in link. Excel will display a message asking to confirm that you really want to allow Office to connect to the Internet. Click Yes, and then enter your Windows Live credentials. 2. Save your Excel spreadsheet to cloudVerify that you have the right workbook open, i.e. the one you want to share online, just to be on the safe side. In this example, I will be sharing a Holiday Gift List so that my family members and friends can view it and contribute : ) With the correct workbook open, navigate to the File tab, click Share in the left pane. The Invite People option will be selected by default and you click Save To Cloud in the right pane. After that choose a cloud location to save your Excel file. OneDrive is the first option you will see on the right selected by default, and you simply choose the destination folder in the left pane. Note: If you don't see the OneDrive option, then either you don't have a OneDrive account or you are not sighed in. I've already created a special Gift Planner folder and it shows up in the Recent Folders list. You can choose any other folder by clicking the Browse button underneath the Recent Folders list or create a new one in the usual manner by right clicking anywhere within the right part of the Save As dialog window and selecting New > Folder from the context menu. With the proper folder selected, click the Save button. 3. Share the spreadsheet you saved onlineYour Excel workbook is already online and you can view it on your OneDrive>. If you wish to share the online spreadsheet with other people, one more step is left for you to do - choose one of the following sharing options:
Tip: If you want to limit the areas of your Excel workbook that other users can view, switch to the File > Info and click Browser View Options. You will be able to choose the sheets and named items you want to display on the Web. That's all! Your Excel workbook is online and shared with other users of your choosing. And even if you are not collaborating with anybody, this is an easy way to access your Excel files virtually from anywhere, no matter whether you are at the office, work from home or travel. Working with workbooks in Excel OnlineIf you are a confident inhabitant of the Cloud universe, you won't have any problems with mastering Excel Online during your lunch break. How to create a workbook in Excel OnlineTo create a new workbook, click a little arrow next to Create and choose Excel workbook from the drop-down list. To rename your online workbook, click the default file name and type a new one. To upload your existing workbook to Excel Online, click on the Upload button on the OneDrive toolbar and browse for the file on your computer. How to edit workbooks in Excel OnlineOnce you have the workbook open on Excel Online, you can work with it using Excel Web App almost in the same way you use Excel desktop: enter data, sort and filter, calculate with formulas and present your data visually with charts. There is only one significant difference between web-based Excel spreadsheets and desktop. Excel Online does not have the Save button because it saves your workbooks automatically. If you've changed your mind about something, press Ctrl+Z and Ctrl+Y to undo or redo, respectively. You can use the Undo / Redo buttons on the Home Tab > Undo group for the same purpose. If you are trying to edit some data but nothing happens, most likely you are in read-only view. To switch to editing mode, click Edit Workbook > Edit in Excel Web App and make quick changes directly in your web browser. For more advanced data analysis features such as pivot tables, sparklines or connecting to an external data source, click Edit in Excel to switch to the desktop version. When you save the spreadsheet in your Excel, it will be saved where you originally created it, i.e. in your OneDrive. Tip: If you want to make quick changes in several workbooks, the fastest way is to open the list of files on your OneDrive, find the workbook you want, right click it and select the needed action from the context menu. To share your web based Excel spreadsheet, click Share > Share with People and then choose either:
You can also choose whether you want to give viewing or editing permissions to your contacts. When several people are editing the worksheet at the same time, Excel Online shows their presence and the updates straight away, provided that everyone is editing in Excel Online, not in Excel desktop. When you click a little arrow next to the person's name in the top right-hand corner of your spreadsheet, you can even see which exactly cell is being edited at the moment. How to lock certain cells for editing in a shared worksheetIf you are sharing your online sheets with a number of people, you may want to limit the editing rights for your team members only to certain cells, rows or columns in your Excel document on OneDrive. To do this, you need to choose the range(s) that you allow to edit in your desktop Excel and then protect the worksheet.
Use Excel Web App to embed the online spreadsheet onto a website or blogIf you want to publish your Excel workbook on a web-site or blog, perform these 3 quick steps in the Excel Web App:
Embedded Excel Web AppWhat you see below is an interactive Excel spreadsheet that illustrates the technique in action. This "Days Until Next Birthday" app calculates how many days are left until your next birthday, anniversary or other event and shades the gaps in different tints of green, yellow and red. In the Excel Web App, just enter your events in the first column and try changing the corresponding dates to experiment with the results. If you are curious to know the formula, please check out this article - How to conditionally format dates in Excel. Excel Web App mashupsIf you want to get more interactions between your web-based Excel spreadsheets and other web apps or services, you can use the JavaScript API available on OneDrive to create interactive data mashups. Below you can see the Destination Explorer mashup created by the Excel Web App team as an example of what web developers can create for your website or blog. This mashup uses the APIs of Excel Services JavaScript and Bing Maps and its purpose is to help the web-site visitors choose a destination where they want to travel. You can choose a location and the mashup will show you the local weather or the number of tourists that visit the area. The screenshot below shows our location :) As you see, working in Excel Online is simple. Now that you know the basics, you can explore the other features and manage your online spreadsheets with ease and confidence! You may also be interested inDoes Online Excel save automatically?AutoSave is a new feature available in Excel, Word, and PowerPoint for Microsoft 365 subscribers that saves your file automatically, every few seconds, as you work. AutoSave is enabled by default in Microsoft 365 when a file is stored on OneDrive, OneDrive for Business, or SharePoint Online.
How do I save a live Excel File?Save your workbook. Click File > Save As.. Under Save As, pick the place where you want to save your workbook. ... . Click Browse to find the location you want in your Documents folder. ... . In the File name box, enter a name for a new workbook. ... . To save your workbook in a different file format (like . ... . Click Save.. How do you save an Excel sheet from online as a PDF?Drag and drop a Microsoft Excel file (XLSX or XLS) to use our Excel to PDF converter. Select a Microsoft Excel file (XLSX or XLS) to convert to PDF. Drag and drop a Microsoft Excel file (XLSX or XLS) to convert to PDF. Your file will be uploaded to Adobe cloud storage.
Is online Excel same as offline Excel?Excel Desktop App is good for retrieving data from external sources. However, the online version enables you to bring in data from geography and stock sources from the internet. Editing. Excel Online doesn't offer many editing options, like inking or notes feature, like the desktop version.
|