I have an auction league with a $2000 cap. The problem I am getting is that with this large a number the cells that calculate anything to do with the cap are not large enough to hold the value and give me the #### for the number. Is there a way I can set the buddy cells to auto size for the value?
High Salary Cap
2 replies to this topic
Posted 20 August 2012 - 07:22 AM
Hi Mac. It really is just because the columns aren't wide enough, so a pretty easy fix to adjust it. Highlight cells in the column that is showing the ###. Pick near the top of the cheatsheets since those will be the spots with the highest dollar values. Then choose Format > Column > AutoFit Width. Repeat for each column and you'll be good. You could probably even select multiple columns at a time holding down the CTRL key to highlight separate areas.
Posted 20 August 2012 - 07:48 AM
Thanks! That was it, knew it was something easy just couldn't remember where.