Google Sheets Functions
How to Check If a Cell is Not Empty in Google Sheets (7 Methods)
Learn how to check if a cell is not empty in Google Sheets using IF, ISBLANK, COUNTA, LEN functions, conditional formatting & Apps Script.
Read article
Author & Spreadsheet Consultant
Mashrur Ibne Shams
45 Articles PublishedPublishing since
Mashrur Ibne Shams holds a BSc in Industrial and Production Engineering and is a Certified Supply Chain Analyst (CSCA). With 3 years of Excel and Google Sheets experience, he specializes in data cleaning, text extraction, advanced formulas, dynamic arrays, VBA automation, and Power Query. He has created step-by-step tutorials and custom VBA scripts for real-world datasets. He enjoys simplifying complex tasks, automating processes, and organizing data efficiently.
Editorial Review
Articles Published by Mashrur Ibne Shams
Articles by Mashrur Ibne Shams 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.
Google Sheets Basics
How to Remove Gridlines from Specific Cells in Google Sheets
Discover how to remove gridlines from specific cells in Google Sheets using custom borders, Apps Script, and main menu options.
Read article
Google Sheets Basics
How to Tag Someone in Google Sheets (4 Simple Ways)
Learn how to tag someone in Google Sheets using comment box, main menu, context menu, and smart chips to collaborate efficiently.
Read article
Google Sheets Basics
How to Split Screen in Google Sheets (4 Suitable Ways)
Learn how to split screen in Google Sheets by using multiple browser windows, extensions, or freezing rows and columns for easier navigation.
Read article
Google Sheets Basics
Copy Formula in Google Sheets Without Changing Reference
Learn how to copy formula in Google Sheets without changing references using absolute references, Find and Replace, plain text & ARRAYFORMULA.
Read article
Google Sheets Functions
How to Transpose Rows to Columns in Google Sheets (4 Ways)
Learn how to transpose rows to columns in Google Sheets using Paste Special, the TRANSPOSE function, Apps Script, or every N rows method.
Read article
Google Sheets Basics
How to Auto Sort in Google Sheets (3 Suitable Ways)
Learn how to auto sort in Google Sheets using the SORT function, combining SORT with ARRAYFORMULA, or automating sorting with Apps Script.
Read article
Excel Functions & Formulas
Excel VLOOKUP to Auto-Transfer Data Between Excel Sheets
Learn how to transfer data between Excel worksheets automatically using VLOOKUP, XLOOKUP, or INDEX-MATCH for flexible and accurate lookups.
Read article
Excel Functions & Formulas
Vlookup from Multiple Columns with Only One Return in Excel
Learn how to VLOOKUP from multiple columns in Excel with one return using a helper column, XLOOKUP, or the INDEX-MATCH formula.
Read article
Excel Pro Tips
How to Add Minutes and Seconds in Excel (4 Suitable Ways)
Learn how to add minutes and seconds in Excel using the plus operator, SUM, TEXT, or TIME functions for accurate time calculations.
Read article
Excel Pro Tips
How to Calculate Hours and Minutes in Excel (3 Simple Formulas)
Learn how to calculate hours and minutes in Excel using simple subtraction, the TEXT function, or INT and MOD for separate time values.
Read article
Excel Pro Tips
How to Round Numbers in Excel Without Formula (4 Quick Tricks)
Learn how to round numbers in Excel without formulas using Format Cells, Decrease Decimal, Number Format dropdown, or Power Query tools.
Read article