Excel Pro Tips
How to Fix Issues with Date Filter in Excel (6 Possible Solutions)
Fix Excel date filter not working with proven steps: enable group dates, convert text to dates, remove blanks, unmerge, unprotect sheets.
Read article
Author & Spreadsheet Consultant
Shihab Shahriar
88 Articles PublishedPublishing since
Md. Shihab Uddin holds a Graduation in Crop Science and Technology and is pursuing a Postgraduate degree in Soil Science from the University of Rajshahi. With 4+ years of Excel and Google Sheets experience, he specializes in formulas, data cleaning, lookups, automation, VBA, formatting, and file management. He has authored 100+ in-depth Excel articles and is skilled in Power Automate, RPA, and Python. He enjoys creating efficient workflows and solving real-world data problems.
Editorial Review
Articles Published by Shihab Shahriar
Articles by Shihab Shahriar 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 Filter Dates by Month and Year in Excel
Learn to filter dates by month and year in Excel with the Filter tool, FILTER function, PivotTable, and custom filter buttons fast.
Read article
Excel Pro Tips
How to Filter by Multiple Colors in Excel (2 Suitable Ways)
Learn how to filter by multiple colors in Excel using color codes and VBA macros for faster more accurate data analysis step-by-step guide.
Read article
Excel Pro Tips
How to Merge Two Columns in Excel with a Space (4 Easy Ways)
Learn how to merge two columns in Excel with a space using &, CONCAT, TEXTJOIN, and Flash Fill step-by-step examples for quick results.
Read article
Excel Pro Tips
How to Combine Multiple Worksheets into One Workbook in Excel
Learn how to combine multiple worksheets into one workbook in Excel using Power Query, Consolidate, Move/Copy, and VBA methods step by step.
Read article
Excel Pro Tips
How to Convert Old Excel Files to a New Format (2 Suitable Ways)
Learn how to convert old Excel files to a new format using Save As or VBA macros with simple, step-by-step instructions.
Read article
Excel Pro Tips
How to Remove 'Last Modified By' Property in Excel
Learn how to remove the “Last Modified By” property in Excel using Inspect Document, File Properties, and Excel settings in simple steps.
Read article
Excel Pro Tips
How to See Who Is in a Shared Excel File (2 Quick Ways)
Learn how to see who is in a shared Excel file using the Share panel, Version History, and Manage Access tools step by step with easy tips.
Read article
Excel Pro Tips
How to Set Permissions for a Shared Excel File
Learn how to set permissions for shared Excel files—limit edits, encrypt with passwords, and manage access in OneDrive easily.
Read article
![[Fixed] Excel Not Highlighting Cells in Formula](https://pub-b39c974f4c124a36a2fb517be38076ec.r2.dev/images/2026/08/featured-image-excel-not-highlighting-cells-in-formula-ce84ffe8.webp)
Excel Pro Tips
[Fixed] Excel Not Highlighting Cells in Formula
Fix Excel not highlighting cells in formulas with easy methods—enable editing in cells, use VBA, repair Office, or check F2 settings.
Read article
Excel Pro Tips
Conditional Formatting for Dates Older Than Today in Excel
Learn how to highlight dates older than today in Excel using the TODAY function or a VBA macro for automatic formatting.
Read article
Excel Pro Tips
How to Copy Hyperlinks in Excel (3 Easy Ways)
Learn how to copy hyperlinks in Excel using keyboard shortcuts, the Edit Hyperlink window, and converting URLs to clickable links.
Read article