Nowadays, a business needs the help of many software and tools to manage and run effectively. These tools are effectively used to save time and resources as they provide immediate results from the analysis. There are several tools available for a variety of businesses, but Microsoft Office Excel is the most common and well-known tool that every business needs.
These are some of the Shortcut keys mostly used in Microsoft Excel,
|
SHORTCUT KEYS |
Description |
|
Ctrl+A |
To Select All |
|
Ctrl+B |
To Bold letters |
|
Ctrl+C |
To Copy cells |
|
Ctrl+D |
To Fill Down |
|
Ctrl+E |
Flash Fill |
|
Ctrl+F |
To
Find(Search on the current page) |
|
Ctrl+G |
Goto |
|
Ctrl+H |
To Replace |
|
Ctrl+I |
Italic (To change the font) |
|
Ctrl+K |
To Insert Hyperlink |
|
Ctrl+N |
To Create a New Workbook |
|
Ctrl+O |
To Open an existing workbook |
|
Ctrl+P |
To Print a page |
|
Ctrl+R |
Fill Right |
|
Ctrl+S |
To Save a workbook |
|
Ctrl+U |
To Underline |
|
Ctrl+V |
To Paste |
|
Ctrl W |
To Close the current workbook |
|
Ctrl+X |
To Cut a cell |
|
Ctrl+Y |
To Repeat |
|
Ctrl+Z |
To Undo your last action |
|
F1 |
To Help |
|
F2 |
To Edit |
|
F3 |
To Paste Name |
|
F4 |
To Repeat last action |
|
F4 |
While typing a formula, switch between
absolute/relative refs |
|
F5 |
Goto |
|
F6 |
To Next Pane |
|
F7 |
To Spell check |
|
F8 |
To Extend mode |
|
F9 |
To Recalculate all workbooks |
|
F10 |
To Activate Menu bar |
|
F11 |
To create a New Chart |
|
F12 |
To Save the active workbook under a new name, displays the Save as dialog box. |
Comments
Post a Comment