Thursday, September 4, 2008

How to Save Time and Effort with Computer Shortcuts

Have you ever noticed that in the menu bar at the top of the screen some of the letters are underlined? For instance, the letter "F" in the word File is underlined. If you look closely at a few different programs, you will see that usually the first letter is underlined, but sometimes a different letter is the chosen one. You may see the "o" in Format underlined or the "a" in Favorites. These keys are marked as shortcut keys. Press and hold down the ALT key while you press the indicated letter and you can access your chosen menu without lifting your fingers off the keyboard to use the mouse.

After you have chosen one of the items from the menu bar, a drop-down menu will appear with further choices. (Try it by clicking on the word File in the upper left corner of your screen, or use the shortcut explained above of Alt+F.) Again, some of the letters in the words will be underlined. You can use any underlined letter to choose that option. Pressing the chosen letter is the same as clicking your mouse on the chosen word. However, you will also notice that some of the words in the drop-down menu have another shortcut shown to the right of the word. For instance, the word save has a CTRL-S next to it. This means that you can use the CTRL-S shortcut even if the menu is not shown. For example, you press and hold down the CTRL key and the "s" key simultaneously to save a file even if you did not open the File drop-down menu first.

The Menu Bar

After you have chosen one of the items from the menu bar, a drop-down menu will appear with further choices. (Try it by clicking on the word File in the upper left corner of your screen, or use the shortcut explained above of Alt+F.) Again, some of the letters in the words will be underlined. You can use any underlined letter to choose that option. Pressing the chosen letter is the same as clicking your mouse on the chosen word. However, you will also notice that some of the words in the drop-down menu have another shortcut shown to the right of the word. For instance, the word save has a CTRL-S next to it. This means that you can use the CTRL-S shortcut even if the menu is not shown. For example, you press and hold down the CTRL key and the "s" key simultaneously to save a file even if you did not open the File drop-down menu first.

Keyboard shortcuts are very useful. As a matter of fact, they can help to make your computing life much more pleasant. They are available in most Windows programs, but finding them can be a tiresome task. Many, but not all, Windows programs share the same shortcuts.

The Basics

