Google Sheets Basics
How to Insert a Text Box in Google Sheets (with Simple Steps)
Learn how to insert a text box in Google Sheets using the Drawing tool, and easily edit or move it for better layout and presentation.
Read article
Google Sheets Basics
73 articles
Google Sheets Basics
How to Sort Columns in Google Sheets without Mixing Data
Learn how to sort columns in Google Sheets without mixing data using Sort Range, SORT function, QUERY, filters, and Apps Script.
Read article
Google Sheets Basics
How to Remove Hyperlinks in Google Sheets (5 Easy Ways)
Learn how to remove hyperlinks in Google Sheets using the context menu, link preview, formulas, paste special, or Apps Script.
Read article
Google Sheets Basics
How to Change Negative Numbers to Positive in Google Sheets
Learn how to change negative numbers to positive in Google Sheets using ABS, IF, -1 multiplication, ARRAYFORMULA, Find and Replace.
Read article
Google Sheets Basics
How to Sort Rows by Column Value in Google Sheets (3 Ways)
Learn how to sort rows by column value in Google Sheets using the Data menu, SORT function, or QUERY function for dynamic sorting.
Read article
![[Fixed] Date Format Not Working in Google Sheets](https://pub-b39c974f4c124a36a2fb517be38076ec.r2.dev/images/2026/08/featured-image-google-sheets-date-format-not-working-fcc5ddbe.webp)
Google Sheets Basics
[Fixed] Date Format Not Working in Google Sheets
Fix date formatting issues in Google Sheets by confirming dates, correcting text issues, removing quotes, and using DATEVALUE and SUBSTITUTE.
Read article
Google Sheets Basics
How to Do Spell Check in Google Sheets: Step-by-Step Guide
Learn how to do spell check in Google Sheets using keyboard shortcuts, menu options, and understand its spell check features easily.
Read article
Google Sheets Basics
How to Insert Special Characters in Google Sheets
Learn how to insert special characters in Google Sheets using Google Docs, extensions, internet searches, and handy keyboard shortcuts.
Read article
Google Sheets Basics
How to Convert Text to Date in Google Sheets (4 Easy Methods)
Learn how to convert text to date in Google Sheets using DATE, TO_DATE, ARRAYFORMULA, and DATEVALUE functions for quick formatting.
Read article
Google Sheets Basics
How to Find Last Row with Data in Google Sheets (3 Easy Ways)
Discover how to find the last row with data in Google Sheets using ARRAYFORMULA, FILTER, INDEX, and MAX for dynamic data handling.
Read article
Google Sheets Basics
How to Format Numbers as Millions in Google Sheets
Learn how to format numbers as millions in Google Sheets with custom formats, helper columns, and the TEXT function.
Read article
Google Sheets Basics
How to Hide Columns in Google Sheets from Certain Users
Learn how to hide columns in Google Sheets from certain users using QUERY, IMPORTRANGE, Filter functions & more!
Read article