Excel Pro Tips
How to Undo Changes in Excel after Save and Close
Once you save a file and close your Excel window, the Undo (CTRL + Z) or Redo (CTRL + Y) shortcut can’t reverse the changes you made. If you don’t
Sohana Chowdhury
August 3, 2025
Author
Sohana Chowdhury
Sohana Chowdhury has 3 years of experience with Excel and Google Sheets, specializing in data cleaning, formatting, basic formulas, logical functions, Power Query, and VBA coding. She has created organized tracking sheets for records and reporting, utilizing lookup formulas, conditional formatting, and data validation. Sohana is passionate about designing problem-specific formulas and leveraging VBA to optimize spreadsheet tasks.
Articles Published by Sohana Chowdhury
Read More »
Excel Pro Tips
How to Add a Comma Between Names in Excel (8 Different Ways)
You may have a list of names in the same cell, or different columns/rows, and want to add a comma between the names in just a few clicks. Excel allows
Sohana Chowdhury
August 2, 2025
Excel Pro Tips
How to Randomize a List of Names in Excel (6 Quick Methods)
With a randomized list of names, you can do team grouping, customer research, surveys, and more. Although Excel has no direct built-in functions or add-ins to randomize names, it has
Sohana Chowdhury
August 2, 2025
Excel Pro Tips
How to Randomly Select from a List in Excel (5 Useful Ways)
Random or unbiased selection from a list of names, numbers, or dates is useful for surveys, data analysis, market research, etc. Excel doesn’t have any built-in feature or direct formula
Sohana Chowdhury
August 2, 2025
Excel Pro Tips
How to Return Multiple Values Based on Single Criteria in Excel
Common lookup functions like VLOOKUP or MATCH usually return a single result for a given lookup value. However, sometimes we need to find all the matched values from a selected
Sohana Chowdhury
August 1, 2025
Excel Pro Tips
How to Return Row Number of Match in Excel (8 Suitable Ways)
only the largest/first or smallest/last occurrence of a match, you need a formula with the MAX or SMALL function. With the MAX function, Excel returns the largest value from a set of n To apply various
Sohana Chowdhury
August 1, 2025
Excel Pro Tips
Excel Conditional Formatting Based on Another Cell Range
In Excel, applying conditional formatting based on another cell range means we format our selected cells using the values from other cells. During the process, you must use a suitable
Sohana Chowdhury
July 13, 2025
Excel Pro Tips
How to Flip a Table in Excel (8 Suitable Ways)
Flipping a table in Excel mostly refers to two things: reversing the data order upside down or swapping columns and rows. Excel doesn’t offer direct functions or features for either,
Sohana Chowdhury
July 12, 2025
Excel Pro Tips
How to Sort a Drop Down in Excel (5 Useful Techniques)
Adding a sorted drop-down on the column heading makes repetitive entries faster and reduces human errors. To sort a drop-down in Excel, you can use the Data Validation tool. To
Sohana Chowdhury
July 12, 2025