
This simple trick will save you so much time in Excel. On this sheet, I have my net worth in cell B3. In the top-left corner in the name box, I can give this cell a name. I’ll call it networth. Now I can go to a new sheet, and I’ll enter =networth, and there’s that value. On the top tabs, click on formulas and then name manager, and here I can see all the different names that I’ve used.