I have a worksheet that contains formatting such as no gridlines, cell protection, print area, page setup, etc. It needs to be copied and pasted into about 100 other workbooks (these are for employee files where 1 workbook contains several "forms"/worksheets for each employee). When I select all and copy and paste, the following are not preserved:
Print area
Page setup
Gridlines off
Window freeze pane
How can I copy and paste without having to redo all of these settings in all the other workbooks?
Thanks!
Print area
Page setup
Gridlines off
Window freeze pane
How can I copy and paste without having to redo all of these settings in all the other workbooks?
Thanks!