GoTo Data Guru Love Resiliency Search

Using
Windows
Shortcut
Keys
WILL Save You Time!

How do I:

Move BETWEEN Applications

Toggle between running applications (e.g. Word, Excel, Access)
Hold down the Alt Key and then press the Tab Key until you see the icon representing the application you want, then release both keys.

Tip! Hold down the key and press the key to get back to top of this page


Move between worksheets within Excel

Hold down the Ctrl Key and then press the Tab Key until you see the window you want, then release both keys.

Tip! Hold down the key and press the key to get back to top of this page


Move around within a document

Jump to BEGINNING OF CURRENT LINE
Jump to END OF CURRENT LINE


Move UP a Screen
Move DOWN a Screen



Hold down the Ctrl Key and Press any of the following keys to:

Jump to TOP OF DOCUMENT
Move LEFT ONE WORD at a time
(Press the arrow key multiple times to move from word to word)
Move RIGHT ONE WORD at a time
(Press the arrow key multiple times to move from word to word)
Jump to BOTTOM OF DOCUMENT

Tip! Hold down the key and press the key to get back to top of this page


Mark Sections of Your Document

Hold down the shift key and then press any movement key combination:

Mark ONE WORD to the RIGHT of your curser
(Press the arrow key multiple times to mark multiple words)
Mark ONE WORD to the LEFT of your curser
(Press the arrow key multiple times to mark multiple words)
 
 
Mark all text between your curser and the BEGINNING OF THE CURRENT LINE
Mark all text between your curser and the END OF THE CURRENT LINE
 
 
Mark one line of text UP from your curser
(Press the arrow key multiple times to mark multiple lines)
Mark one line of text DOWN from your curser
(Press the arrow key multiple times to mark multiple lines)
 
 
Mark all text between your curser and the PREVIOUS SCREEN of text
(Press the Page Up key multiple times to mark multiple screens)
Mark all text between your curser and the NEXT SCREEN of text
(Press the Page Down key multiple times to mark multiple screens)
 
 
Mark all text between your curser and the BEGINNING OF THE DOCUMENT
Mark all text between your curser and the END OF THE DOCUMENT
 
 
Mark ENTIRE DOCUMENT

Tip! Hold down the key and press the key to get back to top of this page


Move around within a worksheet

Move UP one row
Move LEFT one cell Move RIGHT one cell
Move DOWN one row


Move UP a Screen
Move DOWN a Screen



Hold down the Ctrl Key and Press any of the following keys to:

Jump to TOP OF WORKSHEET
Jump to the BEGINNING of the row
(If there are empty cells, it will stop at the first empty cell)
Jump to the END of the row
(If there are empty cells, it will stop at the first empty cell)
Jump to BOTTOM RIGHT OF worksheet

Tip! Hold down the key and press the key to get back to top of this page


Mark Sections of Your Worksheet

Hold down the shift key and then press any movement key combination:

Mark to the END of the row if all cells are non-empty or to the first empty cell
(If they are blank cells, press the arrow key multiple times to keep extending the selection)
Mark to the END of the row if all cells are non-empty or to the first empty cell
(If they are blank cells, press the arrow key multiple times to keep extending the selection)
Mark all cells between your curser and the BEGINNING OF THE CURRENT LINE
Mark all cells between your curser and the END OF THE CURRENT LINE
 
 
Mark one cell UP from your curser
(Press the arrow key multiple times to mark multiple lines)
Mark one cell DOWN from your curser
(Press the arrow key multiple times to mark multiple lines)
 
 
Mark all cells between your curser and the PREVIOUS SCREEN up
(Press the Page Up key multiple times to mark multiple screens)
Mark all cells between your curser and the NEXT SCREEN down
(Press the Page Down key multiple times to mark multiple screens)
 
 
Mark all cells between your curser and the BEGINNING OF THE WORKSHEET
Mark all cells between your curser and the END OF THE WORKSHEET
 
 
Mark ENTIRE worksheet

Tip! Hold down the key and press the key to get back to top of this page


Delete, Cut, Copy and Paste

Cut marked text
Copy marked text
Paste marked text
Delete marked text (Undo will restore)

Tip! Hold down the key and press the key to get back to top of this page


