Set 3 Some Computer Related Important Shortcuts Keys

What is the shortcut key for opening the Find and Replace dialog box in Microsoft Excel?

Answer: Ctrl + F

What is the shortcut key for opening the Go To dialog box in Microsoft Excel?

Answer: Ctrl + G

What is the shortcut key for opening the Insert Function dialog box in Microsoft Excel?

Answer: Shift + F3

What is the shortcut key for opening the Name Manager in Microsoft Excel?

Answer: Ctrl + F3

What is the shortcut key for opening the Conditional Formatting menu in Microsoft Excel?

Answer: Alt + H + L

What is the shortcut key for opening the Sort dialog box in Microsoft Excel?

Answer: Alt + D + S

What is the shortcut key for opening the Filter dialog box in Microsoft Excel?

Answer: Alt + A + T

What is the shortcut key for opening the Page Setup dialog box in Microsoft Excel?

Answer: Alt + P + S

What is the shortcut key for opening the Print Preview window in Microsoft Excel?

Answer: Ctrl + F2

What is the shortcut key for saving a workbook in Microsoft Excel?

Answer: Ctrl + S

What is the shortcut key for opening a new workbook in Microsoft Excel?

Answer: Ctrl + N

What is the shortcut key for opening an existing workbook in Microsoft Excel?

Answer: Ctrl + O

What is the shortcut key for closing a workbook in Microsoft Excel?

Answer: Ctrl + W

What is the shortcut key for copying selected cells in Microsoft Excel?

Answer: Ctrl + C

What is the shortcut key for cutting selected cells in Microsoft Excel?

Answer: Ctrl + X

What is the shortcut key for pasting cells in Microsoft Excel?

Answer: Ctrl + V

What is the shortcut key for undoing an action in Microsoft Excel?

Answer: Ctrl + Z

What is the shortcut key for redoing an action in Microsoft Excel?

Answer: Ctrl + Y

What is the shortcut key for opening the VBA editor in Microsoft Excel?

Answer: Alt + F11

What is the shortcut key for inserting a new module in the VBA editor in Microsoft Excel?

Answer: Alt + I, then M

What is the shortcut key for opening the immediate window in the VBA editor in Microsoft Excel?

Answer: Ctrl + G

What is the shortcut key for running a macro in Microsoft Excel?

Answer: Alt + F8

What is the shortcut key for displaying the Developer tab in Microsoft Excel?

Answer: File -> Options -> Customize Ribbon -> check Developer

What is the shortcut key for selecting all cells in a worksheet in Microsoft Excel?

Answer: Ctrl + A

What is the shortcut key for entering a formula in Microsoft Excel?

Answer: = (equals sign)

What is the shortcut key for entering an array formula in Microsoft Excel?

Answer: Ctrl + Shift + Enter

What is the shortcut key for inserting a hyperlink in Microsoft Excel?

Answer: Ctrl + K

What is the shortcut key for hiding a column in Microsoft Excel?

Answer: Ctrl + 0 (zero)

What is the shortcut key for hiding a row in Microsoft Excel?

Answer: Ctrl + 9

What is the shortcut key for showing all hidden columns in Microsoft Excel?

Answer: Ctrl + Shift + 0 (zero)

What is the shortcut key for showing all hidden rows in Microsoft Excel?

Answer: Ctrl + Shift + 9

What is the shortcut key for formatting cells in Microsoft Excel?

Answer: Ctrl + 1

What is the shortcut key for copying cell formatting in Microsoft Excel?

Answer: Ctrl + Shift + C

What is the shortcut key for pasting cell formatting in Microsoft Excel?

Answer: Ctrl + Shift + V

What is the shortcut key for inserting a new row in Microsoft Excel?

Answer: Ctrl + Shift + +

What is the shortcut key for inserting a new column in Microsoft Excel?

Answer: Ctrl + Shift + =

What is the shortcut key for deleting a row in Microsoft Excel?

Answer: Ctrl + -

What is the shortcut key for deleting a column in Microsoft Excel?

Answer: Ctrl + -

What is the shortcut key for auto filling a series in Microsoft Excel?

Answer: Ctrl + E

What is the shortcut key for grouping selected cells in Microsoft Excel?

Answer: Ctrl + Shift + )

What is the shortcut key for ungrouping selected cells in Microsoft Excel?

Answer: Ctrl + Shift + (

What is the shortcut key for inserting a new worksheet in Microsoft Excel?

Answer: Shift + F11

What is the shortcut key for renaming a worksheet in Microsoft Excel?

Answer: Alt + O + H + R

What is the shortcut key for moving to the next worksheet in Microsoft Excel?

Answer: Ctrl + Page Down

What is the shortcut key for moving to the previous worksheet in Microsoft Excel?

Answer: Ctrl + Page Up

What is the shortcut key for freezing panes in Microsoft Excel?

Answer: Alt + W + F + F

What is the shortcut key for unfreezing panes in Microsoft Excel?

Answer: Alt + W + F + U

What is the shortcut key for changing the font in Microsoft Word?

Answer: Ctrl + D

What is the shortcut key for changing the font size in Microsoft Word?

Answer: Ctrl + Shift + P