Forums
New posts
Articles
Product Reviews
Policies
FAQ
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Menu
Log in
Register
Install the app
Install
Forums
Apple Computing Products:
macOS - Operating System
Excel Mac Error Font size must between 1 and 409
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="lizy2busy" data-source="post: 1526668" data-attributes="member: 306926"><p>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.</p><p></p><p>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. </p><p></p><p>I have found a way which is very difficult and frustrating but you select Format Cell - Font.</p><p>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.</p><p></p><p>This is really not ideal and a HUGE bug in the Excel system but at least now I can move pass it. </p><p></p><p>If someone has a better way of doing this please let me know.</p><p></p><p>Thanks</p></blockquote><p></p>
[QUOTE="lizy2busy, post: 1526668, member: 306926"] 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]
Verification
Name this item 🌈
Post reply
Forums
Apple Computing Products:
macOS - Operating System
Excel Mac Error Font size must between 1 and 409
Top
