Formatting Numbers

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

  1. Bluejak

    Bluejak
    Expand Collapse
    iPF Novice

    Joined:
    Dec 18, 2012
    Messages:
    39
    Thanks Received:
    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.
    Expand Collapse
    iPad Legend

    Joined:
    Nov 11, 2012
    Messages:
    16,308
    Thanks Received:
    7,549
    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.
     
  3. Bluejak

    Bluejak
    Expand Collapse
    iPF Novice

    Joined:
    Dec 18, 2012
    Messages:
    39
    Thanks Received:
    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
    Expand Collapse
    iPF Novice

    Joined:
    Dec 18, 2012
    Messages:
    39
    Thanks Received:
    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
    Expand Collapse
    iPF Novice

    Joined:
    Dec 18, 2012
    Messages:
    39
    Thanks Received:
    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.
    Expand Collapse
    iPad Legend

    Joined:
    Nov 11, 2012
    Messages:
    16,308
    Thanks Received:
    7,549
  7. Bluejak

    Bluejak
    Expand Collapse
    iPF Novice

    Joined:
    Dec 18, 2012
    Messages:
    39
    Thanks Received:
    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.
    Expand Collapse
    iPad Legend

    Joined:
    Nov 11, 2012
    Messages:
    16,308
    Thanks Received:
    7,549
  9. Bluejak

    Bluejak
    Expand Collapse
    iPF Novice

    Joined:
    Dec 18, 2012
    Messages:
    39
    Thanks Received:
    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.
    Expand Collapse
    iPad Legend

    Joined:
    Nov 11, 2012
    Messages:
    16,308
    Thanks Received:
    7,549
    Yes, they're there.


    image-3982081950.jpg
     

Share This Page



Search tags for this page
ipad numbers custom formating
,

ipad numbers format copy style