Ms Excel Shortcut Key is of great importance for upcoming government exams. Every candidate preparing for the government examination in year 2022 needs to take the knowledge and strong preparation. This article will provide you with all the necessary information about Ms Excel Shortcut Key in Tabular Form. Examinations in 2022 are going to be extremely competitive for candidates. We have given below content and questions & answers to General Knowledge 2022. Through reading these, you will learn more about general knowledge.
In our site gkfile.com we provide basic and advance information and it’s related question and answer regarding topics typically found in competitive exams. Take a look at knowledgeable article to make your future bright. Exams for the central government, state governments, banking sectors and other are upcoming and our site Questions and Answers will serve you well.
About Ms Excel Shortcut Key
Dear reader, “Ms Excel Shortcut Key” is a topic that has a lot of potential in computer knowledge. It is an extremely useful topic in SBI/IBPS as i other competitive exams. Maybe you have 1 or 2 questions on this topic. There are various file extensions and file types used on computers. You can find a complete list on our Computer Files and File Extensions page. It is impossible for most people to remember all the file extensions. Below is a list of the most common Ms Excel Shortcut Key, divided into sections based on file type.
Using “Ctrl + “ and Alphabetical key
| Shortcuts | Uses of Shortcut keys |
| Ctrl + A | Selects all text |
| Ctrl + B | Bold highlighted selection |
| Ctrl + C | Copy selected text |
| Ctrl + D | Fill Down |
| Ctrl + F | These keys are used to open find |
| Ctrl + G | To open Go To options |
| Ctrl + H | To open Find and replace options |
| Ctrl + I | used to Italicize highlighted selection |
| Ctrl + K | Insert Hyperlink |
| Ctrl + N | New Workbook |
| Ctrl + O | Use to open options in MS-Excel |
| Ctrl + P | Print Command |
| Ctrl + R | Fill Right |
| Ctrl + S | To save file |
| Ctrl + U | Underline highlighted text |
| Ctrl + V | Paste the selected item |
| Ctrl + W | to close the document |
| Ctrl + Y | Redo |
| Ctrl + Z | Undo (you can undo the last deleted action) |
Using “Ctrl + “ and Special Key
| Shortcuts | Uses of Shortcut keys |
| Ctrl + Shift + : | Insert Current Time |
| Ctrl + Shift + ; | Insert Current Date |
| Ctrl + “ | Copy Value from cell above |
| Ctrl + ‘ | Copy Formula from cell above |
| Ctrl + + | Insert |
| Ctrl + – | Delete |
| Ctrl + Tab | *In workbook: Active next workbook |
| Ctrl + Tab | **In toolbar: to move on next toolbar |
Using “Ctrl + “ and Numeric Key
| Shortcuts | Uses of Shortcut keys |
| Ctrl + 1 | Format cell dialog box |
| Ctrl + 2 | Bold |
| Ctrl + 3 | Italic |
| Ctrl + 4 | Underline |
| Ctrl + 5 | Strikethrough |
| Ctrl + 6 | Show / Hide Object |
| Ctrl + 7 | Show / Hide standard toolbar |
| Ctrl + 8 | Toggle outline symbols |
| Ctrl + 9 | Hide rows |
| Ctrl + 0 | Hide Columns |
Using “Function Key “
| Shortcuts | Uses of Shortcut keys |
| F1 | Help |
| F2 | Edit |
| F3 | Paste Name |
| F4 | *Repeat last Action ** While typing a formula switch between absolute/ relative reference |
| F5 | Go to Option |
| F6 | Next Pane |
| F7 | Spell Check |
| F8 | Extend mode |
| F9 | Recalculate all work books |
| F10 | Active Menu bar |
| F11 | To insert New Chart |
| F12 | Save As option |
Using “Ctrl+“ and Function Key
| Shortcuts | Uses of Shortcut keys |
| Ctrl + F3 | Define Name |
| Ctrl + F4 | Close |
| Ctrl + F5 | Restore Window Size |
| Ctrl + F6 | Next Workbook window |
| Ctrl + F7 | Move window |
| Ctrl + F8 | Resize window |
| Ctrl + F9 | Minimize workbook |
| Ctrl + F10 | Maximize or restore window |
| Ctrl + F11 | Insert 4.0 Macro sheet |
| Ctrl + F1 | File Open |
| Ctrl + F2 | Print Preview |
Using “Shift +“and Function Key
| Shortcuts | Uses of Shortcut keys |
| Shift + F1 | What’s this? |
| Shift + F2 | Edit cell comment |
| Shift + F3 | Paste function into formula |
| Shift + F4 | Find Next |
| Shift + F5 | Find |
| Shift + F6 | Previous Paste |
| Shift + F8 | Add to Selection |
| Shift + F9 | Calculate Active worksheet |
| Shift + F10 | Display shortcut Menu |
| Shift + F11 | New work sheet |
| Shift + F12 | Save |
Using “Alt +“and Function Key
| Shortcuts | Uses of Shortcut keys |
| Alt + F1 | Insert Chart |
| Alt + F2 | Save As |
| Alt + F4 | Exit |
| Alt + F8 | Macro dialog box |
| Alt + F11 | Visual Basic Editor |
Using “Alt +“and Special Character Key
| Shortcuts | Uses of Shortcut keys |
| Alt + = | Auto Sum |
| Alt + Down Arrow | Display |
| Alt + ‘ | Format Style Dialog Box |
| Alt | Active the menu |
Using “Alt + Shift +“and Function Key
| Shortcuts | Uses of Shortcut keys |
| Alt + Shift + F1 | New Worksheet |
| Alt + Shift + F2 | Save |
Using “Ctrl + Shift +“and Function or Special Character Key
| Shortcuts | Uses of Shortcut keys |
| Ctrl + Shift + F3 | Create name by using name of row and columns labels. |
| Ctrl + Shift + F6 | Previous Window |
| Ctrl + shift + F12 | |
| Ctrl + Shift + ~ | General Format |
| Ctrl + Shift + ! | Comma Format |
| Ctrl + Shift + @ | Time Format |
| Ctrl + Shift + # | Date Format |
| Ctrl + Shift + $ | Currency Format |
| Ctrl + Shift + % | Percentage Format |
| Ctrl + Shift + ^ | Exponential Format |
| Ctrl + Shift + & | Place Outline border around selected cells. |
| Ctrl + Shift + _ | Remove outline border |
| Ctrl + Shift + * | Selected Current region |
| Ctrl + Shift + ( | Unhide row |
| Ctrl + Shift + ) | Unhide Columns |
Using “Ctrl + Shift +“and Function or Special Character Key
| Shortcuts | Uses of Shortcut keys |
| Ctrl + Shift + F3 | Create name by using name of row and columns labels. |
| Ctrl + Shift + F6 | Previous Window |
| Ctrl + shift + F12 | |
| Ctrl + Shift + ~ | General Format |
| Ctrl + Shift + ! | Comma Format |
| Ctrl + Shift + @ | Time Format |
| Ctrl + Shift + # | Date Format |
| Ctrl + Shift + $ | Currency Format |
| Ctrl + Shift + % | Percentage Format |
| Ctrl + Shift + ^ | Exponential Format |
| Ctrl + Shift + & | Place Outline border around selected cells. |
| Ctrl + Shift + _ | Remove outline border |
| Ctrl + Shift + * | Selected Current region |
| Ctrl + Shift + ( | Unhide row |
| Ctrl + Shift + ) | Unhide Columns |
Comments on “Important Ms Excel Shortcut Key for Computer Awareness”