The Sheet Wizard Blog
Plain-English guides to Google Sheets, Apps Script and running a tighter shop with both.
-
Why your dependent dropdown in Google Sheets breaks when you add a row (and how to stop it)
A dependent dropdown in Google Sheets goes blank the moment someone inserts a row, because the rule travels and the helper formula does not. Built, broken and fixed live, with three ways to stop it.
-
How to delete multiple sheets in Google Sheets at once (and get them back if you need to)
Google Sheets can delete multiple sheets in one go, and Ctrl+Z brings them all back if you are quick. What deleting does to your formulas, three ways to recover a deleted sheet, and a way to delete with a preview and a backup.
-
How to do a stocktake in Google Sheets and know what to reorder
A stocktake is only worth doing if it tells you what you have, what went missing and what to order. The counting rules, the formulas, and a shortcut add-on.
-
How to hide multiple sheets in Google Sheets at once (and unhide them)
You can hide multiple sheets in Google Sheets in one click, but unhiding them is still one at a time. Three ways to bring them all back, including a free add-on.