Display zero values as blanks on a calc spreadsheet
Most people know that you can set all of the values on a sheet to display blank if the value is the number zero. This can be annoying on some sheets where you want certain columns to show the zeros and others to be blank if the value is zero. There is an easy fix for this.
You can usually work on a live website without preventing visitors from accessing it. They might see the odd menu item appear or disappear or an image move etc. but these things are rarely a concern.