Start with the most obvious ones, the shortcuts found on the menu bar, as described above. Of these shortcuts, here are a few of the most useful:

  • DELETE removes the file, text, or graphic that you have highlighted and sends it to the recycle bin.
  • CTRL+S Saves the current file.
  • CTRL+X Removes the current highlighted selection and places it in an area of the computer memory.
  • CTRL+C Copies the current highlighted selection. It removes it from the document and places it in the clipboard.
  • CTRL+V Pastes whatever is in the clipboard into the document at the current location of the cursor.
  • CTRL+A Selects or highlights all of the text and/or objects in a document. This is handy when you want to move or copy everything in the current document.
  • CTRL+P Prints the current document.
  • CTRL+O Opens a new document. This is especially useful surfing the Web. In Netscape Navigator and newer versions of Internet Explorer, this will bring up a window where you can enter a Web address. (Older versions of Internet Explorer use CTRL+L instead of CTRL+O.

In addition to these shortcuts, each program has other, less obvious shortcuts. You can usually find these by going to the Help menu and typing in the word "shortcut" or "keyboard shortcut". However, sometimes it is difficult to unearth these tips. A few of them are completely undocumented so you won't even find them in the help menu. Let me share with you a few of my favorites.

Windows Key

If you have a Windows keyboard, in Windows 95/98, you have some extra shortcuts at your fingertips. How do you know if you have a Windows keyboard? It's easy. Look at the keyboard; a Windows keyboard labels one or two keys on the bottom row with the Microsoft Windows logo. These keys are very handy. Pressing the Windows key alone will display the Start menu.

One of my favorites is to use the Windows key +D to minimize all the open windows and quickly return to the Windows desktop. Pressing Windows +D again will restore all windows to their previous location.

If you have a Windows keyboard, you will also see a key with a design that looks like a list of words on a piece of paper. This is called the application key. It is a shortcut for right clicking. It will display an item's shortcut menu.

Function Keys

Most computer keyboards have a row of function keys at the top of the keyboard. These keys are marked F1 through F12. While they were widely used with older DOS programs, they are seldom used today. However many programs, including most of Microsoft's popular products, support use of the function keys. As a throwback to DOS days, you will find that the F1 key will often bring up a help menu. The function keys are also often used in combination with other keys like the CTRL key, the ALT key, and the Shift key. This results in a plethora of possible keyboard shortcuts. Look in the help menu of the program that you are using to find a list of the function keys and their uses.

Shortcuts to Help You Navigate

Ever want to move quickly to the beginning or end of a document? Most programs will take you there immediately when you use CTRL+Home or CTRL+End.

If you have several windows open at the same time, using ALT+Tab will switch you to the window that you last used. Holding down ALT while repeatedly pressing TAB will cycle you through all of the open windows.

Shortcuts to Help You Find Things

If you have a Windows keyboard, pressing Windows+F at the Windows desktop (the main Windows screen) will bring up the find window which is a help when you can't find a file. If you don't have a Windows keyboard, F3 will bring up the find window.

If your Windows desktop is cluttered with icons and files, you may have trouble finding the one that you are looking for. If that's the case, simply press the first letter of the name of program or icon that you are looking for. For instance, if you are looking for Internet Explorer, press the "I" key. If Internet Explorer is the only icon on your desktop that starts with the letter I, it will be highlighted. If there are other icons or shortcuts that start with the letter I, pressing the I key again will highlight each I icon in alphabetical order.

Power User Shortcuts

You can delete an item immediately without placing it in the Recycle Bin by pressing Shift +Delete. But be careful. Once you do this, there is no way to retrieve the item.

When you are at the Windows desktop, use Windows+E to pop up Windows Explorer. If you have been using My Computer to view or move files, Windows Explorer is like My Computer, but a bit more powerful. If you have never used Explorer, try it. It's worth a look.

Right-click on My Computer and choose Properties to get to the System Properties screen where you can find some of the inner workings of the computer. To get there even faster, hold down the ALT key and then click on My Computer. For those of you who don't want to get that intimate with your computer, this shortcut may still be useful since it takes you to the screen which tells you which operating system you are using, the type of processor in your computer, and the amount of memory that your computer has.

Shortcuts for the Mac User

If you are a Mac user, you should rejoice. There are even more, and sometimes better, shortcuts for the Mac. If you jumped right here from the top of the page, please go back and read the above information in this article. Even though it is written for the PC, you will find that quite a bit can be used for the Mac as well.

Mac shortcuts revolve around the Command key, which is the key with the Apple on it, plus the symbol that looks like a freeway interchange, the Control key, and the Function Keys. Although the Mac does not have underlined letters in the main menu bar, when you open any item on the menu bar, you will see the shortcut keys listed next to each item. In many cases, the shortcuts are similar to PC shortcuts. For example, use Comand+S to save, Command+W to close a window, and Command+F to open the find screen. Fortunately for you Mac users, most of the shortcuts are easy to find. Just click on Help and type in "Shortcut".

The End

Whatever you are doing, there are probably shortcut keys to help you. Even if you love using the mouse, there are times when you will find shortcuts keys will save you time and energy. Just think if you discovered only one shortcut a month and learned to use it, by the end of the year not only would you be more productive, but you might also like your computer more.

Microsoft Word shortcut keys

Shortcut Keys Description
Ctrl + A Select all contents of the page.
Ctrl + B Bold highlighted selection.
Ctrl + C Copy selected text.
Ctrl + X Cut selected text.
Ctrl + P Open the print window.
Ctrl + F Open find box.
Ctrl + I Italic highlighted selection.
Ctrl + K Insert link.
Ctrl + U Underline highlighted selection.
Ctrl + V Paste.
Ctrl + Y Redo the last action performed.
Ctrl + Z Undo last action.
Ctrl + L

Aligns the line or selected text to the left of the screen.

Ctrl + E Aligns the line or selected text to the center of the screen.
Ctrl + R Aligns the line or selected text to the right of the screen.
Ctrl + M Indent the paragraph.
Ctrl + Shift + F Change the font.
Ctrl + Shift + > Increase selected font +1pts up to 12pt and then increases font +2pts.
Ctrl + ] Increase selected font +1pts.
Ctrl + Shift + < Decrease selected font -1pts if 12pt or lower, if above 12 decreases font by +2pt.
Ctrl + [ Decrease selected font -1pts.
Ctrl + Shift + * View or hide non printing characters.
Ctrl + Moves one word to the left.
Ctrl + Moves one word to the right.
Ctrl + Moves to the beginning of the line or paragraph.
Ctrl + Moves to the end of the paragraph.
Ctrl + Del Deletes word to right of cursor.
Ctrl + Backspace Deletes word to left of cursor.
Ctrl + End Moves the cursor to the end of the document.
Ctrl + Home Moves the cursor to the beginning of the document.
Ctrl + Spacebar Reset highlighted text to the default font.
Ctrl + 1 Single-space lines.
Ctrl + 2 Double-space lines.
Ctrl + 5 1.5-line spacing.
Ctrl + Alt + 1 Changes text to heading 1.
Ctrl + Alt + 2 Changes text to heading 2.
Ctrl + Alt + 3 Changes text to heading 3.
Ctrl + F1 Open the Task Pane.
F1 Open Help.
Alt + Ctrl + F2 Open new document.
Ctrl + F2 Display the print preview.
Shift + F3 Change the text in Microsoft Word from upper to lower case or a capital letter at the beginning of every word.
Shift + Insert Paste.
F4 Repeat the last action performed (Word 2000+)
F5 Open the find, replace, and go to window in Microsoft Word.
Ctrl + Shift + F6 Opens to another open Microsoft Word document.
F7 Spell and grammar check selected text and/or document.
Shift + F7 Runs a Thesaurus check on the word highlighted.
F12 Save as.
Shift + F12 Save.
Ctrl + Shift + F12 Prints the document.
Alt + Shift + D Insert the current date.
Alt + Shift + T Insert the current time.

Wednesday, September 3, 2008

Excels Keyboard Shortcuts

Action
Menu equivalent
comments
Version
Ctrl+A
Select All
None
All
Ctrl+B
Bold
Format, Cells, Font, Font Style, Bold
All
Ctrl+C
Copy
Edit, Copy
All
Ctrl+D
Fill Down
Edit, Fill, Down
All
Ctrl+F
Find
Edit, Find
All
Ctrl+G
Goto
Edit, Goto
All
Ctrl+H
Replace
Edit, Replace
All
Ctrl+I
Italic
Format, Cells, Font, Font Style, Italic
All
Ctrl+K
Insert Hyperlink
Insert, Hyperlink
Excel 97/2000
Ctrl+N
New Workbook
File, New
All
Ctrl+O
Open
File, Open
All
Ctrl+P
Print
File, Print
All
Ctrl+R
Fill Right
Edit, Fill Right
All
Ctrl+S
Save
File, Save
All
Ctrl+U
Underline
Format, Cells, Font, Underline, Single
All
Ctrl+V
Paste
Edit, Paste
All
Ctrl W
Close
File, Close
Excel 97/2000
Ctrl+X
Cut
Edit, Cut
All
Ctrl+Y
Repeat
Edit, Repeat
All
Ctrl+Z
Undo
Edit, Undo
All
F1
Help
Help, Contents and Index
All
F2
Edit
None
All
F3
Paste Name
Insert, Name, Paste
All
F4
Repeat last action
Edit, Repeat. Works while not in Edit mode.
All
F4
While typing a formula, switch between absolute/relative refs
None
All
F5
Goto
Edit, Goto
All
F6
Next Pane
None
All
F7
Spell check
Tools, Spelling
All
F8
Extend mode
None
All
F9
Recalculate all workbooks
Tools, Options, Calculation, Calc,Now
All
F10
Activate Menubar
N/A
All
F11
New Chart
Insert, Chart
All
F12
Save As
File, Save As
All
Ctrl+:
Insert Current Time
None
All
Ctrl+;
Insert Current Date
None
All
Ctrl+"
Copy Value from Cell Above
Edit, Paste Special, Value
All
Ctrl+'
Copy Fromula from Cell Above
Edit, Copy
All
Shift
Hold down shift for additional functions in Excel's menu
none
Excel 97/2000
Shift+F1
What's This?
Help, What's This?
All
Shift+F2
Edit cell comment
Insert, Edit Comments
All
Shift+F3
Paste function into formula
Insert, Function
All
Shift+F4
Find Next
Edit, Find, Find Next
All
Shift+F5
Find
Edit, Find, Find Next
All
Shift+F6
Previous Pane
None
All
Shift+F8
Add to selection
None
All
Shift+F9
Calculate active worksheet
Calc Sheet
All
Shift+F10
Display shortcut menu
None
All
Shift+F11
New worksheet
Insert, Worksheet
All
Shift+F12
Save
File, Save
All
Ctrl+F3
Define name
Insert, Names, Define
All
Ctrl+F4
Close
File, Close
All
Ctrl+F5
XL, Restore window size
Restore
All
Ctrl+F6
Next workbook window
Window, ...
All
Shift+Ctrl+F6
Previous workbook window
Window, ...
All
Ctrl+F7
Move window
XL, Move
All
Ctrl+F8
Resize window
XL, Size
All
Ctrl+F9
Minimize workbook
XL, Minimize
All
Ctrl+F10
Maximize or restore window
XL, Maximize
All
Ctrl+F11
Inset 4.0 Macro sheet
None in Excel 97. In versions prior to 97 - Insert, Macro, 4.0 Macro
All
Ctrl+F12
File Open
File, Open
All
Alt+F1
Insert Chart
Insert, Chart...
All
Alt+F2
Save As
File, Save As
All
Alt+F4
Exit
File, Exit
All
Alt+F8
Macro dialog box
Tools, Macro, Macros in Excel 97 Tools,Macros - in earlier versions
Excel 97/2000
Alt+F11
Visual Basic Editor
Tools, Macro, Visual Basic Editor
Excel 97/2000
Ctrl+Shift+F3
Create name by using names of row and column labels
Insert, Name, Create
All
Ctrl+Shift+F6
Previous Window
Window, ...
All
Ctrl+Shift+F12
Print
File, Print
All
Alt+Shift+F1
New worksheet
Insert, Worksheet
All
Alt+Shift+F2
Save
File, Save
All
Alt+=
AutoSum
No direct equivalent
All
Ctrl+`
Toggle Value/Formula display
Tools, Options, View, Formulas
All
Ctrl+Shift+A
Insert argument names into formula
No direct equivalent
All
Alt+Down arrow
Display AutoComplete list
None
Excel 95
Alt+'
Format Style dialog box
Format, Style
All
Ctrl+Shift+~
General format
Format, Cells, Number, Category, General
All
Ctrl+Shift+!
Comma format
Format, Cells, Number, Category, Number
All
Ctrl+Shift+@
Time format
Format, Cells, Number, Category, Time
All
Ctrl+Shift+#
Date format
Format, Cells, Number, Category, Date
All
Ctrl+Shift+$
Currency format
Format, Cells, Number, Category, Currency
All
Ctrl+Shift+%
Percent format
Format, Cells, Number, Category, Percentage
All
Ctrl+Shift+^
Exponential format
Format, Cells, Number, Category,
All
Ctrl+Shift+&
Place outline border around selected cells
Format, Cells, Border
All
Ctrl+Shift+_
Remove outline border
Format, Cells, Border
All
Ctrl+Shift+*
Select current region
Edit, Goto, Special, Current Region
All
Ctrl++
Insert
Insert, (Rows, Columns, or Cells) Depends on selection
All
Ctrl+-
Delete
Delete, (Rows, Columns, or Cells) Depends on selection
All
Ctrl+1
Format cells dialog box
Format, Cells
All
Ctrl+2
Bold
Format, Cells, Font, Font Style, Bold
All
Ctrl+3
Italic
Format, Cells, Font, Font Style, Italic
All
Ctrl+4
Underline
Format, Cells, Font, Font Style, Underline
All
Ctrl+5
Strikethrough
Format, Cells, Font, Effects, Strikethrough
All
Ctrl+6
Show/Hide objects
Tools, Options, View, Objects, Show All/Hide
All
Ctrl+7
Show/Hide Standard toolbar
View, Toolbars, Stardard
All
Ctrl+8
Toggle Outline symbols
None
All
Ctrl+9
Hide rows
Format, Row, Hide
All
Ctrl+0
Hide columns
Format, Column, Hide
All
Ctrl+Shift+(
Unhide rows
Format, Row, Unhide
All
Ctrl+Shift+)
Unhide columns
Format, Column, Unhide
All
Alt or F10
Activate the menu
None
All
Ctrl+Tab
In toolbar: next toolbar
None
Excel 97/2000
Shift+Ctrl+Tab
In toolbar: previous toolbar
None
Excel 97/2000
Ctrl+Tab
In a workbook: activate next workbook
None

Followers