Tuesday January 4, 2011 at 9:36am
Don’t just insert a blank sheet and copy and paste the information you need… copy the whole Worksheet by dragging the sheet tab to where you want the new sheet to be and holding the CTRL key while you release the mouse button. Then you can adjust the new sheet as you wish.
This way, everything about the existing Worksheet is copied, including column widths, filter settings, page setup, headers and footers and so on.
Oh, and by the way, you can even drag the Worksheet to a different Workbook!