The Alt Key

NOTE: You can use either lower case or upper case letters. It may take a bit longer but it works.

If for some reason your mouse dies these is still a way that you can navigate the Excel Workbook. That way is the Keyboard. By pressing the ALT Key Numbers and Letters appear. By pushing the corresponding key you can Navigate

1. F – will open the Office Symbol Dialog Box
2. 1 – The First Button on the Quick Access Tool Bar
3. 2 – The Second Button on the Quick Access Tool Bar
4. 3 – The Third Button on the Quick Access Tool Bar
5. H – will display the Home Tab
6. N – will display the Insert Tab
7. P – will display the Page Layout Tab
8. M – will display the Formulas Tab
9. A – will display the Data Tab
10. R – will display the Review Tab
11. W – will display the View Tab
12. L – will display the Developer Tab
F will open the Office Symbol Dialog Box

Once the F or Office Symbol Dialog box opens there will be other choices. After you make a single choice the Dialog will close. If you want to do something else you will need to go through the motions again.

1. N – will open a New Spreadsheet
2. O – will open the Open Dialog Box
3. S – will Save the Workbook
4. A – will open the Save As Dialog Box
5. F – will open up the Save As Choices
6. P – will open the Print Dialog Box
7. W – will open the Print Choices
8. E – will open the Prepare Choices
9. D – will open the Send Choices
10. U – will open the Publish Choices
11. C – will Close the Spreadsheet
12. I – will display the Excel Options Dialog Box
13. X – will Exit the Excel Program

1  –  The First Button on the Quick Access Tool Bar. If the Save Button is the first button, by default on install, then the number 1 will Save the Workbook.
2 – The Second Button on the Quick Access Tool Bar.  If the Undo Button is the first button, by default on install, then the number 2 will Undo the last modification made to the Workbook.
3 –  The Third Button on the Quick Access Tool Bar,  If the Redo Button is the first button, by default on install, then the number 3 will Redo the last Undo made to the Workbook.

H will display the Home Tab

There are two ways to Navigate the Submenus, to Navigate you can either press the letter associated with the ALT Tab or you can use your Arrow Keys. If you are in one of the Menus the ESCAPE Key will go back one level.

The Clipboard Group

1. V will bring up the Paste Menu
     a. P – for Paste
     b. F – for Formulas
     c. V – for Paste Values
     d. B – for No Borders
     e. T – for Transpose
     f. N – for Paste Ink
     g. S – for Paste Special
     h. H –for Paste as Hyperlink
     i. A – for As Picture
          i. C – for Copy as Picture
          ii. U – for Past as Picture
          iii. I – (the capital i) for Paste Picture Link
2. X – to Cut a selected area
3. C – to Copy a selected area
4. FP – to copy the Format from a selected area
5. FO – will bring up the Clipboard Dialog

The Font Group

6. FF – will open the Font Face Dialog
7. FS – will open the Font Size Dialog
8. FG – is the command to take the Font Size up one size
9. FK – is the command to reduce the Font Size one size
10. 1 – will Bold the selected area
11. 2 – (The number 2) will Italicize the selected area
12. 3 – (The Number 3) will Underline the selected area
13. B – will add Borders to the selected area
14. H – will bring up the Cell Background Color Dialog
15. FC – will bring up the Font Color Dialog
16. FN – will Bring up the Format Cells Dialog Box – Font Tab

The Alignment Group

17. AT – Top Align
18. AM – Middle Align
19. AB – Bottom Align
20. FQ – Orientation, or test angle
21. W – Wrap Text
22. AL – Align Left
23. AC – Align Center
24. AR – Align Right
25. 5 – Decrease Indent
26. 6 – Increase Indent
27. M – Merge and Center
28. FA – will bring up the Format Alignment Dialog Box – Alignment Tab

Number Group

29. N – will bring up the Number Dialog Box
30. AN – will bring up the (Accounting Number Format) Currency Dialog Box
31. P –Percent Style
32. K – Comma Style
33. 0 (Zero, the number not the letter) – Decrease Decimal
34. 9 – Increase Decimal
35. FM - will bring up the Format Number Dialog Box – Number Tab

The Style Group

36. L – Opens the Conditional Formatting Dialog Box
37. T – Opens the Format as Table Dialog Box
38. J – Opens the Styles Dialog

The Cells Group

39. I – Opens the Insert Dialog Box
40. D – Opens the Delete Dialog Box
41. O (ooh, the letter not the number) – Opens the Format Dialog Box

The Editing Group

42. U – Opens the AutoSum Dialog Box
43. FI (I capitol i) – Opens the Fill Dialog Box
44. E – Opens the Clear Dialog Box\
45. S –Opens the Sort & Filter Dialog Box
46. FD –Opens the Find & Select Dialog Box

You can do the same for all the Tabs and Groups within Excel.