Usefull Excel Trick!!! Easy to Advance!! Keep this going!!

[yytsunamiyy]

N(“AnyText”) is used just as a formula comment and does not change the sum as equally to zero

OK. I got the point now. Thanks for clarifying that. I was led astray by VoG's

...but not the result.

 

[arkusM]

Pressing Alt + ; will select visible cells only. Saves you having to press F5, click special etc.

Ahhha, I have been try to remember that one (yes too lazy to look it up, not a high priority LOL)

I like:
CTRL+D ~ duplicates the cell(s) above formula and all
ALT + Dwn Arrow ~ drop down of previously entered values for the column (in continuous data, mostly seems quirk sometimes). Behaves like a ComboBox

EDIT: This seems almost like the favorite Short-Cuts thread....