Sunday, February 16, 2020
Monday, February 10, 2020
MS EXCEL SHORTCUT KEYS
MS EXCEL SHORTCUT KEYS
| ||
1.
|
Quick sum
|
Alt+=
|
2.
|
Today date
|
Ctrl+;
|
3.
|
Today time
|
Ctrl+Shift+;
|
4.
|
Save as
|
F12
|
5.
|
For paste
|
Ctrl+D
|
6.
|
Selecting row
|
Shift+Spacebar
|
7.
|
Insert row
|
Shift+Spacebar then, Ctrl+(+)
|
8.
|
Delete row
|
Shift+Spacebar then, Ctrl+(-)
|
9.
|
Selecting column
|
Ctrl+Spacebar
|
10.
|
Insert column
|
Ctrl+Spacebar then, Ctrl+(+)
|
11.
|
Delete column
|
Ctrl+Spacebar then, Ctrl+(+)
|
12.
|
Quick print
|
Ctrl+P
|
13.
|
For edit cell
|
F2
|
14.
|
For start new line in same cell
|
Alt+Enter
|
15.
|
For go to next sheet
|
Ctrl+Pagedown
|
16.
|
For go to previous sheet
|
Ctrl+Pageup
|
17.
|
For Chart
|
F11
|
18.
|
Freeze multiple and row column
|
Alt-W-F-F
|
19.
|
For Filter
|
Ctrl+Shift+1
|
20.
|
Data Selection
|
Ctrl+Shift+left-right, up-down (arrow keys)
|
21.
|
Create a new workbook
|
Ctrl+N
|
22.
|
Open an existing workbook
|
Ctrl+O
|
23.
|
Save a workbook
|
Ctrl+S
|
24.
|
Open the save as dialog box
|
F12
|
25.
|
Close a workbook
|
Ctrl+W
|
26.
|
Close Excel
|
Ctrl+F4
|
27.
|
Repeat the last command or action
|
F4
|
28.
|
Insert a new worksheet
|
Shift+F11
|
29.
|
Undo an action
|
Ctrl+Z
|
30.
|
Redo an action
|
Ctrl+Y
|
31.
|
Switch to Print Preview
|
Ctrl+F2
|
32.
|
Open the help pane
|
F1
|
33.
|
Go to the “Tell me what you want to do” box
|
Alt+Q
|
34.
|
Check spelling
|
F7
|
35.
|
Calculate all worksheets in all open workbooks
|
F9
|
36.
|
Calculate active worksheets
|
Shift+F9
|
37.
|
Turn key tips on or off
|
Alt or F10
|
38.
|
Show or hide the ribbon
|
Ctrl+F1
|
39.
|
Expand or collapse the formula bar
|
Ctrl+Shift+U
|
40.
|
Minimize the workbook window
|
Ctrl+F9
|
41.
|
Create a bar chart based on selected data(on a seprate sheet)
|
F11
|
42.
|
Create an embedded bar chart based on select data(same sheet)
|
Alt+F1
|
43.
|
Search in a spreadsheet, or use Find and Replace
|
Ctrl+F
|
44.
|
Open the file tab menu
|
Alt+F
|
45.
|
Go to the home tab
|
Alt+H
|
46.
|
Open the Insert tab
|
Alt+N
|
47.
|
Go to the pagelayout tab
|
Alt+P
|
48.
|
Go to the formula tab
|
Alt+M
|
49.
|
Go to the data tab
|
Alt+A
|
50.
|
Go to the review tab
|
Alt+R
|
51.
|
Go to the view tab
|
Alt+W
|
52.
|
Go to the Add-ins tab
|
Alt+X
|
53.
|
Go to the help tab
|
Alt+Y
|
54.
|
Switch between open workbooks
|
Ctrl+Tab
|
55.
|
Insert a function
|
Shift+F3
|
56.
|
Create, run, edit, or delete a macro
|
Alt+F8
|
57.
|
Open the Microsoft visual basic for applications editior
|
Alt+F11
|
58.
|
Left/Right Arrow
|
Move one cell to the left or right
|
59.
|
Ctrl+Left/Right Arrow
|
Move to the farthest cell left or right in the row
|
60.
|
Up/Down Arrow
|
Move one cell up or down
|
61.
|
Ctrl+Up/Down Arrow
|
Move to the top or bottom cell in the column
|
62.
|
Go to the next cell
|
Tab
|
63.
|
Go to the previous cell
|
Shift+Tab
|
64.
|
Go to the most bottom right used cell
|
Ctrl+End
|
65.
|
Go to any cell
|
F5
|
66.
|
Go to the leftmost cell in the current row
|
Home
|
67.
|
Move to the beginning of a worksheet
|
Ctrl+Home
|
68.
|
Move one screen up or down in a worksheet
|
Page Up/Down
|
69.
|
Move one screen to the right or left in a worksheet
|
Alt+Page Up/Down
|
70.
|
Move to the previous or next worksheet
|
Ctrl+Page Up/Down
|
71.
|
Extend the cell selection to the left or right
|
Shift+Left/Right Arrow
|
72.
|
Select the entire row
|
Shift+Space
|
73.
|
Select the entire column
|
Ctrl+Space
|
74.
|
Select the entire worksheet
|
Ctrl+Shift+Space
|
75.
|
Edit a cell
|
F2
|
76.
|
Add or edit a cell comment
|
Shift+F2
|
77.
|
Cut contents of a cell, selected data, or selected cell range
|
Ctrl+X
|
78.
|
Copy contents of a cell, selected data, or selected cell range
|
Ctrl+C or Ctrl+Insert
|
79.
|
Paste contents of a cell, selected data or selected cell range
|
Ctrl+V or Shift+Insert
|
80.
|
Open the paste special dialog box
|
Ctrl+Alt+V
|
81.
|
Remove the contents of a cell, selected data, or selected cell range
|
Delete
|
82.
|
Alt+Enter
| |
83.
|
Paste a cell name
|
F3
|
84.
|
Delete column
|
Alt+H+D+C
|
85.
|
Cancel an entry in a cell or the formula bar
|
Esc
|
86.
|
Complete an entry in a cell or the formula bar
|
Enter
|
87.
|
Bold
|
Ctrl+B
|
88.
|
Italic
|
Ctrl+I
|
89.
|
Underline
|
Ctrl+U
|
90.
|
Select a fill color
|
Alt+H+H
|
91.
|
Add a border
|
Alt+H+B
|
92.
|
Apply outline border
|
Ctrl+Shift+&
|
93.
|
Remove outline border
|
Ctrl+Shift+_
|
94.
|
Hide the selected rows
|
Ctrl+9
|
95.
|
Hide the selected columns
|
Ctrl+0
|
96.
|
Open the format cells dialog box
|
Ctrl+1
|
97.
|
Apply or remove strikethrough
|
Ctrl+5
|
98.
|
Apply currency format
|
Ctrl+Shift+$
|
99.
|
Apply percent format
|
Ctrl+Shift+%
|
100.
|
Table
|
Ctrl+T
|
102.
|
Insert Function
|
Shift+F3
|
103.
|
Name Manager
|
Ctrl+F3
|
104.
|
Create from selection
|
Ctrl+Shift+F3
|
105.
|
Show Formulas
|
Ctrl+’
|
106.
|
Calculate Now
|
F9
|
107.
|
Calculate Sheet
|
Shift+F9
|
108.
|
Refresh All
|
Ctrl+Alt+F5
|
109.
|
Filter
|
Ctrl+Shift+L
|
110.
|
Reapply
|
Ctrl+Alt+L
|
111.
|
Flash Fill
|
Ctrl+E
|
112.
|
Group
|
Shift+Alt+Right
|
113.
|
Ungroup
|
Shift+Alt+Left
|
114.
|
Spelling
|
F7
|
115.
|
Research
|
Alt+Click
|
116.
|
New Comment
|
Shift+F2
|
117.
|
View Macro
|
Alt+F8
|
Microsoft Excel Exam Paper and and Solution
Microsoft Excel Shortcut Keys
Microsoft Word Exam Paper Solution
Microsoft Word Shortcut Keys
Computer Basics, Notepad, WordPad and Paint mcq Questions and Answers
Computer Basics and Notepad mcq Questions and Answers
Computer Basics and Notepad mcq Questions and Answers in Hindi and English
Notepad and Computer Basic Mcq Questions and Ansewers in Hindi and English
कंप्यूटर का परिचय हिंदी में (Introduction of Computer in Hindi)
कंप्यूटर को चलाते कैसे हैं ?
कंप्यूटर या लैपटॉप में स्क्रीनशॉट कैसे लेते हैं ?
Subscribe to:
Comments (Atom)
basic spoken english
अंग्रेजी बोलचाल सीखने के लिए अंग्रेजी में अभिवादन का होना आवश्यक है | हम दिन के समय या किसी अन्य सम...
-
Mailings, Review and View Tab in Word in Hindi Create इस group द्वारा हम अपने डॉक्यूमेंट में Envelopes और Lables बना सकते हैं | जै... -
Microsoft Paint is a simple graphics editor that has been included with all versions of Microsoft Windows. The program opens and ... -
Table Layout All Options in Word in Hindi Select : इससे हम current cell , row, column और पुरे table को सेलेक्ट कर सकते हैं | इसके...