Regd. Under the Companies Act. 2013 Ministry of Corporate Affairs, Govt. of India
BRAINTECH TECHNICAL TRAINING INSTITUTE
BRAINTECH EDUCATION FOUNDATION (NGO)
BRAINTECH COMPUTER EDUCATION
Director:- Kamlesh Sir
Mob-8405806341, 7352515701
Website:- www.btti.org.in www.braintech.org.in
Address:-In front of middle School, Basantpur, Siwan, Bihar 841406
Shortcuts key of ms-Excel
1.
|
Ctrl+A
|
Select all contents of a
worksheet.
|
2.
|
Ctrl+B
|
Bold all cells in the
highlighted section.
|
3.
|
Ctrl+D
|
Fill Content of the selected cell on top to bottom. CTRL + D
(i.e. Ctrl+ Down)
|
4.
|
Ctrl+F
|
Search current sheet.
|
5.
|
Ctrl+G
|
Go to a certain area.
|
6.
|
Ctrl+H
|
|
7.
|
Ctrl+I
|
Puts italics on all cells in the highlighted section.
|
8.
|
Ctrl+K
|
|
9.
|
Ctrl+P
|
Print the current sheet.
|
10.
|
Ctrl+R
|
Fill Right.
|
11.
|
Ctrl+S
|
Saves the open worksheet.
|
12.
|
Ctrl+U
|
Underlines all cells in the
highlighted section.
|
13.
|
Ctrl+V
|
Pastes everything copied onto the clipboard.
|
14.
|
Ctrl+W
|
Closes the current workbook.
|
15.
|
Ctrl+X
|
Cuts all cells within the highlighted section.
|
16.
|
Ctrl+Y
|
Repeats the last entry.
|
17.
|
Ctrl+Z
|
|
18.
|
Ctrl+1
|
Changes the format of the
selected cells.
|
19.
|
Ctrl+2
|
Bolds all cells in the highlighted section.
|
20.
|
Ctrl+3
|
Puts italics all cells in the
highlighted section.
|
21.
|
Ctrl+4
|
Underlines all cells in highlighted section.
|
22.
|
Ctrl+5
|
|
23.
|
Ctrl+6
|
|
24.
|
Ctrl+7
|
Shows or hides
the toolbar.
|
25.
|
Ctrl+8
|
Toggles the outline symbols.
|
26.
|
Ctrl+9
|
Hides rows.
|
27.
|
Ctrl+0
|
Hides columns.
|
28.
|
Ctrl+Shift+:
|
|
29.
|
Ctrl+;
|
Enters the current date.
|
30.
|
Ctrl+`
|
Changes between displaying
cell values or formulas in the worksheet.
|
31.
|
Ctrl+’
|
|
32.
|
Ctrl+Shift+”
|
Copies value from cell above.
|
33.
|
Ctrl+-
|
Deletes the selected column or row.
|
34.
|
Ctrl+Shift+=
|
Inserts a new column or row.
|
35.
|
Ctrl+Shift+~
|
Switches between showing Excel formulas or their values in
cells.
|
36.
|
Ctrl+Shift+@
|
Applies time formatting.
|
37.
|
Ctrl+Shift+!
|
Applies comma formatting.
|
38.
|
Ctrl+Shift+$
|
Applies currency formatting.
|
39.
|
Ctrl+Shift+#
|
Applies date formatting.
|
40.
|
Ctrl+Shift+%
|
Applies percentage
formatting.
|
41.
|
Ctrl+Shift+^
|
Applies exponential formatting.
|
42.
|
Ctrl+Shift+*
|
Selects the current region
around the active cell.
|
43.
|
Ctrl+Shift+&
|
Places border around selected cells.
|
44.
|
Ctrl+Shift+_
|
Removes a border.
|
45.
|
Ctrl++
|
Insert.
|
46.
|
Ctrl+-
|
Delete.
|
47.
|
Ctrl+Shift+(
|
Unhide rows.
|
48.
|
Ctrl+Shift+)
|
Unhide columns.
|
49.
|
Ctrl+/
|
Selects the array containing the active cell.
|
50.
|
Ctrl+\
|
Selects the cells that have a
static value or don’t match the formula in the active cell.
|
51.
|
Ctrl+[
|
Selects all cells referenced by formulas in the highlighted
section.
|
52.
|
Ctrl+]
|
Selects cells that contain
formulas that reference the active cell.
|
53.
|
Ctrl+Shift+{
|
Selects all cells directly or indirectly referenced by formulas
in the highlighted section.
|
54.
|
Ctrl+Shift+}
|
Selects cells which contain
formulas that directly or indirectly reference the active cell.
|
55.
|
Ctrl+Shift+| (pipe)
|
Selects the cells within a column that don’t match the formula
or static value in the active cell.
|
56.
|
Ctrl+Enter
|
Fills the selected cells with
the current entry.
|
57.
|
Ctrl+Spacebar
|
Selects the entire column.
|
58.
|
Ctrl+Shift+Spacebar
|
Selects the entire worksheet.
|
59.
|
Ctrl+Home
|
Move to cell A1.
|
60.
|
Ctrl+End
|
Move to last cell on
worksheet.
|
61.
|
Ctrl+Tab
|
Move between Two or more open Excel files.
|
62.
|
Ctrl+Shift+Tab
|
Activates the previous
workbook.
|
63.
|
Ctrl+Shift+A
|
Inserts argument names into a formula.
|
64.
|
Ctrl+Shift+F
|
Opens the drop-down
menu for fonts.
|
65.
|
Ctrl+Shift+O
|
Selects all of the cells that contain comments.
|
66.
|
Ctrl+Shift+P
|
|
67.
|
Shift+Insert
|
Pastes what is stored on the clipboard.
|
68.
|
Shift+Page Up
|
In a single column,
highlights all cells above that which are selected.
|
69.
|
Shift+Page Down
|
In a single column, highlights all cells above that which are
selected.
|
70.
|
Shift+Home
|
Highlights all text to the
left of the cursor.
|
71.
|
Shift+End
|
Highlights all text to the right of the cursor.
|
72.
|
Shift+Up Arrow
|
Extends the highlighted area
up one cell.
|
73.
|
Shift+Down Arrow
|
Extends the highlighted area down one cell.
|
74.
|
Shift+Left Arrow
|
Extends the highlighted area
left one character.
|
75.
|
Shift +Right Arrow
|
Extends the highlighted area right one character.
|
76.
|
Alt+Tab
|
Cycles through applications.
|
77.
|
Alt+Spacebar
|
Opens the system menu.
|
78.
|
Alt+Backpspace
|
Undo.
|
79.
|
Alt+Enter
|
While typing text in a cell, pressing Alt+Enter will move to the
next line, allowing for multiple lines of text in one cell.
|
80.
|
Alt+=
|
Creates a formula to sum all
of the above cells.
|
81.
|
Alt+’
|
Allows formatting on a dialog box.
|
82.
|
F1
|
Opens the Help menu.
|
83.
|
F2
|
Edits the selected cell.
|
84.
|
F3
|
After a name has
been created, F3 will paste names.
|
85.
|
F4
|
Repeats last action. For example, if you changed the color of
text in another cell, pressing F4 will change the text in cell to the same
color.
|
86.
|
F5
|
Goes to a specific cell. For
example, C6.
|
87.
|
F6
|
Move to the next pane.
|
88.
|
F7
|
Spell check selected text or
document.
|
89.
|
F8
|
Enters Extend Mode.
|
90.
|
F9
|
Recalculates every workbook.
|
91.
|
F10
|
Activates the menu bar.
|
92.
|
F11
|
Creates
a chart from selected data.
|
93.
|
F12
|
Save as.
|
94.
|
Shift+F1
|
Opens the “What’s This?”
window.
|
95.
|
Shift+F2
|
Allows the user to edit a cell comment.
|
96.
|
Shift+F3
|
Opens the
Excel formula window.
|
97.
|
Shift+F5
|
Brings up a search box.
|
98.
|
Shift+F6
|
Move to previous pane.
|
99.
|
Shift+F8
|
Add to selection.
|
100.
|
Shift+F9
|
Performs calculate function
on active sheet.
|
101.
|
Ctrl+F3
|
Open Excel Name Manager.
|
102.
|
Ctrl+F4
|
Closes current Window.
|
103.
|
Ctrl+F5
|
Restores window size.
|
104.
|
Ctrl+F6
|
Next workbook.
|
105.
|
Ctrl+Shift+F6
|
Previous workbook.
|
106.
|
Ctrl+F7
|
Moves the window.
|
107.
|
Ctrl+F8
|
Resizes the window.
|
108.
|
Ctrl+F9
|
Minimize current window.
|
109.
|
Ctrl+F10
|
Maximize currently selected window.
|
110.
|
Ctrl+F11
|
Inserts a macro sheet.
|
111.
|
Ctrl+F12
|
Opens a file.
|
112.
|
Ctrl+Shift+F3
|
Creates names by using those
of either row or column labels.
|
113.
|
Ctrl+Shift+F6
|
Moves to the previous worksheet window.
|
114.
|
Ctrl+Shift+F12
|
Prints the current worksheet.
|
115.
|
Alt+F1
|
Inserts a chart.
|
116.
|
Alt+F2
|
Save as.
|
117.
|
Alt+F4
|
Exits Excel.
|
118.
|
Alt+F8
|
Opens the macro dialog box.
|
119.
|
Alt+F11
|
Opens the Visual Basic editor.
|
120.
|
Alt+Shift+F1
|
Creates a new worksheet.
|
121.
|
Alt+Shift+F2
|
Saves the current worksheet.
|
No comments:
Post a Comment