how to figure out that worksheet is set to Manual Calculation mode

true, martin, certain things would have become such a part of daily routine that we become dispassionate towards them (thus relegating them from the mantle of 'trick' or 'tip', they are just blase 'functions'). feels foolish to even huckster them as 'tips' any more!

for e.g., highlighting a certain number of rows (or columns), then right-clicking and selecting Insert, inserts the exact number of fresh new rows (or columns) as those selected - now that may not be much of a tip in my book, as i have been using it for over a decade, but the other day someone 'repped' me for offering that trick.

i guess after a few months / years of utilising this 'Calculate' tip, it will attain the same status as the ones that came before it.