Excel Pro Tips
How to Create a Drop-Down List from a Table in Excel
Learn how to create a drop-down list from a table in Excel using dynamic ranges, named ranges, and UNIQUE for auto-updating lists.
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 Create a Drop-Down List from Another Sheet in Excel
Create a drop-down list in Excel from another sheet using direct references, named ranges, tables, dynamic ranges, or unique spill lists.
Read article
Excel Pro Tips
How to Group Similar Items in Excel (8 Quick Tricks)
Group similar items in Excel using sorting, PivotTables, Subtotal, formulas, GROUPBY, or UNIQUE function for organized, summarized data.
Read article
Excel Pro Tips
Transfer Data from One Excel Worksheet to Another Automatically
Automatically transfer data between Excel worksheets using cell references, named ranges, VBA, or Power Query for seamless syncing.
Read article
Excel Pro Tips
How to Reference Another Excel Workbook Without Opening
Reference another Excel workbook without opening it using external references, Power Query, and refreshing links efficiently.
Read article
Excel Pro Tips
How to Extract URL from Hyperlink in Excel (3 Simple Ways)
Learn how to extract URLs from hyperlinks in Excel using VBA, display web addresses in formulas, or manually via the Edit Hyperlink dialog.
Read article
Excel Pro Tips
How to Break Links in Excel and Keep Values (4 Easy Ways)
Learn how to break links in Excel and keep values using copy-paste, Find and Replace, Edit Links dialog, or VBA for clean data.
Read article
Excel Pro Tips
How to Create a Filtering Search Box for Your Excel Data
Create a filtering search box in Excel using FILTER, drop-down AutoFilter, slicers, ActiveX TextBox, and multi-column search formulas.
Read article
Excel Pro Tips
How to Perform a Spelling Check on the Active Worksheet in Excel
Perform a spelling check on the active Excel sheet using F7, VBA, or by targeting specific ranges and formulas for error-free data.
Read article
Excel Pro Tips
How to Convert Multiple Rows to Columns in Excel (4 Methods)
Convert multiple rows to columns in Excel using Paste Special, the TRANSPOSE function, Power Query, or VBA for quick and easy results.
Read article
Excel Pro Tips
How to Create a Searchable Database in Excel (4 Easy Ways)
Create a searchable database in Excel using filters, dynamic search boxes, drop-down lists with VLOOKUP, and conditional formatting.
Read article
Excel Pro Tips
How to Create a Database in Excel That Updates Automatically
Create an auto-updating database in Excel using tables, dynamic ranges, PivotTables, Power Query, and VBA for seamless data updates.
Read article