Excel Pro Tips
How to Sort by Column in Excel But Keep Rows Together
Learn how to sort data by column in Excel while keeping rows intact using table format, SORT function, custom lists, and helper columns.
Read article
Author & Spreadsheet Consultant
Tasmia Rahim
268 Articles PublishedPublishing since
Tasmia Rahim holds a B.Sc in Electrical Engineering with a focus on automation and embedded systems, supporting logic-driven spreadsheet workflows. With 2 years of Excel and Google Sheets experience, she works with conditional formatting and basic automation. She is interested in using macros and ActiveX controls to simplify Excel tasks and improve usability.
Editorial Review
Articles Published by Tasmia Rahim
Articles by Tasmia Rahim are developed under the guidance of ExcelInsider’s core training program and are technically reviewed by Nehad Ulfat, lead spreadsheet consultant, to ensure accuracy and user-centric value.
Excel Pro Tips
How to Return a Value If a Cell Is Blank in Excel (6 Cases)
Learn how to return a custom value if a cell is blank in Excel using IF, ISBLANK, LEN, COUNTBLANK, and other logical functions.
Read article
Excel Pro Tips
How to Change Compatibility Mode in Excel (3 Simple Ways)
Learn what Compatibility Mode is in Excel and how to convert files to modern formats to remove compatibility prompts and improve performance.
Read article
Excel Pro Tips
How to Find Last Occurrence of a Value in a Column in Excel
Discover how to find the last occurrence of a value in an Excel column using LOOKUP, INDEX-MAX, XLOOKUP, or VBA methods easily.
Read article
Advanced Excel
How to Convert Address to Lat Long in Excel (2 Quick Ways)
Learn how to convert addresses to latitude and longitude in Excel using the Geography data type and VBA code for precise results.
Read article
Advanced Excel
How to Convert Lat Long to UTM in Excel (2 Suitable Ways)
Learn how to convert latitude and longitude to UTM coordinates in Excel using VBA code, including Easting and Northing values accurately.
Read article
Advanced Excel
How to Calculate Weighted Moving Average in Excel
Learn how to calculate weighted moving average in Excel using SUMPRODUCT, helper columns, and the Data Analysis Toolpak for simple averages.
Read article
Excel Pro Tips
How to Unprotect Excel Workbook Without Password
Learn how to unprotect an Excel workbook without a password using VBA, editing XML files, copying data, or saving as an older XLS format.
Read article
Excel Pro Tips
How to Alternate Row Colors in Excel Without Table
Learn how to alternate row colors in Excel without using a table by applying conditional formatting or custom Nth-row formulas.
Read article
Excel Pro Tips
Highlight a Cell in Excel if Value Is Greater Than Another Cell
Learn how to highlight a cell in Excel if its value is greater than another cell using conditional formatting, formulas, and built-in rules.
Read article
Excel Pro Tips
How to Flip Data Vertically in Excel (4 Quick Tricks)
Learn how to flip data vertically in Excel using helper columns, SORTBY function, Power Query, or VBA macros for data transformation.
Read article
Excel Pro Tips
How to Sort Merged Cells in Excel (3 Suitable Methods)
Learn how to sort merged cells in Excel by unmerging temporarily, using helper columns, or applying "Center Across Selection" for sorting.
Read article