Formatting Numbers

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

  1. Bluejak

    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.

    J. A. iPad Legend

    Joined:
    Nov 11, 2012
    Messages:
    13,797
    Thanks Received:
    4,709
    Trophy Points:
    113
    Location:
    Apetlon, Austria
    Ratings:
    +6,106 / 8
    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 2
  3. Bluejak

    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

    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

    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.

    J. A. iPad Legend

    Joined:
    Nov 11, 2012
    Messages:
    13,797
    Thanks Received:
    4,709
    Trophy Points:
    113
    Location:
    Apetlon, Austria
    Ratings:
    +6,106 / 8
  7. Bluejak

    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.

    J. A. iPad Legend

    Joined:
    Nov 11, 2012
    Messages:
    13,797
    Thanks Received:
    4,709
    Trophy Points:
    113
    Location:
    Apetlon, Austria
    Ratings:
    +6,106 / 8
  9. Bluejak

    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.

    J. A. iPad Legend

    Joined:
    Nov 11, 2012
    Messages:
    13,797
    Thanks Received:
    4,709
    Trophy Points:
    113
    Location:
    Apetlon, Austria
    Ratings:
    +6,106 / 8
    Yes, they're there.


    image-3982081950.jpg
     
  11. twerppoet

    twerppoet iPad Legend

    Joined:
    Jan 8, 2011
    Messages:
    18,195
    Thanks Received:
    3,003
    Trophy Points:
    113
    Location:
    Walla Walla, WA
    Ratings:
    +3,823 / 4
    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

    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

    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

    twerppoet iPad Legend

    Joined:
    Jan 8, 2011
    Messages:
    18,195
    Thanks Received:
    3,003
    Trophy Points:
    113
    Location:
    Walla Walla, WA
    Ratings:
    +3,823 / 4
    Darn.

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

    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
     

Share This Page

Search tags for this page

ipad numbers format copy style