Google Sheets Basics
How to Convert Timestamp to Date in Google Sheets
Learn how to convert timestamps to dates in Google Sheets using INT, TO_DATE, TEXT, SPLIT functions, or by formatting cells directly.
Read article
Google Sheets Basics
73 articles
Google Sheets Basics
How to Find Merged Cells in Google Sheets (3 Simple Tricks)
Learn how to find merged cells in Google Sheets using Apps Script, filters, and quick tips to identify and list merged cells easily.
Read article
Google Sheets Basics
How to Use Custom Number Formats in Google Sheets
Learn how to use custom number formats in Google Sheets to add leading zeros, currency, units, abbreviations, and highlight negative numbers.
Read article
Google Sheets Basics
How to Go to the Next Line in Google Sheets in the Same Cell
Learn how to go to the next line in the same Google Sheets cell using shortcuts, CHAR(10), Excel import, or Apps Script.
Read article
Google Sheets Basics
How to Autofill Cells in Google Sheets Based on Another Column
Learn how to autofill cells in Google Sheets based on another column using VLOOKUP, ARRAYFORMULA, IF statements, or custom Apps Script rules.
Read article
Google Sheets Basics
How to Autofill Date When a Cell Is Updated in Google Sheets
Autofill date in Google Sheets when a cell is updated using Apps Script or checkbox triggers with automatic timestamping options.
Read article
Google Sheets Basics
How to Extract a URL from a Hyperlink in Google Sheets
Extract URLs from hyperlinks in Google Sheets using REGEXEXTRACT formulas or Apps Script for both formula-based and manually added links.
Read article
Google Sheets Basics
How to Search for Text in a Range in Google Sheets
Learn how to search text in a range in Google Sheets using COUNTIF, FILTER, SEARCH, conditional formatting, and the Find tool.
Read article
Google Sheets Basics
How to Sort by Date in Google Sheets (4 Easy Methods)
Learn how to sort by date in Google Sheets using Sort Range, SORT, Filter, QUERY functions, and fix common date sorting issues.
Read article
Google Sheets Basics
How to Share Only One Tab in Google Sheets (4 Easy Ways)
Learn how to share only one tab in Google Sheets by hiding other tabs, using Protect Sheet, creating a new file, or publishing to the web.
Read article
Google Sheets Basics
How to Autofill in Google Sheets Without Dragging (4 Quick Tricks)
Learn how to autofill in Google Sheets without dragging using keyboard shortcuts, the suggested autofill box, or the Fill Down feature.
Read article
Google Sheets Basics
How to Remove Time from Date in Google Sheets (6 Easy Ways)
Learn how to remove time from date in Google Sheets using formatting, text splitting, rounding, or the DATE function.
Read article