Skip navigation

Spreadsheet help.  Why does the font change .....

909 Views 21 Replies Latest reply: Jun 29, 2013 2:44 AM by Hiroto RSS
1 2 Previous Next
Leciaatapple Calculating status...
Currently Being Moderated
Jun 22, 2013 12:00 PM

I am using Numbers and have created a Sopreadsheet.  I have set the Font, Size, Style and Alignment in the Lettered "menu" area at the top of the document. However, when I enter a new line, whether it be within the body of the spreadsheet or a new line at the bottom, it changes all of these settings - everytime.  How can I avoid this happening as everytime I have to reset the requirements.  Thank you.

Mac OS X (10.7.2), Various
  • Jerrold Green1 Level 7 Level 7 (28,120 points)

    When you make changes to the font, the changes apply to whatever is selected at the time. Nothing else. Select the entire table, or a group of tables, to make mass changes that will also apply to whatever is written in those tables later.

     

    Jerry

  • Jerrold Green1 Level 7 Level 7 (28,120 points)

    Select the table by clicking on its name in the Sheets Pane.

     

    Jerry

  • Jerrold Green1 Level 7 Level 7 (28,120 points)

    I expected a Numbers file, not an Excel file. In either case, your 500 entry includes a space character after the number. Removing that character results in a proper sort.

     

    Jerry

  • Jerrold Green1 Level 7 Level 7 (28,120 points)

    Sorry Lecia,

     

    I accidently clicked Reply on your message when intending to answer another question. Even I don't know how I could have done that! Please disregard.

     

    l can't give you a better answer than that what I suggested should work. You know, when you do a normal Paste, the format is transferred from the source to the destination. That's one way a format can change in a table without your doing any explicit reformatting.

     

    Jerry

  • Badunit Level 6 Level 6 (10,760 points)

    I think Jerry responded to the wrong message. There is another thread about sorting and typing the number 500.

  • Hiroto Level 5 Level 5 (4,800 points)

    Hello

     

    How do you "enter a new line"? Typing text from keyboard or pasting something from clipboard? If the latter, pasting will preserve the original text style in clipboard.

     

    One way to strip the original style of text and let it honour the current stlye is to use "Paste and Match Style" instead of "Paste" in "Edit" menu. The keyboard shortcut for it is command + option + shift + v.

     

    Regards,

    H

  • Jerrold Green1 Level 7 Level 7 (28,120 points)

    Lecia,

     

    Open a new blank template and make a test document. See if you have the same problem in a new document. Let us know.

     

    Jerry

  • Hiroto Level 5 Level 5 (4,800 points)

    Hello

     

    I cannot reproduce the said behaviour. Perhaps your Numbers plist file is corrupt.

     

    You may try as follows:

     

    1) Quit Numbers.

     

    2) Open ~/Library/Preferences folder in Finder. In OS 10.7 or later, this folder is hidden for some reason. In order to open it, use Finder's Go > Go to Folder… menu, and specfiy the path:

     

    ~/Library/Preferences
    

     

    3) Move (drag and drop) the following file to desktop:

     

    com.apple.iWork.Numbers.plist
    

     

    4) Launch Numbers and test the behaviour. Numbers.app will create new com.apple.iWork.Numbers.plist file with initial settings etc.

     

    5a) If the said problematic behaviour is gone, the culprit was the corrupt plist file. You just need to redo some settings from Numbers > Preferences… menu and the problem will be solved.

     

    5b) If the problematic behaivour persists, plist was not the cause and so you may restore it from desktop. To do it, first quit Numbers and then replace the newly created ~/Library/Preferences/com.apple.iWork.Numbers.plist with the one in desktop.

     

     

    If this does not fix it, next I'd suspect font problem.

     

    Good luck,

    H

1 2 Previous Next

Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • This solved my question - 10 points
  • This helped me - 5 points
This site contains user submitted content, comments and opinions and is for informational purposes only. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.