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.