Few people ever use the Name Box, but it can save you a lot of time. You can assign names to single cells and ranges of cells, allowing you to refer to and navigate to those cells easily, even if they get moved around in a worksheet.

Recommended
 The Filter tool is really powerful for working with…