Friday, June 05, 2009

Xcel Cheat sheet

Did you know you can refer to a cell by name?

 

  • So, lets say you have a variable you want to create: CycleCount.
  • Type the word CycleCount in a cell (e.g. I3)
  • Then select the cell and click on Name text box; right now it shows I3

·         Type CycleCount in the name and now you can refer to I3 as CycleCount when using Formula

 

Nyce haaan?