Few Lines on Engineer's Day

MS Excel Keyboard Shortcuts

Microsoft Excel is one of the most common and largely used spreadsheet software used in almost every organizations. MS Excel helps in organizing the database in a very simple and effective manner. Though there are various menu options provided in the software for performing relevant tasks but it is better if we know the keyboard shortcuts for performing a specific task.


Basic and Advanced MS Excel Keyboard Shortcuts

We have provided some basic as well as advanced excel shortcuts through keyboard which will not only save your time but it will also enhance your efficiency and productivity. The excel shortcut cheat sheet provided below will be very handy during your daily tasks. 

Most Common Basic and Advance Excel Shortcuts

Ctrl + O - Open and Existing Workbook/File

Ctrl + N - Create a New Workbook/File

Ctrl + S - Saving a Workbook/File

Ctrl + P - Opens the Print Dialog Box for Printing

Ctrl + A - Select Whole Worksheet

Ctrl + C - Copy the Selected/Active Cell Content

Ctrl + X - Cut the Selected/Active Cell Content

Ctrl + V - Paste the Copied Content

Ctrl + F - Find a Content in the Worksheet

Ctrl + W - Close the Currently Opened Workbook

Ctrl + Z - Undo the Previous Action

Ctrl + Y - Redo the Last Action

Ctrl + H - Opens the Find/Replace Box

Ctrl + Spacebar - Select the Complete Column of the Active Cell

Shift + Spacebar - Select the Complete Row of the Active Cell

Ctrl + D - Copies the data present in the cell above to the selected cell

Ctrl + ; - Enters the Current Date

Ctrl + + (plus sign) - Insert Row/Column after the active cell

Ctrl + - (minus sign) - Delete Row/Column

Ctrl + Home - Move to the First Cell

Ctrl + End - Move to the Last Cell

We will be updating the page regularly, so that we can add more and more Excel Keyboard Shortcuts,
Keep visiting…




Comments