excel font size must be between 1 and 409 border

If someone has a better way of doing this please let me know. This is really not ideal and a HUGE bug in the Excel system but at least now I can move pass it. Sometimes it takes a few 'undo's' and doing it again before I can change the colour of the selected area or cells. Then I undo it and then go back to format cell and and click through it again and say OK. If it's not the way you want it to appear, click. Check your new border width in the preview diagram. In the Presets section, click your existing border type. For a continuous line, choose one of the thicker styles from the Line box.

You can also click the Increase Font Size or Decrease Font Size ( Grow Font and Shrink Font in some earlier versions of Office programs) icons until the size you want is displayed in the Font Size box. Right-click over the cells you've chosen and select Format Cells and, in the popup window, click the Border tab. You can also change the text size in this toolbar. IF you select the size it changes all the font to that one size which has to be undone. Tips: When you select text, a mini toolbar appears near your cursor. Created on JRun-time error '1004': Font size must be between 1 and 409 points when running Excel add-in Hello, I am trying to run a lab data analysis add-in in Excel 2010. I have found a way which is very difficult and frustrating but you select Format Cell - Font.Ĭlicking through with the tab button - Font - Font Style - Size (as there is no size selected due to different sizes).

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. Im bemused by this - Im trying to lighten the border on a table and for some reason keep getting this message pop up Font size must be 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.

Excel font size must be between 1 and 409 border