I am trying to copy a worksheet from one file to another. How do I keep the formatting the same?
D dmk Aug 6, 2008 #1 I am trying to copy a worksheet from one file to another. How do I keep the formatting the same?
M Mike H Aug 6, 2008 #2 Use Pastespecial instead of paste this gives you the option to paste all. You can pastespecial a second time for column widths for example. Mike
Use Pastespecial instead of paste this gives you the option to paste all. You can pastespecial a second time for column widths for example. Mike
B Bob I Aug 6, 2008 #3 R-click the tab of the sheet in question and pick Move or Copy.................
