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…

SAVE TIME AND FRUSTRATION IN JUST A FEW MINUTES

Subcribe to my weekly email newsletter and download 5 QUICK EXCEL TIPS right now!

You have Successfully Subscribed!