How to 'copy' the print setting?

[BNCOXUK]

Dear all,

I copied the VALUES of a sheet to another sheet, and used the 'Format Painter' to make the format appear exactly the same between the two sheets. But I found the print setting is not copied across, and I have to manually do the print setting for the new sheet.

Is there a way to make the print setting the same?

Thanks for your advice.

[Cheeky Charlie]

Copy the sheet across instead of the cell values. Then copy and paste values on top if you want to remove formulae.
HTH

[dilipandey]

Hi BNCOXUK,

Try another way of copy, just right click on sheet and choose Move/Copy -> checkbox create a copy.


Regards,
DILIPandey
<click on below * if this helps>

[BNCOXUK]

Thanks, DILIPandey. This really helped

[dilipandey]

you are welcome..

cheers


Regards,
DILIPandey
<click on below * if this helps>