New answers tagged numbers
There's the INDIRECT function, which returns the contents of a cell or range referenced by an address specified as a string. example: INDIRECT("B2") Here's Apple documentation about Numbers.app functions.
Looking at the image above, I got inspired to try something and what I discovered is that if you play with the "content scale", adjusting the percentage or sliding the scale's button, you can achieve the same effect as window's print range moving of the blue lines. I did have to delete a couple of rows (that were empty to begin with) to make 4 pages turn ...
You can replace the colours in the default palette. Once you have set a cell to your preferred colour, drag the new colour from Current Fill to one of the palette slots: This will replace the colour in the palette:
Yes, you can make infinite custom color choices. Click on the color swatch wheel below the color fill drop down menu:
In older versions of Numbers, it is necessary to cut and repaste the hyperlinked line (with the AutoCorrect option mentioned already turned off.) Select the line, cut it, then paste it. It will then be pasted without hyperlinking. This will be necessary even to edit the line. This is because clicking on the line to edit it will only perform the hyperlink ...
Top 50 recent answers are included