Subscribe For Free Updates!

We'll not spam mate! We promise.

Sunday, September 8, 2013

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)




Excel short cut keys and tips remaining from Nitin Aggarwal

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

1 comments:

  1. ABSOLUTELY MARVELLOUS REFERENCER for all.

    ReplyDelete