I would like to print set all sprdshts, remove zeros and gridlines in workbook in one step.
I use spr sheets to record info monthly, each spr sheet in a workbook is one month. I would like to be able to print-set, remove zero values and grid lines all in one step. Perhaps if I could right click on workbook and choose an option that says every spr sheet use same settings (list off settings as options) as sheet 1 in workbook. Also if every spr sheet could have the option to be different from that workbook options that would be great for a summary sheet.