Microsoft Excel Keyboard Accelerator

Microsoft Excel 2007 Tips #3 -- Using the Keyboard Accelerator

This accelerator aims to allow you to access every command in the Excel using the keyboard. This function may not work for everybody, however, for people who don't usually use mouse, just like me, this knowledge would prove useful.

To do this, you would need to press and release the ALT key. You will notice then, there would be a ToolTips above each command, with an associated accelerator key.

Try this simple trick, could be more helpful than you might think.

More articles on ToyangQren's another blog.

Exploring: Make your own Keyboard Shortcut (windows vista trick)

Make your own Keyboard Shortcut for your Favorite

As discussed in my previous post, Vista assigns specific Keyboard Shortcuts for certain operations. However, Vista allows you to create one by yourself!!

What you need to do is to follow these simple steps:

1. Select a Shortcut of your favorite program. Here, I use an example of using Notepad shortcut on my desktop
2. Right click on your selected icon
3. Click Properties
4. Under 'Shortcut' tab, look for the 'Shortcut key' box.
   
5. On your keyboard press the shortcut you want it to be. However, not all buttons can be used. Here are the options:
1. F1-F12 or Numpad Key
2. SHIFT + (F1-F12 or Numpad Key)
3. CTRL + (F1-F12 or Numpad Key)
4. (CTRL + ALT or CTRL + SHIFT or ALT + SHIFT) + Almost any key
6. Click OK once you are done
   

Tips: It is always good to jot down the shortcuts if you are starting to make some, just in case you forget them. Yet, using it often enough will make you memorize them even faster.

This is really helpful as it would save you a lot of trouble by searching and looking for the shortcut of your favorite programs. Try it!!

This is my short video, demonstrating what you have just read. Enjoy.

Hope this helps.

Exploring: Keyboard Shortcut (windows vista trick)

Keyboard Shortcut: Time Saver

Here are some keyboard shortcuts specific in Vista, that I find very useful in saving time. Try to use it often, and you will be able to memorize it with minimum efforts.

• Opening Shortcuts

1. WINDOWS KEY + E - Open Windows Explorer **
   
2. WINDOWS KEY + F - Open Search **
3. WINDOWS KEY + U - Open the Ease of Access Center
   
4. WINDOWS KEY + R - Open the Run Window **
   
5. WINDOWS KEY + (1-9) - Run the nth program on your Quick Launch bar **
   
6. WINDOWS KEY + Pause - Open System Properties
7. CTRL + SHIFT + ESC - Open Windows Task Manager

• Managing Windows

1. ALT + F4 - Close the Active Window **
   
2. ALT + TAB - Switch to Previous Active Window
   
3. WINDOWS KEY + TAB - Flip 3D **
   
4. CTRL + WINDOWS KEY + Tab - Persistent Flip 3D
   
5. ALT + ESC - Cycle Through all Open Windows
   
6. WINDOWS KEY + T - Cycle through Taskbar Applications
   
7. WINDOWS KEY + M - Minimize all Open Windows
   
8. WINDOWS KEY + Shift + M - Undo all Window Minimization
   
9. WINDOWS KEY + D - Toggle Desktop Focus **
   
10. WINDOWS KEY + B - Shift focus to the System Tray
11. WINDOWS KEY + Space - Shift focus to Sidebar **
    

Those with double asterisks are shortcuts that I use really often, and I ensure you, they help me saving time and keeping things simple.

Hope this helps. Happy Pressing!! ;p

Tips: Do you know you can also create a keyboard shortcut for you favorite programs?? Click here to find out how.

Feel free to bookmark this article ;p