Data is inevitable, and Microsoft Excel is one of the most used tools in almost all professions and businesses to provide insights and analytics of the market and their organisation’s performance vis-a-vis the competitor firms. The availability of many in-built applications, excel formulas that truncate efforts, a user-friendly interface, robust visualisation capabilities that allow users to create bar graphs, and pie charts, and integration with other Microsoft products where you can link the item to the original sheet, make it a widely used application.
Learn MS Excel From Basic to Advance
Last Updated: 2022-04-19
Enhance Your Skill With Excel.
Why do you need excel shortcut keys:
Excel formula is an expression that calculates a value based on values in cells. These formulas return results, even if there is an error. Formulas in excel begin with a sign (=), and utilise mathematical operators, cell references and functions to perform calculations on values in the cells of the excel sheet. In addition to performing elementary computations like addition, subtraction, multiplication and division, you can also find out averages and calculate percentage formulas in excel for a range of cells, find the minimum and maximum value in a cell, change date and time values, etc. Using MS Excel shortcut keys increases productivity and the access to the right excel shortcut keys dramatically increases efficiency and speed of working on the worksheet.
MS Excel Shortcuts keys list commonly used:
Here are the top excel shortcut keys you should know. Kindly note they may slightly vary according to the version of excel used.
Description | Excel Shortcut Keys |
---|---|
Copy selected cell(s) | CTRL+C |
Cut selected cell(s) | CTRL+X |
Paste copied or cut cell(s) | CTRL+V |
Undo the last action | CTRL+Z |
Redo the last action | CTRL+Y |
Select all the cells in the spreadsheet | CTRL+A |
Open find and replace dialog box | CTRL+F |
Open find and replace dialog box for replacing data | CTRL+H |
For bold formatting to the selected cell | CTRL+B |
For italic formatting to the selected cell | CTRL+I |
For underline formatting to the selected cell | CTRL+U |
To create a new workbook | CTRL+N |
To open an existing workbook | CTRL+O |
Save the active workbook | CTRL+S |
Open the print dialog box | CTRL+P |
Formatting MS Excel shortcut keys list:
Description | Excel Shortcut Keys |
---|---|
Add a comment to a cell | Shift+F2 |
Delete a cell comment | Shift+F10+D |
To activate filter | CTRL+Shift+L |
Insert today’s date | CTRL+; |
Insert current time | CTRL+Shift+: |
Insert hyperlink | CTRL+k |
Apply per cent format | CTRL+Shift+% |
Select the entire row | Shift+Space |
To delete a row | Shift+Space+CTRL+- |
Grouping rows or columns | Alt+Shift+Right arrow |
Ungrouping rows or columns | Alt+Shift+Left arrow |
Add a border | Alt+H+B |
Center align cell contents | Alt+H+A+C |
Remove outline border | CTRL+Shift+_ |
Move to the next cell | Shift+Tab |