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
ABSOLUTELY MARVELLOUS REFERENCER for all.
ReplyDeleteReally Useful link
ReplyDeletethank you
ReplyDelete