MS Excel All Shortcut Keys
Welcome Friends,Agar aap Microsoft Office Excel use karte he toh in sabhi Shortcut keys se aap apna work fastly kar payange aur aasani se Software ko Operate kar sakte hai. Iss Post me Aapko Microsoft Office Excel ki sari Shortcut Keys batayange. Yeah Keys 17 category me devided ha:-
- General
- WorkSheet
- WorkBook
- Ribbon
- Drag and Drop
- Active Cell
- Selection
- Select Special
- Cell Edit Mode
- Entering Data
- Formatting
- Number Formatting
- Borders
- Formulas
- Raws and Column
- Pivot Tables
- Dialog Box
General
| F1 |
Open Help |
| Ctrl + Z |
Undo Last Action |
| Ctrl + Y |
Redo Last Action |
| Ctrl + C |
Copy |
| Ctrl + V |
Paste Content from Clipboard |
| Ctrl + X |
Cut |
| F4 |
Repeat Last Action |
| Ctrl + Alt + V |
Display The Paste Special Dialog Box |
| Ctrl + F |
Display Find and Replace with Find Tab Selected |
| Ctrl + H |
Display Find and Replace with Replace Tab Selected |
| Ctrl + Shift + F4 |
Find Previous Match |
| Shift + F4 |
Find Next Match |
| Alt + F1 |
Inseret Embedded Chart |
| F11 |
Insert chart in new sheet |
| Ctrl + Shift + L |
Toggle AutoFilter |
| Alt + Down Arrow |
Activate Filter |
| Ctrl + T |
Create Table |
| Shift + Space |
Select Table Row |
| Ctrl + Space |
Select table column |
| Ctrl + A |
Select table (when active cell is in table) |
| Alt + C |
Clear slicer Filter |
| F7 |
Run Spellcheck |
| Shift + F7 |
Open Thesaurus |
| Alt + F8 |
Open Macro dialog box |
| Alt + F11 |
Open VBA Editor |
| Ctrl + D |
Duplicate object |
| Alt |
Snap to grid (whilst dragging) |
| Ctrl + 6 |
Hide or show objects |
| Alt + ' |
Open Modify Cell Style dialog box |
| Shift + F10 |
Show right-click menu |
| Alt + Space |
Display control menu |
Worksheet
| Shift + F11 |
Insert new worksheet |
| Ctrl + PgDn |
Go to next worksheet |
| Ctrl + PgUp |
Go to previous worksheet |
| Alt + O , H R |
Rename current worksheet |
| Alt + E , L |
Delete current worksheet |
| Alt + E , M |
Move current worksheet |
| F6/ Shift + F6 |
Move between the worksheet, Ribbon, task pane and zoom controls in a worksheet that has been split |
| Ctrl + Shift + PgDn/PgUp |
Select adjacent worksheets |
| Ctrl + Click |
Select non-adjacent worksheets |
| SckLk |
Toggle scroll lock |
| Ctrl + Shift + F1 |
Toggle full screen |
| Ctrl + P |
Print |
| Ctrl + F2 |
Open print preview window |
| Alt + P , R S |
Set print area |
| Alt + P, R C |
Clear print area |
| Ctrl + Mouse Wheel Up |
Zoom in |
| Ctrl + Mouse Wheel Down |
Zoom out |
| Alt + R , P S |
Protect sheet |
WorkBook
| Ctrl + N |
Create new workbook |
| Ctrl + O |
Open workbook |
| Ctrl + S |
Save workbook |
| F12 |
Save as |
| Ctrl + Tab |
Go to next workbook |
| Ctrl + Shift + Tab |
Go to previous workbook |
| Ctrl + F9 |
Minimize current workbook window |
| Ctrl + F10 |
Maximize current workbook window |
| Alt + R, P W |
Protect workbook |
| Ctrl + F4 |
Close current workbook |
| Alt + F4 |
Close Excel |
Ribbon
| Ctrl + F1 |
Expand or collapse ribbon |
| Alt |
Activate access keys |
| Arrow Keys |
Move through Ribbon tabs and groups |
| Space / Enter |
Activate or open selected control |
| Enter |
Conrm control change |
| F1 |
Get help on selected control |
Drag and Drop (After Selecting Cells)
| Drag |
Drag and cut |
| Ctrl + Drag |
Drag and copy |
| Shift + Drag |
Drag and insert |
| Ctrl + Shift + Drag |
Drag and insert copy |
| Alt + Drag |
Drag to worksheet |
| Ctrl + Drag |
Drag to duplicate worksheet |
Active Cell
| Shift + Backspace |
Select active cell (when multiple cells already selected) |
| Ctrl + Backspace |
Show the active cell on worksheet |
| Ctrl + . |
Move active cell clockwise to corners of selection |
| Enter |
Move active cell down in selection - wrap to next column |
| Shift + Enter |
Move active cell up in selection - wrap to previous column |
| Tab |
Move active cell right in a selection - wrap to next row |
| Shift + Tab |
Move active cell left in a selection - wrap to previous row |
Selection
| Shift + Space |
Select entire row |
| Ctrl + Space |
Select entire column |
| Shift + Click |
Expand selection |
| Ctrl + Click |
Add non-adjacent cells to selection |
| Ctrl + Alt + → |
Move right between non-adjacent selections |
| Ctrl + Alt + ← |
Move left between non-adjacent selections |
| Shift + F8 |
Toggle 'Add to Selection' mode |
| Esc |
Exit 'Add to Selection' mode |
Select Special
| Ctrl + G / F5 |
Display 'Go To' dialog box |
| Ctrl + Shift + O |
Select cells with comments |
| Ctrl + Shift + * |
Select current region around active cell |
| Ctrl + A |
Select current region |
| Ctrl + [ |
Select direct precedents |
| Ctrl + Shift + { |
Select all precedents |
| Ctrl + ] |
Select direct dependents |
| Ctrl + Shift + } |
Select all dependents |
| Alt + ; |
Select visible cells only |
Cell Edit Mode
| F2 |
Edit the active cell |
| Shift + F2 |
Insert or edit comment |
| Shift + F10 , M |
Delete comment |
| Esc |
Cancel editing |
| Shift + → |
Select one character right |
| Shift + ← |
Select one character left |
| Ctrl + → |
Move one word right |
| Ctrl + ← |
Move one word left |
| Ctrl + Shift + → |
Select one word right |
| Ctrl + Shift + ← |
Select one word left |
| Shift + Home |
Select to beginning of cell |
| Shift + End |
Select to end of cell |
| Ctrl + Delete |
Delete to end of line |
| Backspace |
Delete character to left of cursor |
| Delete |
Delete character to right of cursor |
| Alt + Enter |
Start a new line in the same cell |
Entering Data
| Enter |
Enter data and move down |
| Shift + Enter |
Enter data and move up |
| Tab |
Enter data and move right |
| Shift + Tab |
Enter data and move left |
| Ctrl + Enter |
Enter data and stay in same cell |
| Ctrl + ; |
Insert current date |
| Ctrl + Shift + : |
Insert current time |
| Ctrl + D |
Fill down from cell above |
| Ctrl + R |
Fill right from cell on left |
| Ctrl + ' |
Copy formula from cell above |
| Ctrl + Shift + " |
Copy value from cell above |
| Ctrl + K |
Insert hyperlink |
| Alt + ↓ |
Display AutoComplete list |
Formatting
| Ctrl + 1 |
Format cells |
| Ctrl + Shift + |
Display Format Cells with Font tab selected |
| Ctrl + B |
Apply or remove bold |
| Ctrl + I |
Apply or remove italics |
| Ctrl + U |
Apply or remove underscore |
| Ctrl + 5 |
Apply or remove strikethrough |
| Alt + H , A C |
Align center |
| Alt + H , A L |
Align left |
| Alt + H , A R |
Align right |
| Alt + H , 6 |
Indent |
| Alt + H , 5 |
Remove indent |
| Alt + H , W |
Wrap text |
| Alt + H , A T |
Align top |
| Alt + H , A M |
Align middle |
| Alt + H , A B |
Align bottom |
| Alt + H , F G |
Increase font size one step |
| Alt + H , F K |
Decrease font size one step |
Number Formatting
| Ctrl + Shift + ~ |
Apply general format |
| Ctrl + Shift + ! |
Apply number format |
| Ctrl + Shift + @ |
Apply time format |
| Ctrl + Shift + # |
Apply date format |
| Ctrl + Shift + $ |
Apply currency format |
| Ctrl + Shift + % |
Apply percentage format |
| Ctrl + Shift + ^ |
Apply scientic format |
Borders
| Alt + H , B |
Open list of border styles from Ribbon |
| Ctrl + Shift + & |
Add border around selected cells |
| Alt + H , B R |
Add or remove right border |
| Alt + H , B L |
Add or remove left border |
| Alt + H , B P |
Add or remove top border |
| Alt + H , B O |
Add or remove bottom border |
| Alt + H , B A |
Add all borders to all cells in selection |
| Ctrl + Shift + - |
Remove borders |
Formulas
| = OR + |
Begin entering a formula |
| F4 |
Toggle absolute and relative references |
| Shift + F3 |
Open the Insert Function Dialog Box |
| Alt + = |
Autosum |
| Ctrl + ` |
Toggle displaying formulas on and o |
| Ctrl + Shift + A |
Insert function arguments |
| Ctrl + Shift + Enter |
Enter array formula |
| F9 |
Calculate worksheets |
| Shift + F9 |
Calculate active worksheet |
| Ctrl + Alt + F9 |
Force calculate all worksheets |
| F9 |
Evaluate part of a formula (in cell edit mode) |
| Ctrl + Shift + U |
Expand or collapse the formula bar |
| Ctrl + A |
Display function arguments dialog box |
| Ctrl + F3 |
Open Name Manager |
| Ctrl + Shift + F3 |
Create name from values in row(s)/column(s) |
| F3 |
Paste name into formula |
| Tab |
Accept function with auto-complete |
Rows and Columns
| Ctrl + + |
Display Insert Dialog box |
| Ctrl + - |
Display Delete dialog box |
| Delete |
Delete contents of selected cells |
| Ctrl + 0 |
Hide columns |
| Ctrl + 9 |
Hide rows |
| Ctrl + Shift + 9 |
Unhide rows |
| Alt + Shift + → |
Group rows or columns |
| Alt + Shift + ← |
Ungroup rows or columns |
| Ctrl + 8 |
Hide or show outline symbols |
Pivot Tables
| Alt + N , V |
Create pivot table |
| Ctrl + A |
Select entire pivot table |
| Alt + Shift + → |
Group pivot table items |
| Alt + Shift + ← |
Ungroup pivot table items |
| Ctrl + - |
Hide (lter out) pivot table item |
| Alt + H , S C |
Unhide (clear lter on) pivot table item |
| Alt + N , S Z C |
Insert pivot chart |
Dialog Boxes
| Tab |
Move to next control |
| Shift + Tab |
Move to previous control |
| Ctrl + Tab |
Move to next tab |
| Ctrl + Shift + Tab |
Move to previous tab |
| Enter |
Accept and apply |
| Space |
Check and uncheck box |
| Esc |
Cancel and close the dialog box |
Other Posts:-
Post a Comment
Post a Comment