Dosto aj hum ap logo ko Microsoft Excel ke Shortcut Key ki jankari de rahe hai , jis se ap logo ko office ka kam karne me aasani hogi, wese to Exel ke bahut sare shortcut key hai par hum apko sirf wo hi shortcut key ke bare me batayege jo apko daily office me kam karte time use hongi, agr ap bhi apni daily life me Excel ka use krte ho to apko shortcut ki ka pata hona bahut jaruri hai, jis se ap ka kam jaldi ar easy ho jaye. agar ap bhi mouse ka jyada use krte hai Excel worksheet banate time to aj se niche di gai shortcut key ka use kro ar apne kam easy bna skte ho ar sath hi sath time ki bhi saving kr skte ho.
Excel shortcut Key :
1 | Ctrl +A | Select all the content of work book. |
2 | Ctrl +B | Bold. |
3 | Ctrl +C | Copy. |
4 | Ctrl +D | Duplicate or fill down. |
5 | Ctrl +0 | Hide the selected column. |
6 | Ctrl +F | Find. |
7 | Ctrl +G | Go to specified cell. |
8 | Ctrl +H | Replace. |
9 | Ctrl +I | Italic. |
10 | Ctrl +5 | Apply or remove stikethrough. |
11 | Ctrl +K | Hyperlink. |
12 | Ctrl +L /T | Creat tabel. |
13 | Ctrl +1 | Open the formate cells dialog box. |
14 | Ctrl +N | New work sheet. |
15 | Ctrl +O | Open the saved work book. |
16 | Ctrl +P | Print. |
17 | Shift +F11 | Insert the new woeksheet. |
18 | Ctrl +R | Fill right. |
19 | Ctrl +S | Save the open worksheet. |
20 | Shift +F9 | Caluculate active worksheet. |
21 | Ctrl +U | Underline. |
22 | Shift +F3 | Insert a function. |
23 | Ctrl+W | Close the current workbook. |
24 | Ctrl +X | Cut. |
25 | Ctrl +Y | Redo. |
26 | Ctrl +Z | Undone. |
27 | Ctrl +F1 | Hide /Ribben. |
28 | Ctrl +F2 | Print. |
29 | Ctrl +F3 | Open excel name mnaager. |
30 | Ctrl +F4 | Close the current workbook. |
31 | Shift +Tab | go to the previous cell. |
32 | Ctrl +F6 | Switch into one workbook to another. |
33 | Shift+Left/Right arrow | Extend the cell selection to the left or right. |
34 | Shift +Space | Select the entire column. |
35 | Ctrl +F9 | Minimize workbook. |
36 | Ctrl +F10 | Maximize workbook. |
37 | Ctrl +Arrow key | move next section of the text. |
38 | Ctrl +Page Up | move between work sheets in the same document. |
39 | Ctrl +Page Down | move between work sheets in the same document. |
40 | Ctrl +Tab | move between two or more open excel file . |
41 | Ctrl +shift +1 | Format number in comma format. |
42 | Ctr l +shift +2 | Format number in time format. |
43 | Ctrl +shift +3 | Format number in date format. |
44 | Ctrl +shift +4 | Format number in currency format. |
45 | Ctrl +shift +5 | Format number in percentage format. |
46 | Ctrl +shift +6 | Format number in scientific format. |
47 | Ctrl+Arrow key | move the next section of text. |
48 | Ctrl +space | select the entire column. |
49 | Ctrl + – | delete the selected column or row. |
50 | Ctrl +shift += | insert the selected column or row. |
51 | Ctrl +Home | move to cell A1. |
52 | Ctrl +~ | switch between showing excel formulas or their values in the cells. |
53 | Ctrl +shift +; | enter the current time. |
54 | Ctrl +; | enter the current date. |
55 | Ctrl +F3 | open exel name manager |
56 | Ctrl +F6 | switch between open workbooks or windows. |
57 | Ctrl +F9 | minimize current window. |
58 | Ctrl +F10 | minimize currently selected window. |
59 | Alt +Shift +F1 | insert new worksheet. |
60 | Alt +Enter | while type text in cell, pressing Alt+Enter will move to next line . Allowing for multiple lines of text in one cell. |
61 | Alt + = | create the formula to sum all of the above cells. |
62 | Alt +F | open the file tab menu |
63 | Alt +H | go to the home tab |
64 | Alt +N | open the insert tab |
65 | Alt +P | go to the page layout tab |
66 | Alt +M | go to the formulas tab |
67 | Alt +A | go to tha data tab |
68 | Alt +R | go to the review tab |
69 | Alt +W | go to the view tab |
70 | Alt +X | go to the add-ins tab |
71 | Alt +Y | go to the help tab |
72 | Alt +F8 | creat,run,edit,or detele a macro |
73 | Alt +F11 | open the microsoft visual basic for application editor |
74 | Alt +page up / down | move to the previous or next worksheet. |
75 | Alt +H +D +C | delete column. |
76 | Alt +H +H | select or fill colour. |
75 | Alt +H +B | add a border. |
76 | F12 | Open the save as dialog box. |
77 | F1 | Ope n the help pane. |
78 | F7 | Check spelling. |
79 | F9 | Calculate all worksheets in alll open workbooks. |
80 | F11 | Create a bar chart based selected data { on a separate sheet }. |
81 | Ctrl +Shift +& | Apply outline border. |
82 | Ctrl +Shift +_ | {Underline} remove outline border . |
83 | Ctrl +Shift +$ | Apply currency formate . |
Facebook page kaise bnaye aur kaise delete kare || Facebook page me like kaise bdhaye :