View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Delordson Kallon
 
Posts: n/a
Default How do I copy setting from one sheet to multiple sheets in Excel?

My apologies if you already know this but you can paste to more than one
sheet at a time. First copy the sheet you want, then holding down the shift
key and select the first and last sheet tabs you want to copy to before you
paste.

Did you want something faster than that?

Delordson Kallon
http://www.instantsoftwaretraining.com/

"danam6" wrote:

I am trying to copy an original sheet to 31 sheets, an entire month,
automatically. I can copy and paste, or use the edit function to copy and
move the original, but I want a solid month at once.