Categories: Coding & Developer

Top Excel Shortcuts you should master in 2023

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
4.3 (6745 views)

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
Top Courses in Coding & Developer
Ashli Varghese

A recent graduate in Political Science from Lady Shri Ram College for Women, Ashli is a published researcher and a poet. She is currently working as a technical writer at Learnfly. She is a huge admirer of British thespian, American sitcoms and crime thrillers in languages with subtitles. She loves exploring art in all forms and is equipped with learning coding and video-editing skills, in her free time.