LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I share information between multiple sheets in Excel? lucasjackson Excel Discussion (Misc queries) 1 October 28th 05 03:11 PM
Edit / Move or copy sheet stopped working in Excel 2003 kris2u Excel Worksheet Functions 0 October 4th 05 08:20 PM
copy data in one sheet to multiple sheets in same workbook BrianMultiLanguage Excel Worksheet Functions 4 July 27th 05 07:26 PM
Append the data given in diff sheets of an Excel File to one sheet sansk_23 Excel Worksheet Functions 3 May 10th 05 02:00 AM
saving excel with multiple sheets, but won't save to proper sheet jimlead1 Excel Discussion (Misc queries) 0 May 4th 05 06:36 PM


All times are GMT +1. The time now is 03:12 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"