|
|||||||
|
|
Using![]() ![]() ![]() ![]() ![]() ![]()
![]() ![]() ![]() ![]() ![]() ![]() ![]()
![]() ![]() ![]()
WILL Save You Time!
|
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 |
| 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 |
| 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
![]() ![]() |
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 |
We all know that the
key displays the taskbar and Start menu. here's what else this mysterious key can do :
Starts Windows Explorer
Finds files or folders
Finds a computer
Minimizes all windows
Undoes Minimize All Windows
Displays the Run dialog box
Cycles through the taskbar buttons (Enter activates the selected window)
Displays the System Properties sheet
Tip! Hold down the key and press the key to get back to top of this page |
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!
and search for: key stroke shortcuts
Tip! Hold down the key and press the key to get back to top of this page |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |