New To Mac-Forums?

Welcome to our community! Join the discussion today by registering your FREE account. If you have any problems with the registration process, please contact us!

Get your questions answered by community gurus Advice and insight from world-class Apple enthusiasts Exclusive access to members-only contests, giveaways and deals

Join today!

 
Start a Discussion
 

Mac-Forums Brief

Subscribe to Mac-Forums Brief to receive special offers from Mac-Forums partners and sponsors

Join the conversation RSS
OS X - Operating System General OS operation information and support

Excel Mac Error Font size must between 1 and 409


Post Reply New Thread Subscribe

 
Thread Tools
lizy2busy

 
Member Since: Jul 17, 2013
Posts: 1
lizy2busy is on a distinguished road

lizy2busy is offline
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.

Thanks
QUOTE Thanks
feldyjan

 
Member Since: Sep 28, 2013
Posts: 2
feldyjan is on a distinguished road

feldyjan is offline
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 !!!!
QUOTE Thanks
chscag

 
chscag's Avatar
 
Member Since: Jan 23, 2008
Location: Fort Worth, Texas
Posts: 39,365
chscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond repute
Mac Specs: 27" iMac i5, 3.2 GHz, iPad 3, iPhone 5c, 3 iPods, OS X Mavericks

chscag is offline
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
QUOTE Thanks
feldyjan

 
Member Since: Sep 28, 2013
Posts: 2
feldyjan is on a distinguished road

feldyjan is offline
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 .....
QUOTE Thanks

Post Reply New Thread Subscribe


« edit a .plist file | OS X Recovery »
Thread Tools

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off
Forum Jump

Similar Threads
Thread
Thread Starter
Forum
Replies
Last Post
Excel 2011 (Mac) Mark McLean OS X - Apps and Games 0 03-04-2011 06:45 PM

All times are GMT -4. The time now is 12:02 AM.

Powered by vBulletin
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
X

Welcome to Mac-Forums.com

Create your username to jump into the discussion!

New members like you have made this community the ultimate source for your Mac since 2003!


(4 digit year)

Already a member?