# 25 Things You Didn’t Know You Could Do With Mac Numbers

Here are a variety of functions, features and tips for Mac Numbers that many Numbers users don't know about.

### Comments: 10 Responses to “25 Things You Didn’t Know You Could Do With Mac Numbers”

Eduard Nebbeling
3 years ago

Thank you very much for this topic, it's really helpful when working in Numbers.

Sue Dickie
3 years ago

Very timely. I just looked at the Stocks template yesterday and couldn’t figure out how they had done some calculations. After poking around, I found ‘Previous gain’ in a hidden row. Your video has now shown me more things that I wasn’t aware of, and some will be helpful. As an aside, I wish Apple annotated their templates to explain how they were pulled together.

John R Carter Sr
3 years ago

You just blew my mind with this.
I'm using Numbers at the very basic level of just showing tabular data.
I knew that there were many formulas available, and I've used some of the math functions. But this goes beyond anything I would need to do! Still, fun to know.

Ray Johnston
3 years ago

Very helpful, Gary. Do you have a way to generate a value for "yesterday" which also skips over holidays? I'd like to use that in a spreadsheet to look at yesterday's closing stock value, since todays closing value won't be correct until after the close.

3 years ago

Ray: Look at WORKDAYS in the help. You can use a value like -1 and then add your holidays in to get the previous work day.

Ray
3 years ago

Tried that: =WORKDAY("1/1/21",-1,"1/1/21") returns 12/30/20, not 31. Also tried =STOCK(TSLA, previous close), but that seems to return value for two days ago, according to =STOCKH(TSLA,close,"2/18/21") {today's the 20th}.

3 years ago

Ray: WORKDAY(“1/1/21″,-1,”1/1/21″) probably returns 12/30/20 because you are eliminating 1/1/21 and also going back one more day as well. The other one makes sense because you are asking for the "previous" close, not the current price.

Ray
3 years ago

Thanks, Gary. For my personal finance tracking, those answers work well enough. I think I'll use the =STOCK( ticker,previous close) function for just a quick look, and perhaps the =WORKDAY( date,-1) function (no holidays) and =STOCKH( ticker,close,date ) for trend tracking.

Joe Pustai
3 years ago

After watching your Hidden Mac Numbers Tips I successfully inserted several links (to other places in the same workbook). This was simple and easy to do and worked well for my rather extensive financial spreadsheet (thank you). As of today I can no longer insert a link. The three link options are showing up but are no longer selectable (Control K will not work either). I even updated my OS and my Numbers is the most recent but I cannot seem to be able to link any more.... how can I fix that?

3 years ago

Joe: Are you selecting some text in a cell? You can't just select the cell.