• Breaking News

    Loading...

    Aug 27, 2016

    Excel short cut and keys

    Microsoft excel became necessity now a days as it has a lot features that makes calculations very fast and easy. Also keeping the data as well as sending as attachments is quite simple. But excel has a lot of features that can make work quite simple and fast. These features and short cuts are not known by everybody. In this post taxalertindia.com tries to tell almost all the shortcuts for excel  that will make your work fast and easy. Here you can check these shortcuts.


    Edit Data
    Keyboard Shortcut
    Action
    Ctrl + N
    Open new workbook
    Ctrl + O
    Open existing workbook
    Ctrl + W
    Close active workbook
    Ctrl + S
    Save active workbook
    F12
    Save As … different name, location, file type
    Alt + F4
    Close Excel
    F1
    Open help menu
    Keyboard Shortcut
    Action
    Ctrl + Z
    Undo last action
    Ctrl + Y
    Restore undo action
    F4
    Repeat last action
    Keyboard Shortcut
    Action
    Ctrl + C                                                                   Copy selection to clipboard
    Ctrl + X                                                                   Cut selection to clipboard
    Ctrl + V                                                                   Paste last selection that was cut or copied to clipboard
    Delete                                                                    Clear contents of current selection (leave formatting in place)
    Ctrl + - (minus)                                                      Open Delete Cells dialog box
    Ctrl + + (plus)                                                        Open Insert Cells dialog box
    Ctrl + ' (apostrophe)                                            Copy contents of cell above into active cell; formulas are an exact copy
    Ctrl + R                                                                   Copy contents of cell to the left into active cell; formulas are an exact copy
    Shift + F10                                                             Open shortcut - contextual menu;
    use up & down arrow key + enter to make selection
    Keyboard Shortcut
    Action
    F2                                                                            Begin editing active cell; insertion point is at end of cell contents
    Home                                                                     While in edit mode, move insertion point to beginning of cell contents
    End                                                                         While in edit mode, move insertion point to end of cell contents
    Ctrl + à              While in edit mode, move insertion point one word to the right
    Ctrl + ß              While in edit mode, move insertion point one word to the left
    Backspace                                                             While in edit mode, delete character to left of insertion point
    Delete                                                                    While in edit mode, delete character to right of insertion point
    Ctrl + Delete                                                          While in edit mode,
    delete all characters from insertion point to end of cell contents
    ' (apostrophe)                                                       As 1st character in cell, format entry as "text"
    F7                                                                            Begin Spell Check


    Favourite & Wanted Keyboard Shortcuts for Excel®
    Show / Hide Columns and Rows
    Keyboard Shortcut
    Action
    Ctrl + 0 (zero)
    Hide current column
    Ctrl + 9
    Hide current row
    Ctrl + Shift + 9
    Unhide current row
    Ctrl + Shift + (
    Unhide rows within selection
    Ctrl + Shift + )
    Unhide columns within selection
    Select Contiguous Cells
    Keyboard Shortcut
    Action
    Shift + Directional Arrow                                    Select the cell(s) in that direction (left, right, up, or down)
    Ctrl + Shift + Directional Arrow                         Select to the last occupied cell in that direction (left, right, up, or down)
    Ctrl + Shift + End                                                  Select from active cell to last occupied cell that is down and to the right
    Ctrl + Shift + Home                                              Select from active cell to first occupied cell that is up and to the left
    Shift + Backspace                                                 Collapse cell selection to just active cell
    Ctrl + A                                                                   Select all of the occupied cells in current range; press again to select all cells in worksheet
    Ctrl + Space Bar                                                    Select all cells in current column
    Shift + Space Bar                                                  Select all cells in current row
    Ctrl + Shift + + (plus  sign)                                   Insert new row - select row first
    Ctrl + - (hyphen)                                                   Delete selected row - select row first
    F8                                                                            Turn on extend-selection mode;
    use directional arrows; F8 or Esc to exit extend-selection mode
    Navigate Within a Worksheet
    Keyboard Shortcut
    Action
    Tab or à              Move one cell to right
    Shift + Tab or ß           Move one cell to left
    á                 Move one cell up
    â                 Move once cell down
    Ctrl + à              Move to last occupied cell in row of data block
    Ctrl + ß              Move to first occupied cell in row of data block
    Ctrl + â              Move to last occupied cell in column of data block
    Ctrl + á              Move to first occupied cell in column of data block
    Ctrl + End                                                               Move to last (bottom) occupied cell of data block
    Ctrl + Home                                                           Move to cell A1
    Ctrl + . (Period)                                                     Move clockwise to next corner of selected range
    Navigate Between Workbooks
    Keyboard Shortcut
    Action
    Ctrl + Page Down
    Move to and activate next worksheet in workbook
    Ctrl + Page Up
    Move to and activate previous worksheet in workbook
    Shift + F11
    Insert new worksheet to left of active worksheet

    Favourite & Wanted Keyboard Shortcuts for Excel®
    Find, Replace, and Go To
    Enter Data
    Keyboard Shortcut
    Action
    Ctrl + F
    Open Find dialog box
    Ctrl + H
    Open Replace dialog box
    Ctrl + G or F5
    Open Go To dialog box
    Keyboard Shortcut
    Action
    Ctrl + ; (semi-colon)                                             Enter current date
    Ctrl + Shift + : (colon)                                          Enter current time
    Enter                                                                       Accept entry and move active cell down one row
    Ctrl + Enter                                                            Accept entry and keep active cell in place
    Shift + Enter                                                          Accept entry and move active cell up one row
    Tab                                                                          Accept entry and move active cell one column to right
    Shift + Tab                                                             Accept entry and move active cell one column to left
    Alt + Enter                                                             Create line break in the same cell; this is a "text wrap"
    Esc                                                                          Cancel cell entry
    Work with Cell Comments
    Work with Names for Cells and Ranges
    Keyboard Shortcut
    Action
    Shift + F2
    Add new comment; edit cell comment
    Ctrl + Shift + O
    Select all cells with comments
    Keyboard Shortcut
    Action
    Ctrl + Shift + F3
    Open Create Names from Selection dialog box; select cells and labels first
    F3
    Open Paste Name dialog box
    Ctrl + F3
    Define name; open Name Manager dialog box (Excel 2007)
    Work with Formulas and Functions
    Keyboard Shortcut
    Action
    Shift + F3                                                               Open Insert Function dialog box
    Ctrl + A                                                                   Open Function Argument dialog box
    - when insertion point is to right of function name and (
    Ctrl + Shift + A                                                       Insert parenthesis () and function argument names
    - when insertion point is to right of function name - e.g. =sum
    F2                                                                            Edit formula in cell; insertion point is at end of cell contents
    F3                                                                            Open Paste Name dialog box
    Alt + =                                                                     Insert AutoSum formula
    Highlight Portion of Formula + F9                     Evaluates selected portion of formula; press Esc to return to editing
    Ctrl + ` (single left quotation mark)                  Toggle between showing formula and formula result
    Highlight Portion of Formula + F4                     Cycle between absolute, mixed and relative references for highlighted cells

    Favourite & Wanted Keyboard Shortcuts for Excel®
    Work with Formula Precedent and Dependent Cells
    Keyboard Shortcut
    Action
    Ctrl + [ (open bracket)
    Select direct precedent cells
    Shift + Ctrl + [ (open bracket)
    Select all precedent cells
    Ctrl + ] close bracket)
    Select direct dependent cells
    Shift + Ctrl + ] close bracket)
    Select all dependent cells
    Shift + Ctrl + { (open brace)
    Select all cells directly or indirectly referenced by formulas in selection
    Shift + Ctrl + } close brace)
    Select cells with formulas that directly or indirectly reference active cell
    Print Worksheet
    Keyboard Shortcut
    Action
    Ctrl + P
    Open Print dialog box
    Ctrl + F2
    Open Print Preview mode
    Formatting Cells and Text
    Work with Subtotals and Outlines
    Work with Tables, Lists, and Filters
    Keyboard Shortcut
    Action
    Ctrl + 1                                                                   Open Format Cells dialog box; use the 1 key on the keyboard, not on keypad
    Alt + ' (apostrophe)                                             Open Style dialog box
    Ctrl + B                                                                   Toggle bold formatting
    Ctrl + I                                                                     Toggle italic formatting
    Ctrl + U                                                                   Toggle underline formatting
    Ctrl + Shift + & (ampersand)                              Apply outline border to selected cells
    Ctrl + Shift + _ (underscore)                               Remove outline border from selected cells
    Ctrl + Shift + ~ (tilde)                                           Apply general number format
    Ctrl + Shift + $                                                       Apply currency format with two decimal places
    Ctrl + Shift + %                                                      Apply percentage format with zero decimal places
    Ctrl + Shift + # (pound or hash symbol)           Apply day, month, year date format
    Ctrl + Shift + @                                                     Apply hour, minute AM/PM time format
    Ctrl + Shift + ! (exclamation)                              Apply number format with thousands separator & two decimal places
    Ctrl + K                                                                   Insert a hyperlink to selected text
    Keyboard Shortcut
    Action
    Ctrl + 8
    Toggle outline symbol display
    Alt + ;
    Select visible cells only (useful when copying collapsed outline levels)
    Shift + Alt +à
    Open Group selection dialog box
    Shift + Alt + ß
    Open Ungroup selection dialog box
    Keyboard Shortcut
    Action
    Ctrl + T
    Change a data range into a Table (Excel 2007)
    Ctrl + L
    Change a data range into a List (Excel 2003)
    Ctrl + Shift + L
    Toggle AutoFilters on / off for column headers of data range


    Favourite & Wanted Keyboard Shortcuts for Excel®
    Work with Charts
    Work with Excel Windows and Open Applications
    Keyboard Shortcut
    Action
    F11
    Create column chart of selected data on new worksheet
    Alt + F1
    Create column chart of selected data on current worksheet
    Directional Arrows
    Cycle to next / previous chart element to select it
    Keyboard Shortcut
    Action
    Ctrl + F9
    Minimize active workbook window to an icon
    Ctrl + F10
    Restore or maximize selected workbook window
    Ctrl + Esc
    Display Windows Start Menu
    Alt + Tab
    Switch to next open application; hold down Alt   and "tap" Tab
    Shift + Alt + Tab
    Switch to previous open application; hold down Shift + Alt and "tap" Tab
    Alt + Esc
    Switch to next open application; hold down Alt   and "tap" Esc
    Ctrl + F6
    Switch to next open workbook window (if available)
    Ctrl + Shift + F6
    Switch to previous open workbook window (if available)
    Ctrl + W or Ctrl + F4
    Close the active window (Excel remains open)




    Tags-excel shortcuts, excel shortcuts keys, shortcut keys excel,xls shortcuts keys,shortcut keys microsoft excel

    3 comments:

    Featured