Excel Pro Tips
How to Copy Comments in Excel (4 Different Ways)
If you copy a cell with a comment or note from one cell to another in the traditional way (using CTRL + C and CTRL + V), you transfer the
Sohana Chowdhury
October 22, 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 Protect Specific Cells in Excel (5 Suitable Ways)
Protecting specific Excel cells from editing prevents unwanted changes, deletions, and data loss. By default, all cells in Excel are set as Locked. However, locking has no effect until you
Sohana Chowdhury
September 30, 2025
Excel Pro Tips
Difference Between Sort and Filter in Excel (with Examples)
Both sorting and filtering help you arrange a large database according to specific criteria. While both functions help in organizing data, they serve different purposes. Sorting helps you alphabetize, rank
Sohana Chowdhury
September 28, 2025
Excel Pro Tips
How to Find and Highlight Blank Cells in Excel (7 Easy Ways)
Marking the blank cells in your worksheet helps you avoid issues with data analysis, project tracking, spotting errors, and accidentally removing data. While there are many static and dynamic ways
Sohana Chowdhury
September 26, 2025
Excel Pro Tips
How to Set a Cell to Blank in a Formula in Excel (6 Approaches)
When a formula returns an error, zero, or negative numbers, you might want to replace it with a blank instead for a cleaner look. Although Excel doesn’t allow a formula
Sohana Chowdhury
September 26, 2025
Excel Pro Tips
How to Delete Empty Rows at the Bottom in Excel (5 Simple Ways)
Unused empty rows at the bottom of your Excel sheet can interrupt critical activities like data processing, formula application, pivot table formatting, etc. Unfortunately, Excel doesn’t allow you to truly
Sohana Chowdhury
September 26, 2025
Excel Pro Tips
How to Remove Metadata from Excel File (6 Quick Methods)
In an Excel file, Metadata often contains personal and sensitive information about the authors, their devices, company names, shared links, titles & tags, external data connections, and people who edited
Sohana Chowdhury
September 25, 2025
Advanced Excel
How to Use INDEX MATCH Across Multiple Sheets in Excel
Often, we work with business or academic data spread across multiple worksheets and need to find certain information from these datasets. However, most of the time, using basic lookup formulas
Sohana Chowdhury
September 5, 2025
Excel Pro Tips
How to Calculate Win-Loss Percentage in Excel (5 Easy Ways)
To calculate win-loss percentage in Excel, you need to put the number of wins and losses for a team in two separate columns. Based on this data, we can use
Sohana Chowdhury
August 4, 2025