Paste format with Freeze Frame into an new worksheet

C

Celeste

How can I take a spreadsheet from one worksheet and paste to a new worksheet
but keep all of my columns, rows, and freeze frame set when I paste into the
new worksheet? An exact copy into a new worksheet?
 
E

Earl Kiosterud

Celeste,

Instead of copy/pasting the cells, why not copy the sheet? Right-click the
sheet tab, Move or Copy. You can specify New in the To Book box. Be sure to
click "Create a copy" or it'll move the sheet out of the original workbook.
That box should be at the top of the dialog.
 
Top