Keyboard Shortcuts to use
with a Windows/PC Computer
You can avoid reaching for the mouse if you are
familiar with keyboard shortcuts.
If you forget one of these, use the mouse and go
to the menu bar.
In each pull down menu you will see keyboard commands
given in the right side of the window.
Commonly used keyboard
combinations
To
use one of these combinations Hold the Ctrl or Alt key down and strike the
letter key
|
Open a new workbook quickly.
|
|
Cut- Removes the selection from the active document and places
it on the clipboard.
|
|
Opens a previously saved document.
|
|
Copies the selection to the clipboard
|
|
Closes the active window, but does not Exit Excel.
|
|
Paste - Inserts the contents of the clipboard at the insertion
point (cursor) or whatever is selected.
|
|
Saves the active document with its current file name, location
and format.
|
|
Selects all on the active worksheet.
|
|
Prints the active file, also gives the opportunity to change
print options
|
|
Find - Searches for specified text in the active document
|
|
Exit - Closes Microsoft Excel.
|
|
Bold - Formats selected text; make text bold, or remove bold
formatting
|
|
Undo the last action. This selection can be repeated several
times.
|
|
Italic - Formats selected text; make text italic or remove
italic
|
|
Redo - After an action has been undone, it can be reinstated
in the document.
|
|
Underline - Formats selected text; make text underlined or
remove underline
|
MOVING AROUND THE SCREEN USING THE KEYBOARD
Use your Up, Down, Left, Right Arrows and the Home, End, Page Up and Page
Down keys to move around any application. The Tab key can also be used when
moving around a dialog box, an options window or between cells in a table or
within a database.
Move one screen up or down (Page Up) or (Page Down)
Move one screen to the right (Alt + Page Down)
Move one screen to the left (Alt + Page Up)
Move to the previous sheet in the workbook (Ctrl + Page Up)
Move to the next sheet in the workbook (Ctrl + Page Down)
Display the next window (Ctrl + F6) or (Ctrl + TAB)
Display the previous window (Ctrl + SHIFT + F6) or (Ctrl + SHIFT + TAB)
Scroll to display the active cell (Ctrl + BACKSPACE)
Turn scroll lock on or off (SCROLL LOCK)
Scroll one row up or down (UP ARROW) or (Down Arrow)
with Scroll Lock turned on
Scroll one column left or right (Left Arrow) or (Right Arrow)
with Scroll Lock turned on
How Do I Maximise The Current Window,
Without Using The Mouse?
Press
(SHIFT + ALT + SPACEBAR) then press X
Or
Press (CTRL + F10) works only in Excel
How Do I Minimise The Current Window,
Without Using The Mouse?
Press
(SHIFT + ALT + SPACEBAR) then press N
Or
Press (CTRL + F9) works only in Excel
How Do I Reduce (Not Minimise) The Current
Window, Without Using The Mouse?
Press
(SHIFT + ALT + SPACEBAR) then press R
or
Press ( ALT + ENTER + ENTER)
Or
Press (CTRL + F10) works only in Excel
How Do I Resize The Current Window, Without
Using The Mouse?
Press
(SHIFT + ALT + SPACEBAR) then press S
Move the window using two of the up/down/left/right arrows then press (ENTER)
Or
Press (CTRL + F8) works only in Excel.
Use your up/down/left/right arrows to adjust the window size. To accept your
sizing changes, press (ENTER)
How Do I Move The Current Window Or Dialog
Box, To A Different Position On The Screen, Without Using The Mouse?
Press
(SHIFT + ALT + SPACEBAR) then press M
Your mouse pointer will change to a four-headed arrow. Move the window or
dialog box using the up/down/left/right arrows then press (ENTER)
Or
Press (CTRL + F7) works only in Excel.
Your mouse pointer will change to a four-headed arrow. Move the window or
dialog box using the up/down/left/right arrows then press (ENTER)
Is there an opposite function to F2 that
would let me enter data at the beginning of a cell that would all ready have
data as opposed to the end of it?
Move
the cell you want to activate.
Press
F2
Press
HOME key
|
|
MORE EXCEL KEYBOARD SHORTCUTS
- Activate a cell and the
formula bar (F2)
- Activate and clear the
formula bar when a cell is selected, or delete the preceding character
in the formula bar (BACKSPACE)
- Activate the Auto Complete
list (Alt + Down Arrow)
- Alternate between displaying
cell values and displaying cell formulas
(Ctrl + `(single left quotation mark))
- (Alternate between hiding
objects, displaying objects, and displaying placeholders for objects
(Ctrl + 6)
- Apply or remove an underline
(Ctrl + U)
- Apply or remove bold
formatting (Ctrl + B)
- Apply or remove italic
formatting (Ctrl + I)
- Apply or remove strike
through formatting (Ctrl + 5)
- Apply the Currency format
with two decimal places (negative numbers appear in parentheses) (Ctrl +
SHIFT + $)
- Apply the Date format with
the day, month, and year (Ctrl + SHIFT + #)
- Apply the Exponential number
format with two decimal places (Ctrl + SHIFT + ^)
- Apply the General number
format (Ctrl + SHIFT + ~)
- Apply the outline border
(Ctrl + SHIFT + &)
- Apply the Percentage format
with no decimal places (Ctrl + SHIFT + %)
- Apply the Time format with
the hour and minute, and indicate A.M. or P.M. (Ctrl + SHIFT + @)
- Apply the two-decimal-place
format with commas (Ctrl + SHIFT + !)
- Calculate all sheets in all
open workbooks F9 or (Ctrl + EQUAL SIGN)
- Calculate the active sheet
(SHIFT + F9)
- Cancel a cell entry (ESC)
- Cancel an entry in the cell
or formula bar (ESC)
- Carry out the Cells command
(Format menu) (Ctrl + 1)
- Carry out the Style command
(Format menu) (Alt + ' (apostrophe))
- Clear the selection of
formulas and data (DELETE)
- Collapse the selection to the
active cell (SHIFT + BACKSPACE)
- Complete a cell entry and
move down in the selection (ENTER)
- Complete a cell entry and
move to the left in the selection (SHIFT + TAB)
- Complete a cell entry and
move to the right in the selection (TAB)
- Complete a cell entry and
move up in the selection (SHIFT + ENTER)
- Complete a cell entry (ENTER)
- Complete a cell entry (ENTER)
- Copy a formula from the cell
above the active cell into the cell or the formula bar (Ctrl + '
(apostrophe))
- Copy the selection (Ctrl + C)
- Copy the value from the cell
above the active cell into the cell or the formula bar (Ctrl + SHIFT +
")
- Create names from cell text
(Ctrl + SHIFT + F3)
- Cut the selection (Ctrl + X)
- Define a name (Ctrl + F3)
- Delete text to the end of the
line (Ctrl + DELETE)
- Delete the character to the
left of the insertion point, or delete the selection (BACKSPACE)
- Delete the character to the
right of the insertion point, or delete the selection (DELETE)
- Delete the selection (Ctrl +
MINUS SIGN)
- Display step 2 of the
Function Wizard, after you type a valid function name in a formula (Ctrl
+ A)
- Edit a cell note (SHIFT + F2)
- Enter a formula as an array
formula (Ctrl + SHIFT + ENTER)
- Enter the date (Ctrl +
SEMICOLON)
- Enter the time (Ctrl + SHIFT
+ COLON)
- Extend the selection by one
cell (SHIFT + Arrow key)
- Extend the selection down one
screen (SHIFT + Page Down)
- Extend the selection to the
beginning of the row (SHIFT + HOME)
- Extend the selection to the
beginning of the worksheet (Ctrl + SHIFT + HOME)
- Extend the selection to the
cell in the lower-right corner of the window (SHIFT + END)
- Extend the selection to the
cell in the upper-left corner of the window (SHIFT + HOME)
- Extend the selection to the edge
of the current data region (Ctrl + SHIFT + Arrow key)
- Extend the selection to the
end of the data block in the direction of the Arrow (END, SHIFT + Arrow
key)
- Extend the selection to the
last cell in the current row (unavailable if you've selected the
Transition Navigation Keys check box) (END, SHIFT + ENTER)
- Extend the selection to the
last cell in the worksheet (lower-right corner) (Ctrl + SHIFT + END)
- Extend the selection to the
last cell in the worksheet (lower-right corner) (END, SHIFT + HOME)
- Extend the selection up one
screen (SHIFT + Page Up)
- Fill down (Ctrl + D)
- Fill the selected cell range
with the current entry (Ctrl + ENTER)
- Fill to the right (Ctrl + R)
- Hide columns (Ctrl + 0
(zero))
- Hide rows (Ctrl + 9)
- Insert a line break (Alt + ENTER)
- Insert a tab character in a
cell (Ctrl + Alt + TAB)
- Insert a tab character (Ctrl
+ Alt + TAB)
- Insert blank cells (Ctrl +
SHIFT + PLUS SIGN)
- Insert the argument names and
parentheses for a function, after you type a valid function name in a
formula (Ctrl + SHIFT + A)
- Insert the AutoSum formula
(Alt + EQUAL SIGN)
- Move between unlocked cells
in a protected worksheet (TAB)
- Move by one block of data
within a row or column (END, Arrow key)
- Move clockwise to the next
corner of the selection (Ctrl + PERIOD)
- Move from bottom to top
within the selection, or move to the left one cell if only one row is
selected (SHIFT + ENTER)
- Move from left to right
within the selection (TAB)
- Move from right to left
within the selection (SHIFT + TAB)
- Move from top to bottom
within the selection, or move to the right one cell if only one row is
selected (ENTER)
- Move one cell in a given
direction (Arrow key)
- Move one screen down (Page
Down)
- Move one screen to the left
(Alt + Page Up)
- Move one screen to the right
(Alt + Page Down)
- Move one screen up (Page Up)
- Move to the beginning of the
row (HOME)
- Move to the beginning of the
worksheet (Ctrl + HOME)
- Move to the cell in the
lower-right corner of the window (END)
- Move to the cell in the
upper-left corner of the window (HOME)
- Move to the edge of the
current data region (Ctrl + Arrow key)
- Move to the last cell in the
current row (unavailable if you've selected the Transition Navigation
Keys check box) (END, ENTER)
- Move to the last cell in the
worksheet (in the lower-right corner) (Ctrl + END)
- Move to the last cell in the
worksheet (in the lower-right corner) (END, HOME)
- Move to the left between
nonadjacent selections (Ctrl + Alt + Left Arrow)
- Move to the next pane (F6)
- Move to the next sheet in the
workbook (Ctrl + Page Down)
- Move to the next workbook
(Ctrl + F6)
- Move to the previous pane
(SHIFT + F6)
- Move to the previous sheet in
the workbook (Ctrl + Page Up)
- Move to the previous workbook
(Ctrl + SHIFT + F6)
- Move to the right between
nonadjacent selections (Ctrl + Alt + Right Arrow)
- Paste a name into a formula
(F3)
- Paste the selection (Ctrl +
V)
- Remove all borders (Ctrl +
SHIFT + _ )
- Repeat the last action (F4)
- Scroll the screen left or
right one column (Left Arrow)
- Scroll the screen up or down
one row UP ARROW)
- Select a range around the
active cell (the selected range is an area enclosed by blank rows and
blank columns) (Ctrl + SHIFT + *)
- Select all cells that are
directly or indirectly referred to by formulas in the selection (Ctrl +
SHIFT + { )
- Select all cells that contain
a note (Ctrl + SHIFT + ?)
- Select all cells with
formulas that refer directly or indirectly to the active cell (Ctrl +
SHIFT + } )
- Select cells whose contents
are different from the comparison cell in each row (for each row, the
comparison cell is in the same column as the active cell ) (Ctrl + \ )
- Select cells whose contents
are different from the comparison cell in each column (for each column,
the comparison cell is in the same row as the active cell ) (Ctrl +
SHIFT + | )
- Select only cells that are
directly referred to by formulas in the selection (Ctrl + [ )
- Select only cells with
formulas that refer directly to the active cell (Ctrl + ] )
- Select only visible cells in
the current selection (Alt + SEMICOLON)
- Select the current region
(Ctrl + SHIFT + *)
- Select the entire array that
the active cell belongs to (Ctrl + /)
- Select the entire column
(Ctrl + SPACEBAR)
- Select the entire row (SHIFT
+ SPACEBAR)
- Select the entire worksheet
(Ctrl + A)
- Select the next group of
items (UP ARROW)
- Select the next item within
the group (Right Arrow)
- Select the previous group of
items (Down Arrow)
- Select the previous item
within the group (Left Arrow)
- Show or hide the Standard
toolbar (Ctrl + 7)
- Start a formula (EQUAL SIGN)
- Start a new line in the same
cell (Alt + ENTER)
- Turn End mode on or off (END)
- Turn Scroll Lock on or off
(SCROLL LOCK)
- Undo the last action (Ctrl +
Z)
- Unhide columns (Ctrl + SHIFT
+ ( (left parenthesis))
- Unhide rows (Ctrl + SHIFT + )
(right parenthesis))
|