Paste format with Freeze Frame into an new worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.
 
Back
Top