Enter a formula in the top cell. This prevents Google Sheets from changing the references when youre copying. As I need the same set-up for 2014 Ive copied the two worksheets and renamed them accordingly.
Select a range or the sheet you want to use the formulas press Ctrl H keys to show the Find and Replace dialog.
If you follow these steps youll note that the Formula Bar now contains Budget. Yieldpct - The distribution yield the sum of the prior 12 months income distributions stock dividends and fixed income interest payments and net asset value gains divided by the. Populate Cell A2 to Cell A13 with the name of the worksheets Step 2. Just press Ctrl it is the key next to 1 this will enable formula view.