🚀 go-pugleaf

I only use Quattro for my own work, so my "dummy-proofing" is of a very
personal variety!  However, the following has worked well for me:

To protect the top and bottom of a COLUMN range, I simply add a cell
to the top and bottom, include those cells in the range, and
(optionally) insert something in them that the numeric functions will
ignore (like a label).  Then I protect just the two "guard cells".  I
end up with something like this:


              1      2      3
         A        -------
         B          1.2
         C          3.4
         D          5.6
         E        -------
         F         10.2

Here I would make A2-E2 be the named range. (Say "DATA") I put the
labels "/-" in A2 and in E2, which are protected.  B2-D2 are not
protected, so that they can be erased, deleted, etc.  Cell F2 might
have something like @SUM(DATA), which simply ignores the labels in A2
and E2.

This scheme also makes it easy to add an extra cell to the top or
bottom of the range and have it be included in the range
automatically.

The same scheme should also work for ROW ranges.  If you do this then
you can evey use "Hide Column" to prevent the columns corresponding to
A2 and E2 in the example from showing up.

Hope this helps.