Explanation

• Cell borders in MS Excel are used to separate and define individual cells or ranges of cells.
• Borders make worksheets clearer, organized, and easier to read.
• Borders can be applied to the top, bottom, left, right, or all sides of a cell or selected range.

Last verified on 04-10-2026

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

• 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

• Ctrl + D: Fill Down
• Ctrl + R: Fill Right

Additional information

• 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