Posts

Featured post

Trick to get the sum row wise or column wise

    Row-wise or Column-wise Sum Using a Shortcut: Select the range of numbers in the table that you want to sum (either a column or a row, or even multiple columns or rows). Press the Alt key on your keyboard. After pressing Alt , press the +   = key . This is the AutoSum shortcut. If you're summing a column , Excel will automatically fill the cell directly below the selected range with the sum of that column. If you're summing a row , Excel will automatically fill the cell directly to the right of the selected range with the sum of that row.   The AutoSum feature ( Alt + = ) automatically sums numbers in a contiguous range of cells.    
1 comment
Read more

How to Freeze Heading in Excel (Shortcut Method)

Image
    How to Freeze Heading in Excel (Shortcut Method)        Freezing headings in Excel helps you keep column titles or row headers visible while scrolling through large data sets.     A.         Freeze Top Row (Heading) – Keyboard Shortcut    Steps: 1. Open  Excel worksheet 2. Select the cell directly below the heading row    (Example: If headings are in **Row 1**, select **A2**) 3. Press the shortcut keys: Alt + W + F + F The top row is now frozen and will remain visible when you scroll down.     B.   Freeze First Column    Steps: 1. Select any cell in  Column B 2. Press: Alt + W + F + C The first column will stay visible while scrolling horizontally.     C. Freeze Rows and Columns Together   To freeze  both headings and side columns: Example:   * Headings in Row 1 * Labels in Column A Steps: 1. Select cell  B2 2. Press: Al...
Post a Comment
Read more

Advanced Excel Tips and Tricks

Image
#   15 Advanced Excel Tips and Tricks for Power Users   ##   1. Use Dynamic Arrays (FILTER, SORT, UNIQUE) Excel 365 introduces **dynamic array functions**: * `=UNIQUE(A2:A50)` → Removes duplicates. * `=SORT(A2:A50)` → Sorts data instantly. * `=FILTER(A2:B100, B2:B100="Completed")` → Filters data without complex formulas.   ## 2. Master VLOOKUP with Approximate Match Instead of exact matches, use: `=VLOOKUP(lookup_value, table_array, col_index_num, TRUE)` Great for tax slabs, commissions, or price ranges. ## 3. Switch to XLOOKUP (Better than VLOOKUP) `=XLOOKUP(value, lookup_array, return_array, "Not Found")` ✅ No column index issue. ✅ Can search left to right. ✅ Supports exact or approximate matches.   ##   4. Combine Data with Power Query Use **Data > Get & Transform (Power Query)** to:   * Merge multiple sheets/files. * Clean messy data (remove blanks, split columns). * Automate refresh of repo...
Post a Comment
Read more

150 Essential Computer Shortcuts

Image
    150 Essential Computer Shortcuts     1. General Shortcuts (Works in Most Apps) 1. Ctrl + C → Copy 2. Ctrl + X → Cut 3. Ctrl + V → Paste 4. Ctrl + Z → Undo 5. Ctrl + Y → Redo 6. Ctrl + A → Select All 7. Ctrl + S → Save 8. Ctrl + P → Print 9. Ctrl + N → New Document/Window 10. Ctrl + O → Open File 11. Ctrl + W → Close Window 12. Ctrl + F → Find 13. Ctrl + H → Replace 14. Alt + Tab → Switch Applications 15. Alt + F4 → Close Program     2. File Explorer (Windows) / Finder (Mac)   16. Ctrl + N → New Window 17. Ctrl + Shift + N → New Folder 18. Alt + Enter → File Properties 19. F2 → Rename File 20. Delete → Move to Recycle Bin 21. Shift + Delete → Permanent Delete 22. Ctrl + D → Delete Selected File (Mac: Cmd + Delete) 23. Ctrl + E → Quick Search 24. Alt + Up Arrow → Go Up Folder 25. Alt + Left Arrow → Back 26. Alt + Right Arrow → Forward 27. Ctrl + Mouse Scroll → Resize Icons 28. F5 → Refresh 29. Home → Go to Top of Folder 30. End → Go to Bottom of Fold...
Post a Comment
Read more

MAKING A WORD FILE READ ONLY

Image
 
Post a Comment
Read more

how to change horizontal table to vertical table

Image
 
Post a Comment
Read more

How to Make a Word File Read-Only and Password Protected (Restrict Editing)

Image
  1. Making a Word File Customized Read-Only/password protect/restrict editing. A Word document can be made "read-only" using different methods. The document will then allow users to view it but prevent editing unless explicitly allowed. Below are the common ways to do this: Method 1: Protecting Document Using Password This prevents unauthorized editing by asking for a password to make changes. Steps: Open the Word document. Go to the File tab. Click Info/ prepare tab in the left sidebar. Click on Protect Document/encrypt documents . Choose Encrypt with Password . Set a password and confirm it. Save the document. Now, users need the password to edit it.   Method 2: Restricting Editing You can restrict editing in a Word file by allowing only specific types of changes, such as filling in forms. Steps: Open the Word document. Go to the Review tab. Click on Restrict formatting and Editing in the Protect sectio...
Post a Comment
Read more

AUTO BORDER IN EXCEL

Image
1. Quick Auto Border for Entire Table To quickly add borders to an entire table or selection, use the Format as Table option: Select the range of cells you want to format. Go to the Home tab on the ribbon. Click on Format as Table and choose a style. This automatically applies borders around your data, giving your table a clean, organized look. You can adjust the colour or style of the border if needed. 2. Using Conditional Formatting for Borders Excel’s Conditional Formatting tool lets you apply borders based on specific conditions, which is great for automatically highlighting certain data: Select the cells you want to format. Go to Home > Conditional Formatting > New Rule . Choose a rule (e.g., cells greater than a specific value). Under the Format button, click on Borders and choose your desired border style. The borders will automatically adjust based on the rule you've set. 3. Auto Borders with ...
Post a Comment
Read more