by admin | May 4, 2025 | Excel Tips & Tricks
Focus Cell View👉 Helps you concentrate by graying out other cells and only highlighting the active one. Hide and Unhide Sheet Easily👉 Right-click on any sheet tab → Hide or Unhide with a clean list view—no need to scroll. Highlight Active Row & Column👉 Excel now...
by admin | May 3, 2025 | Excel Tips & Tricks
🔹 Method 1: Using an Apostrophe Type ‘000123 → Excel treats it as text and displays the leading zeros. 🔹 Method 2: Format as Text Select the cells Right-click → Format Cells → Choose Text Now enter numbers with zeros (e.g., 00123), and they will stay. 🔹 Method...
by admin | Apr 19, 2025 | Excel Tips & Tricks
🔹 Formula to Calculate Percentage Marks 📌 Formula: =B2*100/C2 🔹 Explanation: B2 → Marks Obtained C2 → Total Marks Multiplies by 100 to convert into percentage format. 🔹 Example Output: Marks Obtained (B)Total Marks (C)Percentage FormulaResult...
by admin | Apr 18, 2025 | Excel Tips & Tricks
🔹 Use the RANK Function to Find Position in a List 📌 Formula: =RANK(C6, $C$6:$C$30) 🔹 Explanation: C6 → The cell you want to rank. $C$6:$C$30 → The range of values where ranking is applied. This formula assigns a rank based on the highest value (default descending...
by admin | Apr 17, 2025 | Blog, Excel Tips & Tricks
🔹 Automatically Get Today’s Date in Excel 📌 Formula: =TODAY() 🔹 Explanation: This formula returns the current date and updates automatically every day. The format will match your system’s date settings (e.g., 03-Apr-2025). 🔹 Example Usage: FormulaOutput (If...
