Explanation

• CTRL + H is the shortcut key used in most software (like MS Word, Excel) to open the Find and Replace dialog box.
• It allows users to search for a word or phrase and replace it with another.

Additional information:

• CTRL + F: Only opens the Find dialog
• CTRL + G: Opens the Go To dialog
• CTRL + R: Aligns text to the right in word processors

Last verified on 10-06-2026

Explanation

• Ctrl + D → Opens Font Dialog Box. 
• Ctrl + F12 → Opens the Open Document dialog box. 
• Ctrl + H → Opens the Replace dialog box.

Explanation

• Ctrl + H is used for Find and Replace function.
• It allows users to search text and replace it quickly.

Additional information:

• Ctrl + F → Find text
• Ctrl + C → Copy
• Ctrl + V → Paste
• Ctrl + X → Cut
• Ctrl + Z → Undo

Last verified on 19-04-2026

Explanation

• PrtScn captures a picture of the screen.
• The screenshot is copied to the clipboard.
• It can then be pasted using Ctrl + V.

**

Explanation

• In MS Excel Ctrl+9 shortcut key is used for hiding rows.

Additional information:

• Ctrl+0 (zero) to Hide Columns.
• Ctrl+Shift+( to Unhide Rows.
• Ctrl+Shift+) to Unhide Columns 
• Ctrl + N New Workbook
• Ctrl + O Open Workbook
• Ctrl + S Save Workbook
• Ctrl + P Print
• Ctrl + K Insert Hyperlink
• Ctrl + ; Insert Current Date
• Ctrl + Shift + ; Insert Current Time

Last updated NA on 10-09-2026

Explanation

• The shortcut key to insert a new slide in a PowerPoint presentation is Ctrl + M.

Additional information:

• Ctrl + N shortcut key used to create a new presentation document.
• Ctrl + S shortcut key used to save a presentation.

Last verified on 29-05-2026

Explanation

• Ctrl + R runs the Fill Right command

Additional information

• Ctrl + D: Fill Down
• SUM(): Adds/total values in a range
• COUNT(): Counts cells containing numbers
• MOD(): Returns the remainder after division

Explanation

• To highlight a column, Ctrl+Space is used.

Additional information:

• Shift + Space is used for row.
• Help in MS Excel: F1
• Display active cells in Excel: Shift+Backspace
• Current date in Excel: Ctrl+;
• GO TO tab in Ms. Excel: F5 
• Column highlight: CTRL + space
• SUM formula in MS Excel: ALT + =
• New worksheet in Excel: Shift + F11
• Format numbers in comma format: Shift+1

Last updated NA on 10-09-2026

Explanation

• In MS Excel, every formula and function starts with the equal sign (=).
• The = tells Excel that the cell contains a formula, not plain text.
• Functions such as SUM, AVERAGE, and IF also begin with =.
• Without the =, Excel treats the entry as ordinary text.

Last verified on 10-02-2026

Explanation

• Ctrl + F10 → Maximize/Restore selected document window

Additional information:

• Alt + F4 → Close the active window
• Alt + Tab → Switch between open windows
• Windows + Up Arrow → Maximize the current window
• Windows + Down Arrow → Restore or minimize the current window

Last verified on 23-07-2026