1. Due to the recent site upgrade, the iPadForums (iPF) App will no longer work. The new iPadForums.net website has been designed from the ground up to work perfectly from any mobile, tablet, or desktop computer using the built in internet browser. Create a shortcut to iPadForums.net on your home screen by following these steps: Create an icon for iPadForums.net

Formatting Numbers

Discussion in 'iPad Help' started by Bluejak, Dec 23, 2013.

  1. Bluejak
    Offline

    Bluejak iPF Novice

    Joined:
    Dec 18, 2012
    Messages:
    39
    Thanks Received:
    0
    Trophy Points:
    0
    Location:
    Merseyside UK
    Ratings:
    +0 / 0
    When I make changes to the spreadsheets in numbers, I find that often the font size changes which is very annoying. This is especially likely to happen if I copy and paste for any reason. Off course I know how to adjust the font for a cell or set of cells, and thus for a column. But with a large spreadsheet and this happening everywhere, I would like to be able to change the font throughout the whole spreadsheet. Is it possible to do so? I thought there was a way of highlighting the whole document, but while this seems to work for copy, delete etc, it does not seem to work for format changes. Any help please?
  2. J. A.
    Online

    J. A. iPad Legend

    Joined:
    Nov 11, 2012
    Messages:
    10,485
    Thanks Received:
    2,612
    Trophy Points:
    113
    Location:
    Apetlon, Austria
    Ratings:
    +2,917 / 1
    Tap any column to see this, then tap here (1), and 2 afterwards:


    image-2732663498.jpg

    Then choose Table Options, and you'll see this:


    image-573042983.jpg

    Change the font and font size for the whole table here.
    Hope that helps.
    • Like Like x 1
  3. Bluejak
    Offline

    Bluejak iPF Novice

    Joined:
    Dec 18, 2012
    Messages:
    39
    Thanks Received:
    0
    Trophy Points:
    0
    Location:
    Merseyside UK
    Ratings:
    +0 / 0
    That helps, certainly. Now I can get the font right for the whole table. But that does not mean I can do the formatting for the whole table, does it? For example, when I have a table full of dates I find every so often it changes the date format and starts including the time or something. Very annoying! That table options does not allow me to change the format for the whole table, does it?
  4. Bluejak
    Offline

    Bluejak iPF Novice

    Joined:
    Dec 18, 2012
    Messages:
    39
    Thanks Received:
    0
    Trophy Points:
    0
    Location:
    Merseyside UK
    Ratings:
    +0 / 0
    Further to the above, why does the formatting change? Why does it suddenly put new new stuff in in a different font size or in a different date format? Why does it not just stay the same? Am I doing something wrong?
  5. Bluejak
    Offline

    Bluejak iPF Novice

    Joined:
    Dec 18, 2012
    Messages:
    39
    Thanks Received:
    0
    Trophy Points:
    0
    Location:
    Merseyside UK
    Ratings:
    +0 / 0
    It doesn't. I am not using the phone Calibri at all. I change it from Times New Roman to Arial. I then change it back. But the message keeps appearing. I have realised it is always the font Calibri it refers to.
  6. J. A.
    Online

    J. A. iPad Legend

    Joined:
    Nov 11, 2012
    Messages:
    10,485
    Thanks Received:
    2,612
    Trophy Points:
    113
    Location:
    Apetlon, Austria
    Ratings:
    +2,917 / 1
  7. Bluejak
    Offline

    Bluejak iPF Novice

    Joined:
    Dec 18, 2012
    Messages:
    39
    Thanks Received:
    0
    Trophy Points:
    0
    Location:
    Merseyside UK
    Ratings:
    +0 / 0
    Sadly I have now found that even this does not help. When I put new items into a spreadsheet every so often they do so in a different font size. I have no idea why and it is fairly annoying. Unfortunately using table options all I actually do is decrease the font size then increase it again and the ones in the wrong font size stay at the wrong font size.

    So, back to the drawing board. Is there any way to make the font size and the font itself consistent over the whole spreadsheet? Is there any way to stop it putting data in new cells in different font sizes from all the cells around?
  8. J. A.
    Online

    J. A. iPad Legend

    Joined:
    Nov 11, 2012
    Messages:
    10,485
    Thanks Received:
    2,612
    Trophy Points:
    113
    Location:
    Apetlon, Austria
    Ratings:
    +2,917 / 1
  9. Bluejak
    Offline

    Bluejak iPF Novice

    Joined:
    Dec 18, 2012
    Messages:
    39
    Thanks Received:
    0
    Trophy Points:
    0
    Location:
    Merseyside UK
    Ratings:
    +0 / 0
    Thanks - but - it is beginning to look as though my problems are insoluble. What with my font problems and also this little bug about Calibras often appearing as though it has changed the font I wonder whether the solution might be to take Numbers off my iPad and reinstall. Presumedly I would not lose any of the actual spreadsheets because they would be in iCloud, yes?
  10. J. A.
    Online

    J. A. iPad Legend

    Joined:
    Nov 11, 2012
    Messages:
    10,485
    Thanks Received:
    2,612
    Trophy Points:
    113
    Location:
    Apetlon, Austria
    Ratings:
    +2,917 / 1
    Yes, they're there.


    image-3982081950.jpg
  11. twerppoet
    Offline

    twerppoet iPad Legend

    Joined:
    Jan 8, 2011
    Messages:
    15,982
    Thanks Received:
    1,844
    Trophy Points:
    113
    Location:
    Walla Walla, WA
    Ratings:
    +1,988 / 1
    All the iWorks apps have received updates today, on both the Mac and iOS. Might be worth your while to download them and see if they fix your issue.

    Good luck.
    • Like Like x 1
  12. Bluejak
    Offline

    Bluejak iPF Novice

    Joined:
    Dec 18, 2012
    Messages:
    39
    Thanks Received:
    0
    Trophy Points:
    0
    Location:
    Merseyside UK
    Ratings:
    +0 / 0
    Thanks. I shall try that.
  13. Bluejak
    Offline

    Bluejak iPF Novice

    Joined:
    Dec 18, 2012
    Messages:
    39
    Thanks Received:
    0
    Trophy Points:
    0
    Location:
    Merseyside UK
    Ratings:
    +0 / 0
    No, still the same problems.
  14. twerppoet
    Offline

    twerppoet iPad Legend

    Joined:
    Jan 8, 2011
    Messages:
    15,982
    Thanks Received:
    1,844
    Trophy Points:
    113
    Location:
    Walla Walla, WA
    Ratings:
    +1,988 / 1
    Darn.

    Well, hopefully the next update then. Or you'll figure out something else.
  15. Bluejak
    Offline

    Bluejak iPF Novice

    Joined:
    Dec 18, 2012
    Messages:
    39
    Thanks Received:
    0
    Trophy Points:
    0
    Location:
    Merseyside UK
    Ratings:
    +0 / 0
    Good news and bad. The very annoying thing that kept telling me that the font Calibri is missing so it might look different seems to have disappeared from Numbers. But if ever I use Pages it normally happens then still, despite never using the font Calibri at any time.

    But despite a lot of fiddling, a lot of trying various things and so forth I still have two major problems with Numbers. I cannot get the same font over the whole spreadsheet. Sadly if you use the device explained in this thread to do the whole spreadsheet all you can do is increase or decrease the font size. So once it is different sizes in different cells that it stays different sizes in different cells with you increase or decrease the whole sheet. From what I read earlier in this thread I think that is insoluble.

    So my final question is this. Is it possible in any way to start off a spreadsheet with the same font in every cell? It's still seems incredible to me, even a software bug, that when I use a new cell it is often different from the cell I have just used above it or to its left.

    Sent from my iPad using iPF
  16. twerppoet
    Offline

    twerppoet iPad Legend

    Joined:
    Jan 8, 2011
    Messages:
    15,982
    Thanks Received:
    1,844
    Trophy Points:
    113
    Location:
    Walla Walla, WA
    Ratings:
    +1,988 / 1
    You're experience seems to be different from what I'm seeing when I experiment.

    There are two places to change the font.

    One, in the Table section. This changes the font for the entire selected table.

    Two, in the Cell format section. Only affects the cell.

    ChangeFont1.png

    In my experiments it was possible to change the font for the entire table using the Table settings. What it would not do is change the relative size. If the text in a cell is larger or smaller than the rest it will retain it's relative size, but the font will change.

    To change the size of all fonts at the same time, instead of using the table settings try selecting a column by tapping the bar above the column. Then use the drag handle to expand your selection to all the columns you want to change. In the cell settings change the font size to what you want. You may have to change it to something else, then back to affect all the cells.

    ChangeFont2.png

    This should also work for changing the font itself and the font color.

    Good Luck.
    • Like Like x 1
  17. Bluejak
    Offline

    Bluejak iPF Novice

    Joined:
    Dec 18, 2012
    Messages:
    39
    Thanks Received:
    0
    Trophy Points:
    0
    Location:
    Merseyside UK
    Ratings:
    +0 / 0
    That is exactly the thing I have been trying to do and feel I should be able to do but cannot do!

    I have tried several times to expand my selection to more than one column and I agree if I could do that that would solve all my problems. But I haven't found this drag handle as you put it.

    But you have given me renewed confidence that there is a way so I shall try again until solve it.

    Sent from my iPad using iPF
  18. Bluejak
    Offline

    Bluejak iPF Novice

    Joined:
    Dec 18, 2012
    Messages:
    39
    Thanks Received:
    0
    Trophy Points:
    0
    Location:
    Merseyside UK
    Ratings:
    +0 / 0
    Finally! I have managed to expand the selection over the whole document so I can get everything the same size! Thanks very much.

    Sent from my iPad using iPF
  19. twerppoet
    Offline

    twerppoet iPad Legend

    Joined:
    Jan 8, 2011
    Messages:
    15,982
    Thanks Received:
    1,844
    Trophy Points:
    113
    Location:
    Walla Walla, WA
    Ratings:
    +1,988 / 1
    Glad you got it figured out. I've discovered that sometimes you need to zoom in/or out of a page when trying to use drag handles and such, to make them more visible, or make more of the table visible.

Share This Page

Search tags for this page

ipad numbers format copy style