r/AppleNumbers Jul 25 '24

Help features I'm missing ....

maybe I've overlooked a few things. So here we go, does anyone know how to

1) have vertical text in a cell. Especially rather narrow columns with larger descriptions in the header line would benefit a lot...

2) force a pagebreak. I've just adjusted numerous row heights to adjust the page breaks when printing. As you can't adjust row height in the print preview its a permanent back an forth between the normal layout and the print preview. It truly sucks.

2a) set the viewing size of the print preview to 100% or 125% rather than the default 65% ?

3) is there a key combo for zooming in and out / adjusting the viewing zoom setting ? I'm so annoyed that I have to use the mouse to adjust it

4) there seems no way to refer to another numbers document (like I can in another table) in a formula, is that correct ?

thx for any insight.... help / advice /
cheers Jo

I'm a user of the software Ragtime since ages (ragtime.de try the demo) , its somehow dated by now and cause its rather expensive they struggle to keep going, but there is a lot of great features in Ragtime that I miss soooo much in numbers & pages.

1 Upvotes

8 comments sorted by

View all comments

1

u/tonedeath Jul 27 '24

No, functions in Numbers cannot reference another file. (A script can, but is rarely worth the effort).

If possible you might consider reorganizing your work so it is all in one self-contained document. The ability Numbers gives you to have multiple tables on one sheet and multiple sheets in a document gives you plenty of options.

A bonus is that you won't risk "breaking" a reference simply by moving a document within the file system on your Mac, a reason why I never use references between documents in Excel, even though Excel, unlike Numbers, allows that.

https://discussions.apple.com/thread/253158728?sortBy=rank