2 replies to this topic

[tinmac]

Hi Mike,

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?

Thanks,

Mac

[Mike MacGregor]

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.

[tinmac]

Thanks! That was it, knew it was something easy just couldn't remember where.