Griddy Blog
Practical spreadsheet notes.
Guides for formulas, cleanup, charts, and the spreadsheet work people actually get stuck on.
Page 3 of 11 · 128 posts
How to Merge Cells in Excel
Merge cells in Excel when a title or section header needs to span columns. Learn when to merge, when not to, and safer alternatives for working sheets.
How to Transpose Data in Excel
Transpose data in Excel to switch rows into columns or columns into rows. Learn paste transpose, TRANSPOSE formulas, and when each method works best.
How to Use Find and Replace in Excel
Find and Replace in Excel can clean labels, update terms, and fix repeated values quickly. Learn safe options before changing hundreds of cells.
Google Sheets Conditional Formatting
Use Google Sheets conditional formatting to highlight statuses, overdue dates, duplicates, thresholds, and rows that need review.
Google Sheets COUNTIF
Use Google Sheets COUNTIF to count rows that match one condition, including statuses, categories, text, dates, and numeric thresholds.
Google Sheets Date Formulas
Use Google Sheets date formulas like TODAY, EDATE, EOMONTH, WORKDAY, and NETWORKDAYS for timelines, budgets, and schedules.
Google Sheets Remove Duplicates
Remove duplicates in Google Sheets with the built-in cleanup tool, UNIQUE formulas, and safer review steps for shared data.
How to Use XLOOKUP in Google Sheets
Use XLOOKUP in Google Sheets to return matching values from any direction, handle missing results, and avoid fragile VLOOKUP column indexes.
Budget Tracker vs Savings Tracker
A budget tracker controls monthly spending, while a savings tracker follows progress toward specific goals. Use both when planning and follow-through matter.
Google Sheets Dropdown List
Create a Google Sheets dropdown list with data validation, custom options, colors, ranges, and cleaner status fields for shared spreadsheets.
How to Build a Student Budget in a Spreadsheet
Create a student budget spreadsheet that separates income, fixed costs, flexible spending, school expenses, and savings.
Student Budget Planner Excel
Build a student budget planner in Excel that tracks income, rent, books, food, subscriptions, savings, and weekly spending room.