Post a copy of your worksheet and how you would like the settings. Be specific. We can offer lots of suggestions, but without working specifically with your workbook, it is like throwing darts blindfolded.