Griddy Blog
Practical spreadsheet notes.
Guides for formulas, cleanup, charts, and the spreadsheet work people actually get stuck on.
Page 2 of 13 · 148 posts
Google Sheets Protect Range
Protect ranges in Google Sheets so formulas, headers, summary sections, and approved inputs do not get changed by accident.
Google Sheets Split Text
Split text in Google Sheets into clean columns for names, addresses, tags, IDs, imported descriptions, and other messy spreadsheet fields.
How to Filter in Google Sheets
Filter in Google Sheets to review rows by status, owner, date, category, amount, or text without changing the underlying spreadsheet.
How to Share Google Sheets
Share Google Sheets safely with the right access level, link settings, comments, protected ranges, and review workflow.
Excel Tips for Beginners
Use these practical Excel tips for cleaner workbooks, safer formulas, better review habits, and fewer spreadsheet mistakes.
How to Convert Text to Number in Excel
Convert text to numbers in Excel so imported amounts, IDs, dates, and totals calculate correctly instead of looking right but behaving wrong.
How to Use Flash Fill in Excel
Use Flash Fill in Excel to split, combine, and clean repeated text patterns without writing formulas for every column.
How to Use Power Query in Excel
Use Power Query in Excel to import, clean, reshape, and refresh messy data without repeating manual spreadsheet cleanup every week.
Google Sheets Concatenate
Use CONCATENATE, ampersands, and TEXTJOIN in Google Sheets to combine names, labels, IDs, addresses, notes, and review text cleanly.
Google Sheets Freeze Rows
Freeze rows in Google Sheets so headers, dates, owner names, and review labels stay visible while you scroll through large spreadsheets.
Google Sheets VLOOKUP From Another Sheet
Use VLOOKUP across tabs in Google Sheets to pull owner, stage, rate, client, or category details from a separate lookup table.
How to Sort in Google Sheets
Sort data in Google Sheets by date, status, owner, amount, or multiple columns without breaking the structure of your working spreadsheet.