In this Excel Tutorial I will show you how to use Hotkeys using Excel 2010.
To make Hotkeys appear press ALT on your keyboard and we can see at the top our icons.
Now, I will show you basic on example.
Using Hotkeys you can navigate your document like switches worksheet types.
In first example we have to click CTRL + PgUp. Picture below, showed us this move on example keyboard.
Our sheets should change and in this example move from Sheet1 to Sheet10.
Now, we have to go back. To do this we clicked CTRL + PgDn. Picture below, showed us this move on example keyboard.
Our sheets should change and in this example move from Sheet10 to Sheet1
This are simple Shortcuts which we can use to navigate your tabs.
We can also Format our Cells. To do this we have to type 'Test' and clicked CTRL + 1.
Ad we can see below, Format Cells dialog box appears .
We can also change our Test by clicking CTRL + 2.
As we can see below, I apply bold using CTRL + 2.
We can also apply bold using excel help by clicking F1. We can see that Excel Help Window appears.
You can find more information about Hotkeys on Microsoft website. When we scroll down then we can see all shortcuts.
I hope this Excel Tutorial was useful.
Katie and Emil