Ms Excel Shortcut Keys
As you
know, Excel is a very important software for doing any work through the
computer connected to the office or elsewhere, in which we keep a soft copy of
the biodata of any work on the computer. Excel has many features and it becomes
very difficult and difficult to use these features. But if the same work is
done by Shortcut Keys then it becomes much easier. Therefore, to make your
Excel work much easier, the following shortcuts have been given, from which you
can remember important Shortcut Keys according to your work.
ms excel shortcut keys list, ms excel , hortcut keys pdf download, shortcut keys a to z, formula, ms excel shortcut keys image, engdtechin |
Ms Excel Shortcut Keys
Alt + ' :-
Open
the format style dialog box
Alt + = :-
Automatically
add (autosome)
Alt + Down
Arrow :- View
Auto Complete List
Alt + Enter :-
Start a new line in the same cell
Alt +
Esc:- Go
to the last two applications in the taskbar
Alt + F1 :-
Insert chart
sheet
Alt + F11 :-
Open Visual Basic Editor
Alt + F2 :-
Save as
Alt + F4 :-
Exclude from Workbook
Alt + F8 :-
Box macro dialog
Alt + I + C :- Insert Column
Alt + I + R :-
Insert RAW
Alt + Shift
+ F1 :- New Worksheet
Alt + Shift
+ F2 :- Save the workbook
Alt Or F10 :-
activate the menu
Ctrl +: :- Enter the current time
Ctrl + - :-
delete
Ctrl +; :-
Enter today's date
Ctrl +
" :- Copy the value from the top
cell
Ctrl + 0 :-
Hide the column
Ctrl + 1 :-
Format Cell Dialog Box
Ctrl + 2 :-
Bold
Ctrl + 3 :-
Italicize
Ctrl + 4 :- Underline
Ctrl + 5 :-
Cut
Ctrl + 6 :-
Show
or hide objects
Ctrl + 7 :-
Show or hide toolbar
Ctrl + 8 :-
View
outline symbol
Ctrl + 9 :-
Hide Row
Ctrl + A :-
Select
all the cells in the range.
Ctrl + Alt
+ F9 :- Complete calculations of all worksheets
Ctrl + Alt
+ Shift + F9 :- Measure Everything
Ctrl + B :-
Bold
Ctrl + C :-
Copy
Ctrl + D :-
Fill
columns
Ctrl + End :-
Go
to the last cell of the worksheet
Ctrl +
Enter :- Fill the same item in all the columns of a
cell
Ctrl + F :-
Search
Ctrl + F10 :-
Maximize
or restore
Ctrl + F11 :-
insert
4.0 macro sheet
Ctrl + F12 :-
Open
the file
Ctrl + F3 :-
Define
Name
Ctrl + F4 :-
Close
Ctrl + F5 :-
Restore
Window Size
Ctrl + F6 :-
Go
to the next workbook window
Ctrl + F7 :-
Move
the window
Ctrl + F8 :-
Resize Window
Ctrl + F9 :-
Minimize
Workbook
Ctrl + G :-
Go
To
Ctrl + H :-
Replace
Ctrl + Home :-
Go to the first box of the sheet
Ctrl + I :-
Italicize
Ctrl + K :-
Add
hyperlink
Ctrl + N :-
Open
a new workbook
Ctrl + O :-
Open
Ctrl + P :-
Print
Ctrl + Page
Down:- Go to next worksheet
Ctrl + Page
Up :- Go to previous worksheet
Ctrl + R :-
Fill
in the right part
Ctrl +
Right Arrow :- Go to the right of the range
Ctrl +
Right Arrow :- Go to the right of the range
Ctrl + S :-
Save
Ctrl +
Shift + # :- Format date
Ctrl +
Shift + + :- Insert cells, rows and columns
Ctrl +
Shift +! :- Coma format
Ctrl +
Shift + $ :- Format currency
Ctrl +
Shift +% :- Format percent
Ctrl +
Shift + & :- Outline boundary in selected cell
Ctrl +
Shift + ( :- Show Row
Ctrl +
Shift +) :- Show the column
Ctrl +
Shift + * :- Select Current Region
Ctrl +
Shift + @ :- Format time
Ctrl +
Shift + ^ :- format exponential
Ctrl +
Shift + _ :- Remove the outline border
Ctrl +
Shift + ~ :- Format General
Ctrl +
Shift + 1 :- Format in two decimal signs
Ctrl +
Shift + 2 :- Format by time
Ctrl +
Shift + 3 :- Enter the date
Ctrl +
Shift + 4 :- Convert cells to currency
Ctrl +
Shift + 5 :- Convert cells to percentage
Ctrl +
Shift + 6 :- Scientific
Signs
Ctrl +
Shift + 7 :- Draw Outlines Around Selection
Ctrl +
Shift + A :- Enter the arguments name in the formula
Ctrl +
Shift + F12 :- Print
Ctrl +
Shift + F3 :- Create a list in the name of rows and
columns
Ctrl +
Shift + F6 :- Go to previous window
Ctrl +
Spacebar :- Select the current column
Ctrl + Tab :-
activate
the next workbook
Ctrl + U :-
Underline
Ctrl + V :-
Paste
Ctrl + X :-
Cut
Ctrl + Y :-
Repeat
Ctrl + Z :-
Go
back one step
Ctrl W :-
Close
the workbook
Enter :-
Ok
any command
F1 :-
get help
F10 :-
activate
the menu bar
F11 :-
Create
new charts
F12 :-
Save
as
F2 :-
Edit
F3 :-
Paste
Name
F4 :-
While
writing a formula go to the next
F4 :-
Repeat previous action
F5 :-
Go to new page
F6 :-
Go to next window
F7 :-
Check
Spelling
F8 :-
Being in Extend Mode
F9 :-
Calculate
all workbooks again
Shift :-
Open
other Excel functions
Shift +
Ctrl + F :- Open the list of different fonts
Shift +
Ctrl + F + F :-Go to the list of options to change the font
of font tab
Shift +
Ctrl + F6:- Go to the
previous Excel window
Shift +
Ctrl + P :- Open point size list
Shift +
Ctrl + Tab :- Open the previous workbook
Shift +
Ctrl + Tab :- Open the previous toolbar
Shift +
Enter :- Go to the previous cell
Shift + F1 :-
What
is this?
Shift + F10 :-
Show
shortcut menu
____________________
Tags:- ms excel shortcut keys, ms excel shortcut keys list, ms
excel shortcut keys pdf, ms excel , hortcut keys pdf download, ms excel
shortcut keys a to z, ms excel shortcut keys formula, ms excel shortcut keys
image, Microsoft excel shortcut keys.