Business Automation and Software Blog

Excel Tips: Keyboard Shortcuts to Access the Ribbon Programs

Posted by Robert Baran on Fri, Jan 18, 2013 @ 11:14 AM

Excel Tips and Tricks / Business Reporting Question: How do I access any ribbon command in a few keystrokes?

Answer: By using access keys: Access keys provide a way to quickly use a command by pressing a few keystrokes, no matter where you are in the program. Every command in a program that uses an Office

Fluent ribbon can be accessed by using an access key. You can get to most commands by using two to four keystrokes.

Why: To access any ribbon command in a few keystrokes

Applies To: Excel 2007, and 2010

1. Press and release the ALT key.

The KeyTips are displayed over each feature that is available in the current view.

Excel Tips and Tricks

2. To apply conditional formatting using access keys; Refer to the data below:

Excel Tips and Tricks

3. Select C2:C18.

4. Press the ALT key.

5. Press H.

6. Press L.

7. Press H.

8. Press G.

9. Enter as below:

Excel Tips and Tricks

10. Press the Enter Key.

11. The result will be as below:

Excel Tips and Tricks

Contact PositiveVision ► ► for a Complimentary  Reporting Consultation

Topics: Business Reporting, Excel Tips and Tricks