Tips & Tricks

A collection of helpful tips and tricks.

Navigating Named Ranges

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.

Repeating Keys

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, but it doesn't have to be a constant - the count can be a cell (e.g. A:A34) or named range too!

Expert Puzzles

If you're a 123 expert, try these puzzles.