Excel Pro Tips
How to Remove Last 3 Characters in Excel (4 Easy Methods)
Learn how to remove the last 3 characters in Excel using LEFT & LEN, REPLACE, Flash Fill, or a custom VBA function for clean text format.
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 Lookup Partial Text Match in Excel (3 Suitable Examples)
Learn how to look up partial text matches in Excel using VLOOKUP with wildcards, INDEX & MATCH combo, and IF for conditional results.
Read article
Excel Pro Tips
How to Use Percentage Formula in Excel for Marksheet
Learn how to use percentage formulas in Excel for marksheets by calculating percentages, applying percent style, and finding obtained marks.
Read article
Excel Pro Tips
How to Paste Range Names in Excel (3 Simple Tricks)
Learn how to paste range names in Excel using the Formulas tab, keyboard shortcuts, and how to insert range names into formulas efficiently.
Read article
Excel Pro Tips
How to Return Only Value of Cell (Not Formula) in Excel
Learn how to return the value of a cell instead of the formula in Excel using Paste Special, F9 shortcut, Replace tool and others.
Read article
Excel Pro Tips
How to Enable Iterative Calculation in Excel (for All Versions)
Learn how to enable iterative calculation in Excel across all versions and use it for datasets, loan estimates, and solving equations.
Read article
Excel Pro Tips
How to Reference Cell by Row and Column Number in Excel
Learn how to reference cells by row and column number in Excel using ROW, COLUMN, ADDRESS, INDIRECT, INDEX, and R1C1-style formulas.
Read article
Excel Pro Tips
How to Trace Dependents in Excel (4 Suitable Methods)
Learn how to trace dependents in Excel using the built-in feature, keyboard shortcuts, multiple trace clicks, and VBA macros.
Read article
Excel Pro Tips
How to Insert Multiple Bullet Points in an Excel Cell
Learn how to insert multiple bullet points in an Excel cell using Alt+7, symbols with line breaks, CHAR(149), or by copying from Word.
Read article
Excel Pro Tips
How to Insert Multiple Page Breaks in Excel (4 Easy Tricks)
Learn how to insert multiple page breaks in Excel manually, using context menus, VBA macros, or the Subtotal feature for grouped data.
Read article
Excel Pro Tips
How to Compress Excel File for Email (6 Effective Ways)
Learn how to compress Excel files for email using ZIP, .xlsb format, online tools, picture compression, and by removing unused content.
Read article
Excel Pro Tips
How to Add Sort Button in Excel (4 Quick Methods)
Learn how to add a sort button in Excel using filters, keyboard shortcuts, VBA macros, and the built-in Sort feature on the Data tab.
Read article