I want to be able to use Defined Name when creating my spreadsheet so that I can use them in formulas. IE instead of having to create a formula that is
= SUM(A1:A20) I define A1 to A20 a name "Period1" and then I can do things like = SUM(Period1 Apples) etc. How do you create the Defined Names in the Spreadsheet and does the formulas then support this feature. Also when exporting the spreadsheet to excel do the formulas and names export?