Some of the same shortcuts from Excel desktop work in the browser app. In this video, learn how to save time using helpful Excel Online shortcuts.
- [Instructor] Now, I don't about you but I'm a huge fan of keyboard shortcuts. When used effectively, they can save you huge amounts of time and effort. Now, I suggest you have XOL Shortcuts open to follow along with me. Now, some of you may actually be familiar with Excel desktop shortcuts and the good news is many of these will also work with Excel Online. So let's go ahead and click somewhere in our data range. Now, if we select Control + A now on the keyboard, what you can see is that the entire data table has been selected. Now, with this selection still activated, let's select Control + C on the keyboard, which copies the data to the clipboard. And now let's click on cell H4 and use the keyboard shortcut Control + V, which pastes the data into the active cell. Okay, let's say that we've made a mistake in that we didn't actually want to copy and paste that data at all. So let's go ahead and select Control + Z on the keyboard and as you can see, the last step has been undone. Now let's go back into the data range and click somewhere in the middle. Say, for example, we want to very quickly go to the very end of the data range, just select Control + arrow down on your keyboard. And you'll notice that the active cell has gone all the way down to D34. Now let's select Control + right arrow and we go to the rightmost cell in the active row. Now let's select Control + arrow up and we go to the very top of our range, which is cell E4. And say finally, we want to select Control + left arrow, we're back at the top left-hand side of our data range. Now, let's select our header row. And with the four cells selected, go ahead and click Control + B on your keyboard. And that bolds the data that we have here. Now let's select Control + U to underline. Then Control + I to make the text italicized. And the last thing that we can do is select Control + P on the keyboard. And this brings up the Print dialog box. Now, there are loads more Excel Online shortcuts that you can use. I suggest that you take the time to play around with them as when used effectively, they can save you huge amounts of time and effort.
Note: This course is for users who know the basics of the Excel desktop app, but are new to the web version, Excel Online. It emphasizes features that work differently in Excel Online. For basic Excel guidance, please see Excel Essential Training (Office 365) or Learning Excel 2019.
- Using Excel Online shortcuts
- Customizing your view
- Integrating the desktop version of Excel
- Sharing workbooks in Excel Online and OneDrive
- Inserting and reviewing comments
- Creating and editing charts
- Working with PivotTables and PivotCharts