May 8, 2017

Name cells in Excel for easy configuring multiple formula - save yourself from complexity !

Excel has a very useful feature of naming the cells - It helps you not reference the cell nos like C6:D9 but just reference to the name i.e. FractionAbsorbed. Its simple to do, just select the cells that you want to name and with cells selected go to name box (left of the formula bar) and type the desired name. Name box and the cells named are highlighted in green colour.

Now, if the sheet is large and you have named many cells, just select the cells - where you want to print the entire name and the cells named and press F3. Select Paste List and voila ! It prints the entire named cells list...

No comments:

Post a Comment