Thread: How do I copy and paste a worksheet and maintain all formatting?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Per Erik Midtrød Per Erik Midtrød is offline
external usenet poster
  
Posts: 8
Default How do I copy and paste a worksheet and maintain all formatting?
Right-click your sheet, choose Move or copy and mark the checkbox
Create a copy.

Per Erik

On Tue, 19 Sep 2006 11:38:02 -0700, Jana
wrote:

I have formatted one worksheet to use weekly. Everytime I copy and paste it
for a new week, I lose some of the formatting. How can I maintain every
change that has been made so I can copy and begin data entry without
reformatting?
Reply With QuoteReply With Quote