Excel Calculated Fields

Hello, Jin.

By 'calculated fields' I assume you're referring to columns containing formulas and that you want to save a template that is pre-populated with these formulas. And so, the short answer is; Yes.

Without more info about your system, data or formatting, I'll also assume your formulas use cell references (i.e. A1+B1) and not named ranges or fields in an Excel table.

So, I think the simplest approach would be to open an existing file (lets call it Report1) and simply select all of the cells containing you're data, right-click on the selection and choose 'Clear Contents' from the right-click menu. Clearing contents will not break cell references in formulas the way deleting the cells would.

Then save the file using Save As (or Save A Copy) with a different file name, e.g. Report1Template, so it is ready to use the next time you need to analyze Report1 by pasting the data from your source file into the empty cells in Report1Template.

Hope that helps.