Confusion around Calculations! in Annual Financial Report template

[sohrab12]

Hi,

I'm sorry in advance if this is not the right place to post this question. I am fairly new to excel and can use some guidance and stirring in the right direction. I am looking to make a personal annual financial report. I have started with the Annual Financial Report template that comes with Excel(I am using the mac version).

on cell B16 of the Financial Report sheet, it is showing the value to be =Calculations!B15. It seems that this value is being pulled from the cell A4 of Financial Data Input sheet.

I am a bit confused as to how Calculations!B15 pulls that value. In particular, what is Calculations!?

I understand that this question might be vague and my apologies in advance. I have tried searching the web with no luck and after spending quite some time on this, I have decided to seek help in this forum.

[AliGW]

Welcome to the forum.

It's a worksheet name - possibly a hidden one.

[sohrab12]

thank you

is there anyway to find hidden worksheets? also what does the ! in Calculations!B15 mean?

[sohrab12]

thank you

is there anyway to find hidden worksheets? also what does the ! in Calculations!B15 mean?

[AliGW]

The ! is how I know it's a sheet.

Sheet1!A1 is standard syntax.

Right-click on any visible worksheet tab to unhide other sheets.

[bebo021999]

Just right click on any visibale sheet name tab, then choose "Unhide".
If you stay in other sheet and want to refer to cell B15 in sheet name "Calculations" just tell excel with "Calculations!B15"

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.