%20(Class%20No.%203).jpeg)
Preparing a lengthy sheet in MS Excel and then revising the
data or editing any single piece of information in the complete sheet would be
time-consuming of you are not aware of the shortcut keys for MS Excel. All
computer keyboard shortcut keys for MS office programs have been discussed
below. Check out the table given below to know the shortcut keys used in MS
Excel.
|
Shortcut keys |
Used of shortcut keys |
|
Alt + Shift + F1 |
When you want insert new worksheet use
these keys together |
|
Shift + F3 |
With the help of these keys, you can
open the MS-Excel formula window |
|
Shift + F5 |
when you press these keys together it
will open the search box |
|
F11 |
The F11 key is used to create a chart
in MS excel |
|
Ctrl + shirt +; |
With the help of these keys, you can
enter the current time |
|
Ctrl +; |
Use these keys together to enter the
current date |
|
Ctrl + K |
When you want to insert a link, you can
use these keys together |
|
Ctrl + F |
These keys are used to open find and
replace options in MS-Excel |
|
Ctrl + G |
Use
these keys together to open go-to options |
|
Ctrl + B |
When you press these keys together it
will bold highlighted selection |
|
F2 |
When you want to edit the selected cell
using this key |
|
F5 |
With the help of this key, you can go
to a specific cell |
|
F7 |
With the help of this key, you can
check the spell of selected text |
|
Ctrl + I |
These commands are used to Italicize
highlighted selection. |
|
Ctrl + space |
Use these keys together to select the
entire column |
|
Shift + space |
Use these keys together to select the
entire now |
|
Ctrl + W |
Use these keys together to close the
document |
|
Ctrl + H |
Use these keys to open find and replace
options |
|
Ctrl + U |
With help of these keys, you can
underline highlighted text |
|
Ctrl + Y |
With help of these keys, you can
underline highlighted text |
|
Ctrl + Z |
With the help of these keys, you can
undo the last deleted action |
|
Ctrl + F9 |
Use these keys to minimize a current
window in MS- Excel |
|
Ctrl + F10 |
Use these keys to maximize the
currently selected window in MS- Excel |
|
Ctrl + Tab |
With the help of these keys, you can move between two or more open
MS-Excel |
|
Ctrl + = |
With the help of these keys, you can
initiate the formula to add all of the above cells |
|
Ctrl + |
With this of these keys together you
can insert the value in the current cell from the above cell. |
|
Ctrl (right arrow) |
With the help of these keys, you can
jump on to the next section of text |
|
Ctrl + O |
Use these keys to open options in
MS-Excel |
|
Ctrl + N |
Use these keys together to open the
document in MS- Excel |
|
Ctrl + P |
Use these keys together to open print
dialogue box in MS Excel |
إرسال تعليق