I’m looking to use Excel spreadsheets as templates for reports. Unfortunately one thing has eluded me. Lets say I have a cell named ‘Hoover building, third floor, East wing’ I select it, fill in the information associated with that part of that floor in that building, and as soon as I start editing the cell a new one that says the same thing is automatically inserted below making it so that no matter how many different notes I need for the  ‘Hoover building, third floor, East wing’ I always have the template notes ready because they just pop into existence.

​I’m looking to use Excel spreadsheets as templates for reports. Unfortunately one thing has eluded me. Lets say I have a cell named ‘Hoover building, third floor, East wing’ I select it, fill in the information associated with that part of that floor in that building, and as soon as I start editing the cell a new one that says the same thing is automatically inserted below making it so that no matter how many different notes I need for the  ‘Hoover building, third floor, East wing’ I always have the template notes ready because they just pop into existence.  Read More

​