Excel Shortcuts

Thumb

Author

BIQ

Questions

46

Last updated

Mar 7, 2022

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.

Most Frequently Asked Keyboard Shortcuts for Excel

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.

Q1. Ctrl+A
Answer

It is used to Select all the contents of a worksheet.

Q2. Ctrl+B
Answer

It is used to Bold all cells in the highlighted section.

Q3. Ctrl+C
Answer

It is used to Copy all cells in the highlighted section.

Q4. Ctrl+O
Answer

It helps in Opens a workbook.

Q5. Ctrl+F
Answer

It is used to Search current sheet.

Q6. Ctrl+G
Answer

It is used to Go to a particular area.

Q7. Ctrl+H
Answer

It is used to Find and replace.

Q8. Ctrl+I
Answer

It is used to italics on all cells in the selected section.

Q9. Ctrl+K
Answer

It is used to Inserts a hyperlink.

Q10. Ctrl+N
Answer

It is used to Creates a new workbook.

Q11. Ctrl+P
Answer

It is used to Print the current page.

Q12. Ctrl+D
Answer

Fill Down

Q13. Ctrl+R
Answer

Fill Right

Q14. Ctrl+S
Answer

It is used to Save the current sheet.

Q15. Ctrl+U
Answer

It is used to Underline the all selected section.

Q16. Ctrl+V
Answer

It is used to Paste the copied contents

Q17. Ctrl+W
Answer
Closes the current page.
Q18. Ctrl+X
Answer

It is used to Cut the selected cells.

Q19. Ctrl+Y
Answer

It is used to Repeats the last entry.

Q20. Ctrl+Z
Answer

It is used to Undo the last action.

Q21. Ctrl+1
Answer

It is used to Changes the format of the selected cells.

Q22. Ctrl+2
Answer

Bolds all cells

Q23. Ctrl+3
Answer

Puts italics highlighted cells.

Q24. Ctrl+4
Answer

It is used to Underlines all cells in the highlighted section.

Q25. Ctrl+6
Answer

It is used to Hides or Shows objects.

Q26. Ctrl+7
Answer

It is used to Hides or Shows the toolbar.

Q27. Ctrl+8
Answer

Toggles the outline symbols

Q28. Ctrl+9
Answer

It is used to Hides rows.

Q29. Ctrl+0
Answer

It is used to Hides columns.

Q30. Ctrl+Shift+:
Answer

It is used to insert the current time.

Q31. Ctrl+;
Answer

It is used to Enter the current date.

Q32. Ctrl+Shift+"
Answer

It is used to Copies value from the cell above.

Q33. Ctrl+-
Answer

It is used to Deletes the selected row/column.

Q34. Ctrl+Shift+=
Answer

It is used to Inserts a new column/row.

Q35. Ctrl+Shift+@
Answer

Applies time formatting.

Q36. Ctrl+Shift+&
Answer

Add a Border around selected cells.

Q37. Ctrl+Shift+_
Answer
It is used to remove a border.
Q38. Ctrl+Home
Answer

It is used to Move to cell A1.

Q39. Ctrl+End
Answer

It is used to Move to the last cell.

Q40. Ctrl+Shift+A
Answer

It is used to Inserts argument names into a formula.

Q41. Shift+Page Up
Answer

Highlights all cells above that are selected in a single column.

Q42. Shift+Page Down
Answer

Highlights all cells above that are selected in a single column.

Q43. F1
Answer

It is used to Open help menu.

Q44. F4
Answer

Repeat last Action

Q45. Alt+F1
Answer

It is used to Insert a Chart.

Q46. Alt+F8
Answer

It is used to Opens the macro dialog box.