Excel Online
Is it 12:30 or 3:30? If so, please click here:
Meeting does not exist: 89954184486.
Excel Online
The Excel Online is the online version of Microsoft Excel. Like the desktop version of Excel, the Excel Online allows you to use spreadsheets, or worksheets, to store and analyze data in organized workbooks.
Tool Limitations
The Excel Online contains many of the most useful Excel features. For example, you can perform calculations with formulas. You can even organize your data into tables and charts, though you won’t be able to customize their appearance very much.
Most of Excel’s advanced tools are not included in the Online. For instance, you won’t be able to create PivotTables, do advanced data analysis, or customize the page layout.
Basic tasks in Excel Online
With Excel Online you use your web browser to create, view, and edit your workbooks that you store on OneDrive. If your organization or college has an Office 365 plan or SharePoint site, start using Excel Online by creating or storing workbooks in libraries on your site.
Note If you are using Excel Online with SharePoint 2010 or using Internet Explorer 7, see Introduction to Excel Online and Excel Online at a glance.
Create an online workbook
From your OneDrive, click Create > Excel workbook.
To rename the workbook, click the default file name and type a new one.
Share workbooks online
After you’ve created your online workbook, you can share it with friends, coworkers, or the public. People can view your worksheets, sort and filter data, and drill into the details of PivotTables on the web or mobile device.
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.
Edit in the browser
If you try to enter data, set up a formula, add charts, or apply basic formatting and nothing happens, you are probably in read-only view. Switch to editing view:
Click Edit Workbook > Edit in Excel Online.
Open editable workbook
For more advanced editing options, click Edit in Excel.
Excel Online 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 are working with others in Excel Online you can edit the worksheet as you usually would. If others are also editing the worksheet, Excel Online shows their presence and the updates right away. Everyone has to be working in Excel Online (not in the Excel desktop application).
Print in Excel Online
- 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.
- Click Print for a preview.
- If you change your mind about printing a selected area, choose the Entire Sheet print option and click Print.
- If the final print preview looks right, click Print.
Top tips for working in Excel Online
Copy and Paste in Excel Online
A simple thing like copy and paste might have you flummoxed in a Online. You can copy and paste text, but only if you use keyboard shortcuts. And text you copied outside of Excel Online will probably be pasted as plain text, which means that formatting (things like bold, italics, and hyperlinks) needs to be re-applied. For best results, use keyboard shortcuts, not the right-click menu or Clipboard commands in Excel Online. Press CTRL+C to copy, CTRL+X to cut, or CTRL+V to paste the text (Windows); or press ⌘+C, ⌘+X, or ⌘+V (Mac). If paste is not working, you are probably looking at Reading view. Switch to Editing view: Go to Edit Workbook > Edit in Excel Online.
Reapply formatting
To reapply text formatting like bold or italics, select the text you pasted, click Home, and then click the formatting you want. If you are pasting a hyperlink, you’ll have to reconstruct it:
- Right-click the cell, and then click Hyperlink.
- In the Text to display box, type text you want to show in the cell.
- In the Address box, type the web address of the link (URL).
Format numbers
When you type numbers in your worksheet, Excel Online automatically applies the General number format but you can change this to show specific number formats like dates, currency, or even fractions.
For example, if you are working on your quarterly budget, you can use the Currency number format to show your numbers as monetary values. You can set dates to display either as a long date like Saturday, December 14, 2013 or a short date 12/14/13. Here’s how:
- Select the column, or cells you want to format.
- Click Number Format and pick the format you want.
Use AutoSum to sum numbers
If you need to sum a column or row of numbers, let Excel Online do the math for you. Select a cell next to the numbers you want to sum, click AutoSum on the Home tab, press Enter, and you are done.
Create a simple formula
You can create a simple formula to add, subtract, multiply, or divide values in your worksheet. Simple formulas always start with an equal sign (=), followed by constants that are numeric values and calculation operators such as plus (+), minus (-), asterisk(*), or forward slash (/) signs.
For example, when you enter the formula =5+2*3, the last two numbers are multiplied and added to the first number to get the result. Following the standard order of mathematical operations, multiplication is performed before addition.
- On the worksheet, click the cell where you want to enter the formula.
- Type the = (equal sign) followed by the constants and operators you want to use in the calculation.
- Press Enter.
You can enter as many constants and operators in a formula as you need, up to 8192 characters.
Tip Instead of typing the constants into your formula, you can select the cells (like B12:B15) that contain the values you want to use and enter the operators in between selecting cells.