Undo within an Application
Undo your previous action (don't you wish life was always this easy!)

Tip! Hold down the key and press the key to get back to top of this page


Navigate Pull Down Menus within an Application
Open Menus, Navigate, and Select Menu Options

  1. Press the Alt Key and the Underlined letter on the Menu name, then
  2. Use the arrow keys to navigate the menu options, then
  3. Use the Enter Key to Select the Menu Option you want.
Pull down the File Menu

Note that the Tab Key will often allow you to switch between options in a box. For example in Excel, to select Paste Special, Transpose use
Pull down the Edit Menu
Will select the "Paste Special" option on the Edit Menu
Will select and then execute the "Transposed" option in the Paste Special Window

Tip! Hold down the key and press the key to get back to top of this page


Moving Around in Windows

We all know that the windows.gif (1246 bytes) key displays the taskbar and Start menu. here's what else this mysterious key can do :


windows.gif (1246 bytes)ekey.gif (1132 bytes) Starts Windows Explorer
windows.gif (1246 bytes)fkey.gif (1099 bytes) Finds files or folders
ctrlkey.gif (1230 bytes)windows.gif (1246 bytes)fkey.gif (1099 bytes) Finds a computer
windows.gif (1246 bytes)mkey.gif (1212 bytes) Minimizes all windows
shiftkey.gif (1306 bytes)windows.gif (1246 bytes)mkey.gif (1212 bytes) Undoes Minimize All Windows
windows.gif (1246 bytes)rkey.gif (1179 bytes) Displays the Run dialog box
windows.gif (1246 bytes)tabkey.gif (1251 bytes) Cycles through the taskbar buttons (Enter activates the selected window)
windows.gif (1246 bytes)breakkey.gif (1365 bytes) Displays the System Properties sheet


Tip! Hold down the key and press the key to get back to top of this page

Frequently Used Shortcuts in Word

You're typing along and then you have to move your hand off your keyboard, grab your mouse, click drag to mark the text, then roll up to click on a formatting button, then click again to unmark the selection before being able to continue typing. Save time by using keystrokes to mark the text you want to format and then use the following keystrokes to format your text:

Bold marked text
Italicize marked text
Underline marked text
 
Justify marked text or the paragraph if nothing is marked
Left Justify marked text or the paragraph if nothing is marked
Center marked text or the paragraph if nothing is marked
Right Justify marked text or the paragraph if nothing is marked
 
Cut marked text
Copy marked text
Paste marked text
Delete marked text (Undo will restore)
 
Undo last change
Repeat Repeat last event
 
Find text, formatting, etc
Replace text, formatting, etc
 
Create New document
Open a document
Save the document
Print Preview the document
Print the document
 
Activate Office Assistant Help


Tip! Hold down the key and press the key to get back to top of this page

Frequently Used Shortcuts in Excel

You're typing along and then you have to move your hand off your keyboard, grab your mouse, click drag to mark the text, then roll up to click on a formatting button, then click again to unmark the selection before being able to continue typing. Save time by using keystrokes to mark the text you want to format and then use the following keystrokes to work with your selections:
Insert a blank row
Insert a blank column
Insert a blank worksheet
Delete a row, column or cells
 
Autofit a row or rows (Mark the row(s) first)
Autofit a column or columns (Mark the column(s) first)
 
Sort marked cells (Mark the cells to be sorted first)
Pull up the format cells window
Pull up the paste special window
 
Cut marked cells
Copy marked cells
Paste> marked cells
Delete marked cells (Undo will restore)
 
Make the cell bold
Make the cell italics
Make the cell underlined
 
Edit a cell (enter: exit cell and save changes, escape: exit cell and drop changes)
 
Undo the last change
Redo the last change
 
Find
Replace
 
Go to the next worksheet to the left
Go to the next worksheet to the right
Toggles between open spreadsheets.
 
Create a new spreadsheet
Open a spreadsheet
Save the spreadsheet
Close the spreadsheet
Print Preview
 
Help

Tip! Hold down the key and press the key to get back to top of this page

I want to find MORE Shortcuts!

  1. When you find yourself clicking on the same menu time and time again, look for Shortcut Key Stroke combinations listed on that pull down menu and use the shortcut instead!
  2. In any Microsoft Office Application, Press and search for: key stroke shortcuts

    I selected the first option "Use shortcut keys in Microsoft Excel" and now I have all sorts of info on shortcuts to pick from:

Tip! Hold down the key and press the key to get back to top of this page


GoTo Data Guru Love Resiliency Search