Wednesday, April 15, 2015

[Excel Tips] - Readable Names for Complex Formulas

Posted by Sharath Chandra
Here is a quick excel tip. In general for Excel formula column will be very difficult to understand. In that case we can read them as you want using below tip. 

  • Select the cells containing formulas
  • Go to Formulas > Define Name > Apply Names
  • Hold Shift and select all the names
  • Click OK
  • Your formulas will now have names instead of cell references