Select a Spill Range

The Ctrl + A shortcut has been around for a long time and over the years it’s functionality has expanded.

The latest addition to it’s abilities is selecting a spill range.

Select any cell in a spill range and press Ctr + A and it will only select the current spill range.

This can be useful for formatting as the format doesn’t spill.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.