BookmarkPrint
Contents
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        
Creating a Spreadsheet
Saving a Spreadsheet
Keyboard Shortcuts Adding Text to a Spreadsheet

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

Related Articles


helpdesk.etown.edu/helpconsole2012/kb/default.aspx?pageid=excel_basics1