Tip #3 - Cell selection & inversion

When selecting a large number of cells, typically you click on the first cell in the column and drag down to the end. You will notice the first box is outlined in red. Enter your value, or range and everything is cool top to bottom.

But if you want to invert that selection from the very start simply select the first cell, hold down PIG + down arrow to the bottom. You will notice that the last cell is outlined red. Your selection is now inverted from the start.

Yes you can click from the bottom and drag up as well. I like to use the different methods depending on how I want my selection ordered.
Related