Home > Microsoft Office > Excel > Online Basics - Excel
Online Basics - Excel
Excel Online is the online version of Microsoft Excel that allows
users to create Excel spreadsheets without having to install
Microsoft Excel onto their computer. It also is linked
to OneDrive, meaning you can easily save and share these documents with
others online.
Quick links to sections in this article:
Accessing Excel Online
Step 1:Go to the Office 365 homepage via your preferred web browser.For instructions on how to log on to Office 365, refer to the Office 365 Basics article.
Step 2:Once you've logged on to Office 365, click on the Excel Online icon to access Excel Online.
Creating a Spreadsheet
After clicking on the Excel Online icon, select which type of workbook you wish to use. You can choose a blank workbook, or use a provided template.
 Note: After creating a new workbook, you can rename your new project by clicking the title above the spreadsheet and typing a new title.
Adding Text to a Spreadsheet
Now that you've created a spreadsheet, you can now add and edit text inside your spreadsheet's cells.
Step 1:
Click on the cell you wish to add text to.
Step 2:
Either start typing directly into the cell once the cell has been selected, or type in the text box located above the spreadsheet.
Step 3:You can change your text's fonts and font sizes, use the following tools located on the toolbar above your spreadsheet: For more in depth instructions on how to customize fonts, refer to the Word Basics help guide.
Note: These steps are for adding text to a newly created spreadsheet. If you have closed out of your spreadsheet and are opening it at a later time, you must first select Edit Workbook and then either Edit in Excel (if you have Microsoft Excel installed on your computer) or Edit in Excel Online.
Keyboard Shortcuts
In Excel Online, there are a variety of keyboard shortcuts that make editing your workbook just a little bit easier. All you have to do is select the cell(s) you wish to edit, and then press the indicated keyboard shortcuts. Here is a list of some shortcuts you might commonly use:
Editing within a cell:
[Ctrl] + [C] = Copy
[Ctrl] + [V] = Paste
[Ctrl] + [X] = Cut
[Ctrl] + [B] = Bold text within selected cell
[Ctrl] + [I] = Italicize text within selected cell
[Ctrl] + [U] = Underline text within selected cell
[Ctrl] + [Z] = Undo an action
[Ctrl] + [Y] = Redo an action
[Delete] or [Ctrl] + [D] = Clear selected cell(s)
Navigation:
[Enter] = Moves down one column
[Tab] = Moves over one row
[Ctrl] + [F] or [Shift] + [F5] = Find
Saving a Spreadsheet
Because Excel Online is web based, you no longer have to worry about
saving your workbooks. Excel Online automatically saves your workbook for
you as you type, and stores it in your One Drive.
For instructions on how to access your workbook in your One Drive, please refer to the Navigate/Access Files article in the OneDrive section of the Knowledgebase.
Step 1:Click on the File tab on the Ribbon, and then Save As. 
Step 2:Choose how you want to save your file.
For additional assistance, please refer to this help guide:
https://support.office.com/en-us/article/Basic-tasks-in-Excel-Online-0DCAC23B-8430-4289-87A5-F2C97BDB49E1
| Author: andersonjm | Last Updated: 4/17/2018 10:01 AM | Page Views: 2688 |
helpdesk.etown.edu/helpconsole2012/KB/default.aspx?pageid=excel_basics1
|