Excel Pro Tips
How to Split Excel Sheets into Multiple Files (3 Suitable Ways)
Learn how to split Excel sheets into multiple files using VBA, Power Query, or manual methods like Filter and Save As for data management.
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 Find the Last Cell with Value in a Row in Excel
Learn how to find the last cell with value in a row in Excel using LOOKUP, INDEX, MAX, XLOOKUP, and VBA for accurate data tracking.
Read article
Excel Pro Tips
How to Keep Header in Excel When Printing (2 Quick Methods)
Learn how to keep the header row visible when printing in Excel using Print Titles, Page Setup, and tips for on-screen viewing.
Read article
Excel Pro Tips
How to Insert Page Break in Excel Between Rows (5 Easy Ways)
Learn how to insert page breaks in Excel between rows manually, with VBA, using subtotals, and how to remove them for better print layout.
Read article
Excel Pro Tips
How to Enable Share Workbook in Excel (with Custom Sharing)
Learn how to enable sharing workbooks in Excel, manage user access, compare changes, and use OneDrive for modern co-authoring seamlessly.
Read article
Excel Pro Tips
How to See Who Made Changes in Excel (5 Suitable Ways)
Learn how to see who made changes in Excel using version history, co-authoring, legacy track changes, and VBA for audit trails.
Read article
Excel Pro Tips
How to Compare Two Excel Sheets and Highlight Differences
Easily compare two Excel sheets and highlight differences using built-in features, formulas, or VBA for accurate data analysis.
Read article
Excel Pro Tips
How to Add Data Bars in Excel (with Customizations)
Learn how to add data bars in Excel using conditional formatting, customize them, and apply them to pivot tables and formulas.
Read article
Excel Pro Tips
Excel Conditional Formatting to Compare Two Columns
Learn how to use conditional formatting in Excel to compare two columns and highlight matching or unique values easily.
Read article
Excel Pro Tips
How to Make Excel Table Automatically Add New Row
Learn how to make Excel tables automatically add new rows using table features, structured references, and dynamic named ranges.
Read article
Excel Pro Tips
How to Link Text Box to Cell in Excel (2 Easy Methods)
Learn how to link a text box to a cell in Excel for dynamic content, including using the formula bar and creating dynamic dashboard titles.
Read article
Excel Pro Tips
How to Reverse Names in Excel (3 Quick Methods)
Learn how to reverse names in Excel using text functions, Flash Fill, or Text to Columns and concatenate for easy “Last, First” formatting.
Read article