Thanes's profile¤«M®tê|< o3™»¤ q[><]p ev...PhotosBlogListsMore Tools Help

Blog


    March 08

    Excels Keyboard Shortcuts

    Excels Keyboard Shortcuts

    Shortcut key

    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

    Comments

    Please wait...
    Sorry, the comment you entered is too long. Please shorten it.
    You didn't enter anything. Please try again.
    Sorry, we can't add your comment right now. Please try again later.
    To add a comment, you need permission from your parent. Ask for permission
    Your parent has turned off comments.
    Sorry, we can't delete your comment right now. Please try again later.
    You've exceeded the maximum number of comments that can be left in one day. Please try again in 24 hours.
    Your account has had the ability to leave comments disabled because our systems indicate that you may be spamming other users. If you believe that your account has been disabled in error please contact Windows Live support.
    Complete the security check below to finish leaving your comment.
    The characters you type in the security check must match the characters in the picture or audio.

    To add a comment, sign in with your Windows Live ID (if you use Hotmail, Messenger, or Xbox LIVE, you have a Windows Live ID). Sign in


    Don't have a Windows Live ID? Sign up

    Trackbacks

    The trackback URL for this entry is:
    http://mrtek03.spaces.live.com/blog/cns!A62E9806B9BD7E71!451.trak
    Weblogs that reference this entry
    • None