Tag Archives: Alt key

Modifier Keys

24 Sep

The key to maximizing your “computer” work-life is to comprehend, to retain and to implement a knowledge of modifier keys so that:

  • You can accomplish your work tasks in a fraction of the time
  • You can streamline repetitive tasks

There are 4 modifier keys that you should learn or know:

Alt – This modifier key (along with a second key) will help you to activate all your menus and even use the new Windows 7 ribbon. I remember it this way (A LT (looks like “a list”)

Control – This key is a power house key (using the control key with arrows or with the Home / End key) is like charging your keyboard with the energizer bunny. (BAAAM!)

Shift – is the anchor key (something that is held down with weight). By using this key you can highlight text.

Windows –  is used with the Operating System not necessarily with the applications.

Part 2 of this next month . . .


Highlight Shortcut and QAT

22 Jun

Highlight Shortcut

Create macro to highlight a row:

  1. Open Excel
  2. Go to Developer tab (Alt +L)
  3. Create new macro
  4. Create Macro Name and Shortcut key(optional) and click OK
  5. Select Use Relative References button (Developer ribbon)
  6. Select any cell
  7. Click Home tab and Font Color and choose yellow
  8. Go to Developer ribbon and stop recording

Place button on quick access task (qat) bar and assign macro:

  1. Right click quick access toolbar
  2. Choose Customize Quick Access toolbar
  3. Make sure the left-nav selection is Customize
  4. Choose, Choose commands from and select Macros
  5. Click on your Macro name (per above) and add to 2nd column and press OK
  6. Optional: Click Modify button (at bottom of 2nd column to change icon)

How to use:

As you open your excel you will find a new icon in your quick access task bar and when you click the Alt key you will see a number attached to your new button. To highlight choose a cell, row or column (Shift + spacebar, Control + spacebar) and use the Alt Key and number combination to highlight.