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

• Excel 2007–2026 (Default): .xlsx

Additional information:

• Excel 97–2003 (Default): .xls
• Excel Macro-Enabled Workbook: .xlsm
• Excel Binary Workbook: .xlsb
• Excel Template: .xltx

Last verified on 12-07-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

• Pressing F2 allows you to edit the contents or formula of the current cell in MS Excel.

Additional information:

• F4: Repeat last action / toggle absolute and relative references
• CTRL + 1: Opens Format Cells dialog
• CTRL + F: Opens Find dialog
• Works in: Excel 2007, 2010, 2013, 2016, 2019, 365

Last verified on 12-03-2026

Explanation

• Alt + Shift + F1 / Shift + F11 → Insert a new worksheet

Additional information:

• Shift + F10 → Open shortcut/context menu
• Ctrl + Page Up → Previous worksheet
• Ctrl + Page Down → Next worksheet

Last verified on 15-07-2026