Microsoft Excel Shortcut Keys
Microsoft Excel performs to make all types of spreadsheets. It is the best solution for reporting, data processing, formulas, calculations, VBA ( visual basic projects ) and printing. We do all our office work related to sheets on MS Excel and get hard copy with help of printer. You can even download templates or create your own.
Environment of MS Office
 |
| ms_excel_enviornment |
From above picture we estimate the environment of Microsoft Excel. The following are the important part of Excel given below which will help you to create an attractive spreadsheets as soon as possible
* Quick Access Tool bar
* Ribbon Tabs
* Formula Bar
* Icon Dialogue Box
* Coloumn Letters in Coloumn Header
* Row Numbers in Row header
* Status Bar
* Zoom Slider
MS Excel Shortcut Keys
| Shortcut Keys | Description |
|---|---|
| CTRL+A | Select whole worksheet |
| CTRL+B | Applies or remove bold to selected columns |
| CTRL+C | Applies or remove Copy to selected columns |
| CTRL+D | Duplicate the text from above cell |
| CTRL+F | Open Find and Replace dialogue box, with Find tab selected |
| CTRL+G | Open Goto Dialogue box |
| CTRL+H | Open Find and Replace dialogue box, with Replace tab selected |
| CTRL+I | Applies or Remove Italic to selected columns |
| CTRL+K | Open Insert Hyperlink dialogue box for new hyperlink or edit hyperlink |
| CTRL+L | Open Create Table dialogue box |
| CTRL+N | Create a new, blank workbook |
| CTRL+O | Open the Open Dialogue box |
| CTRL+P | Open Print Dialogue Box |
| CTRL+S | Save the current workbook |
| CTRL+T | Open Create Table Dialogue Box |
| CTRL+U | Applies or remove Underline to selected columns |
| CTRL+V | Paste the Copied or Cut columns text |
| CTRL+W | Close the Current Workbook |
| CTRL+X | Cut or Move the Selected columns |
| CTRL+Y | Redu, Repeats Last command or action if possible |
| CTRL+Z | Undu, Reverse or delete the last entry |
| CTRL+Minus (-) | Open Delete dialogue box for deleting cell, row or column |
| CTRL+1 | Open Format cells dialogue box |
| CTRL+2 | Bold the text of selected columns |
| CTRL+3 | Italic the text of selected columns |
| CTRL+4 | Underline the text of selected columns |
| CTRL+5 | Strikethrough the text of selected columns |
| F1 | Open Microsoft Office Excel Help task pane |
| CTRL+F1 | Display or Hide Ribbon |
| CTRL+F2 | Show the print preview |
| CTRL+F4 | Close the current window |
| F5 | Open Go to dialogue box |
| F6 | Switching between panes and ribbon area |
| F7 | Open Spelling and Grammar dialogue box |
| F10 | Switching Cursor between Menu Button and text body |
| F12 | Display Save As dialogue Box |
| CTRL+SHIFT+& | Applies the outline border to the selected cells. |
| CTRL+SHIFT+F | Open Format cells dialogue box |
| CTRL+SHIFT_ | Removes the outline border from the selected cells. |
| CTRL+SHIFT+$ | applies the Currency format with two decimal places (negative numbers in parentheses). |
| CTRL+SHIFT+% | Applies the Percentage format with no decimal places. |
| CTRL+SHIFT+# | Applies the Date format with the day, month, and year. |
| CTRL+<left arrow> | Move or Jump toward left written cell in a row. |
| CTRL+<right arrow> | Move or Jump toward right written cell in a row. |
| CTRL+<up arrow> | Move or Jump toward up written cell in a column. |
| CTRL+<down arrow> | Move or Jump toward down written cell in a column. |
| CTRL+HOME | Move or Jump toward first cell of worksheet |
| CTRL+END | Move or Jump toward last written cell of worksheet |
| SHIFT+F3 | Open Insert Function dialogue box |
| CTRL+SHIFT+@ | Applies the Time format with the hour and minute, and AM or PM. |
| CTRL+SHIFT+: | Enters the current time. |
| CTRL+; | Enters the current date. |
Comments
Post a Comment