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.
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.
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 do a stocktake in Google Sheets and know what to reorder Read More »
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.
How to hide multiple sheets in Google Sheets at once (and unhide them) Read More »
