Uncategorized
.net training in palwal, 1 year computer course in palwal, Advance Excel training, Best Computer Frachise institute in India, computer institute in Palwal, Digital marketing course in palwal, government computer course in palwal, java training in palwal, online apply of Computer Franchise, web developement training in palwal, web site design traning in palwal
70 Excel Shortcut Commands
Post By
admin
2-December-2017
70 Excel Shortcut Commands
If you want to be expert in Excel using Keyboard you must use the following command:
|
SNO.
|
Shortcut
|
Description
|
|
1
|
F2
|
Edit the selected cell.
|
|
2.
|
Ctrl + F3
|
After a name has been created, F3 will
paste names. |
|
3.
|
F4
|
Repeat 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. |
|
4.
|
F5
|
Go to a specific cell. For example, C6.
|
|
5.
|
F7
|
Spell check selected text or document.
|
|
6.
|
F11
|
Create chart from selected data.
|
|
7.
|
Ctrl+Shift+;
|
Enter the current time.
|
|
8.
|
Ctrl+;
|
Enter the current date.
|
|
9.
|
Alt+Shift+F1
|
Insert New Worksheet.
|
|
10.
|
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. |
|
11.
|
Shift+F3
|
Open the Excel formula window.
|
|
12.
|
Shift+F5
|
Bring up search box.
|
|
13.
|
Ctrl+1
|
Open the Format Cells window.
|
|
14.
|
Ctrl+A
|
Select all contents of the worksheet.
|
|
15.
|
Ctrl+B/ Ctrl +2
|
Bold highlighted selection.
|
|
16.
|
Ctrl+I / Ctrl +3
|
Italic highlighted selection.
|
|
17.
|
Ctrl+K
|
Insert link.
|
|
18.
|
CTRL+PgUp
|
Switches between worksheet tabs, from
left-to-right. |
|
19.
|
CTRL+PgDn
|
Switches between worksheet tabs, from
right-to-left. |
|
20.
|
CTRL+SHIFT+9
|
Unhides any hidden rows within the
selection. |
|
21.
|
CTRL+SHIFT+7
|
Applies the outline border to the
selected cells. |
|
22.
|
CTRL+SHIFT+-
|
Removes the outline border from the selected
cells. |
|
23.
|
CTRL+SHIFT+~
|
Applies the General number format.
|
|
24.
|
CTRL+SHIFT+4
|
Applies the Currency format with two
decimal places (negative numbers in parentheses). |
|
25.
|
CTRL+SHIFT+5
|
Applies the Percentage format with no
decimal places. |
|
26.
|
CTRL+SHIFT+6
|
Applies the Scientific number format with
two decimal places. |
|
27.
|
CTRL+SHIFT+3
|
Applies the Date format with the day,
month, and year. |
|
28.
|
CTRL+SHIFT+2
|
Applies the Time format with the hour and
minute, and AM or PM. |
|
29.
|
CTRL+SHIFT+1
|
Applies the Number format with two
decimal places, thousands separator, and minus sign (-) for negative values. |
|
30.
|
CTRL+SHIFT+8
|
Selects the current region around the
active cell (the data area enclosed by blank rows and blank columns). |
|
31.
|
CTRL+SHIFT+’
|
Copies the value from the cell above the
active cell into the cell or the Formula Bar. |
|
32.
|
CTRL+SHIFT+Plus (+)
|
Displays the Insert dialog box to insert
blank cells. |
|
33.
|
CTRL+Minus (-)
|
Displays the Delete dialog box to delete
the selected cells. |
|
34.
|
CTRL+`
|
Alternates between displaying cell values
and displaying formulas in the worksheet. |
|
35.
|
CTRL+’
|
Copies a formula from the cell above the
active cell into the cell or the Formula Bar. |
|
36.
|
Ctrl+U / Ctrl +4
|
Applies or removes underlining.
|
|
37.
|
CTRL+5
|
Applies or removes strikethrough.
|
|
38.
|
CTRL+6
|
Alternates between hiding and displaying
objects. |
|
39.
|
CTRL+8
|
Displays or hides the outline symbols.
|
|
40.
|
CTRL+9
|
Hides the selected rows.
|
|
41.
|
CTRL+0
|
Hides the selected columns.
|
|
42.
|
CTRL+D
|
Uses the Fill Down command to copy the
contents and format of the topmost cell of a selected range into the cells below. |
|
43.
|
CTRL+F
|
Displays the Find and Replace dialog box,
with the Find tab selected. |
|
44.
|
CTRL+L
|
Displays the Create Table dialog box.
|
|
45.
|
CTRL+N
|
Creates a new, blank workbook.
|
|
46.
|
CTRL+O
|
Displays the Open dialog box to open or
find a file. |
|
47.
|
CTRL+P
|
Displays the Print tab in Microsoft
Office Backstage view. |
|
48.
|
CTRL+R
|
Uses the Fill Right command to copy the
contents and format of the leftmost cell of a selected range into the cells to the right. |
|
49.
|
CTRL+S
|
Saves the active file with its current
file name, location, and file format. |
|
50.
|
CTRL+V
|
Inserts the contents of the Clipboard at
the insertion point and replaces any selection. Available only after you have cut or copied an object, text, or cell contents. |
|
51.
|
CTRL+W
|
Closes the selected workbook window.
|
|
52.
|
CTRL+X
|
Cuts the selected cells.
|
|
53.
|
CTRL+Y
|
Repeats the last command or action, if
possible. |
|
54.
|
CTRL+Z
|
Uses the Undo command to reverse the last
command or to delete the last entry that you typed. |
|
55.
|
Ctrl+Space
|
Select entire column.
|
|
56.
|
Shift+Space
|
Select entire row.
|
|
57.
|
Ctrl+F6
|
Switch between open workbooks or windows.
|
|
58.
|
Ctrl+Home
|
Move to cell A1.
|
|
59.
|
Ctrl+End
|
Move to last cell in active sheet.
|
|
60.
|
Ctrl+Tab
|
Move between Two or more open Excel
files. |
|
61.
|
Alt+=
|
Create a formula to sum all of the above
cells. |
|
62.
|
Ctrl+Arrow key
|
Move to next section of text.
|
|
63.
|
Ctrl+~
|
Switch between showing Excel formulas or
their values in cells. |
|
64.
|
Ctrl+F7
|
Move window
|
|
65.
|
Ctrl+F8
|
Resize window
|
|
66.
|
Ctrl+F9
|
Minimize workbook
|
|
67.
|
Ctrl+F10
|
Maximize or restore window
|
|
68.
|
Alt+F11
|
Visual Basic Editor
|
|
69.
|
Alt+’
|
Format Style dialog box
|
|
70.
|
Alt+F4
|
Exit
|