Who doesn't like shortcuts!!! As we use Microsoft Excel in our day-to-day office works to create charts, analyze data, run a report and so many other crucial works; having knowledge of keyboard shortcuts for Excel can help users navigate, select, format, and enter formulas with less time consumption and effortlessly. Even if you are well familiar with the workability of Microsoft Excel, you will be surprised by how these Excel Shortcuts will make your Excel operation more convenient and give you a pro look among your colleagues. Here is a complete list of extremely useful keyboard combo available in Excel for your acknowledgment mentioned further below here. Knowing these Excel shortcuts will help you save a great amount of time so that you can focus more on operations that really matter.
Here in this article, we will be listing frequently asked Keyboard Shortcuts for Excel and Answers with the belief that they will be helpful for you to gain higher marks. Also, to let you know that this article has been written under the guidance of industry professionals and covered all the current competencies.
It is used to Select all the contents of a worksheet.
It is used to Bold all cells in the highlighted section.
It is used to Copy all cells in the highlighted section.
It helps in Opens a workbook.
It is used to Search current sheet.
It is used to Go to a particular area.
It is used to Find and replace.
It is used to italics on all cells in the selected section.
It is used to Inserts a hyperlink.
It is used to Creates a new workbook.
It is used to Print the current page.
Fill Down
Fill Right
It is used to Save the current sheet.
It is used to Underline the all selected section.
It is used to Paste the copied contents
It is used to Cut the selected cells.
It is used to Repeats the last entry.
It is used to Undo the last action.
It is used to Changes the format of the selected cells.
Bolds all cells
Puts italics highlighted cells.
It is used to Underlines all cells in the highlighted section.
It is used to Hides or Shows objects.
It is used to Hides or Shows the toolbar.
Toggles the outline symbols
It is used to Hides rows.
It is used to Hides columns.
It is used to insert the current time.
It is used to Enter the current date.
It is used to Copies value from the cell above.
It is used to Deletes the selected row/column.
It is used to Inserts a new column/row.
Applies time formatting.
Add a Border around selected cells.
It is used to Move to cell A1.
It is used to Move to the last cell.
It is used to Inserts argument names into a formula.
Highlights all cells above that are selected in a single column.
Highlights all cells above that are selected in a single column.
It is used to Open help menu.
Repeat last Action
It is used to Insert a Chart.
It is used to Opens the macro dialog box.