-
Notifications
You must be signed in to change notification settings - Fork 56
Tips & Tricks
A collection of helpful tips and tricks.
You probably know that you can press F3 while entering a formula to select from a list of names or @functions. You might not know that if you press F3F3 instead, a fullscreen list is displayed. This screen is much easier to navigate if you have large number of names.
Did you know that while in POINT mode you can transfer the cursor to another corner using .? This useful trick lets you easily reshape a range without starting over!
When writing macros, you often want to skip n rows or columns ahead. Rather than {L}{L}{L}{L} You can write {L 4} to move left 4 columns. This works for most keys.
You might not know that the count can be a cell (e.g. A:A34), named range, or an expression (e.g. @COUNT(A1..A8192)) too!
You can enter comments to remind yourself how a complicated formula works, or where magic values come from. Just use the ; operator.
@INDEX($A$1..$IV$1,@COUNT($A$1..$IV$1)-1,0); The last occupied cell of A1..IV1
0.0523; County Sales Tax
If you're a 123 expert, try these puzzles, or this adventure game!
If you're several levels deep in a menu, returning to READY mode can require hitting Esc quite a few times.
In most cases, you can just hit Ctrl+c instead to return to READY mode immediately.