You've noticed that Excel Online is noticeably harder to use :)
To accomplish this in the paid version, when you wanted to insert a link to a sheet, the you used the menu to pick the sheet you wanted to link to..
Now what do you do?
Answer : you have to specify the sheet AND a cell. So, if all you care about is going to a particular Sheet (call it Target). Then, you have to put in (without the quotes, of course) "Targets!A1" .
How do I know this? I uploaded a file created with the paid version and looked at it.
Why would you want to do this? It's an easy way to build a "dashboard" Imagine all your controls on the Tesla or Apple-car spread out in one line at the bottom of the control-panel. Yuck. Yet, that's exactly how M$ serves them. *ds of Redmond!!
No comments:
Post a Comment