MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Copy Print specs from one Sheet to eleven others in the same Workbook ?

Posted by Matteo on October 15, 2001 7:57 AM

I have all twelve worksheets (calander) set up, formatted and some data is already entered for 2002. I wish to print them out but I don't want to go through each sheet to set up the print specs (margins, gridlines, % of font, etc) Is there an easier way ?


Posted by Jonathan on October 15, 2001 9:15 AM

Select all the sheets together from the sheet tabs (click on one at one end, scroll to last one at other end, hit Shift + tab: all are now selected). Once they're all selected, do whatever it is you want to do: it will occur to all of them. This works for data entry, formatting, headers and footers, page setup, etc.


Posted by Matteo on October 15, 2001 11:10 AM

Thank you very much. Worked like a charm !!