Please Do NOT Send Attachments







Download Keyboard Shortcuts Now

KEYBOARD SHORTCUTS
AND HOT KEYS

Page 4




Tips and Tricks This document is devoted to using the keyboard instead of the mouse to perform tasks within applications. This list is by no means the "be all and end all". There are many more Keyboard Shortcuts, which can be found by looking under HELP and then under Shortcut keys or Keyboard Shortcuts, in the respective applications.

Note: Throughout this document you will see references to pressing more than one key at a time for example (Ctrl + C ) to copy text. The ( + ) characters are not meant to be used, they are simply used to infer that more than one key must be pressed at the same time.



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





Across The Board Keyboard Shortcuts
Keyboard Shortcuts in Windows95+
WORD Keyboard Shortcuts
EXCEL Keyboard Shortcuts


    Back to Top


    EXCEL KEYBOARD SHORTCUTS


    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))








Visit Kazza's Other Sites

[Kazza's Home Page] [South Australia] [Thoughts & Poems]
[Thoughts & Proverbs] [Free Keyboard Tips]
[Colours and Hexadecimal Triplets]
[Search Page] [About The WebMaster
[HTML and the Internet] [Adding Sound to your Web Page]
[A Little Bit of Austaliana] [Comic Pages]


General Disclaimer

Produced by Karen Day
kday@chariot.net.au
South Australia
Last updated: 28/01/2005
Version 1.4
Number of visitors
to this page:... Counter