ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I copy setting from one sheet to multiple sheets in Excel? (https://www.excelbanter.com/excel-discussion-misc-queries/85513-how-do-i-copy-setting-one-sheet-multiple-sheets-excel.html)

danam6

How do I copy setting from one sheet to multiple sheets in Excel?
 
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.

Delordson Kallon

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.



All times are GMT +1. The time now is 08:21 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com