Results 1 to 4 of 4
  1. #1

    Member Since
    Jul 17, 2013
    Excel Mac Error Font size must between 1 and 409
    Whenever I try to change the colour of the border of cells or an area in Mac Excel 2011 i get an error: "Font size must between 1 and 409" and cannot change the colour of the border.

    The only easy way is to change the font size of all the cells to the same size, which is not convenient at all as sometimes the font has different font sizes and it wants to have one font size.

    I have found a way which is very difficult and frustrating but you select Format Cell - Font.
    Clicking through with the tab button - Font - Font Style - Size (as there is no size selected due to different sizes). IF you select the size it changes all the font to that one size which has to be undone. Then I undo it and then go back to format cell and and click through it again and say OK. Sometimes it takes a few "undo's" and doing it again before I can change the colour of the selected area or cells.

    This is really not ideal and a HUGE bug in the Excel system but at least now I can move pass it.

    If someone has a better way of doing this please let me know.


  2. #2

    Member Since
    Sep 28, 2013
    more of same ...
    I too have been intensely frustrated by this bug and REALLY wish that the border manual-draw tool was still available. (Upgraded this year from Office 200 to 2011 - yikes!)

    This error seems to have been around for at least 2.5 years based on reports of it that I have seen. (I guess since it came out in 2011??)

    The time it takes to do the work-around really reduces my usability of excel where the appearance & easy visual retrieval of data is important.

    Come on Microsoft - this is appalling !!!!

  3. #3

    chscag's Avatar
    Member Since
    Jan 23, 2008
    Fort Worth, Texas
    27" iMac i5, 3.2 GHz, iPad 3, iPhone 5c, iPhone 6+, 3 iPods, El Capitan
    The Microsoft Excel on line forums for Mac Office 2011 is where you should be addressing this not here. Joining is free and I'm sure you can find some kind of definitive answer there from the MS MVPs. LINK

  4. #4

    Member Since
    Sep 28, 2013
    This problem is all over various mac forums -- I figure Mac people are probably more creative in finding solutions as the Microsoft folks obviously haven't solved this one yet... Hoping that some other workaround may have been discovered that I haven't yet found .....

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. font size on mac
    By TeriTuran in forum Apple Desktops
    Replies: 1
    Last Post: 12-09-2014, 12:58 PM
  2. font size in Outlook for Mac
    By sanjayverma in forum Apple Notebooks
    Replies: 0
    Last Post: 07-14-2013, 02:55 AM
  3. changing default font size for Excel comment boxes
    By Noni in forum OS X - Apps and Games
    Replies: 1
    Last Post: 09-08-2012, 07:21 PM
  4. Change font size in comment box in Excel
    By Xpcguy in forum OS X - Apps and Games
    Replies: 0
    Last Post: 06-11-2009, 05:44 PM
  5. Mac email font size
    By soccerphysio in forum Switcher Hangout
    Replies: 2
    Last Post: 09-17-2008, 10:55 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts