Copying same worksheet format for entire book

R

RagDyeR

Hold down <Ctrl>,
Click and drag the sheet tab to the right until small arrowhead is over
right border of the tab,
Release <Ctrl>,
THEN
Release Mouse.

This makes a single copy, but it's so fast and easy, you can copy a bunch in
no time.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

How do you copy a worksheet and make several copies of it
in a workbook?
 
K

Kent

Easiest approach is to Insert however many new sheets,
select all of the sheet you wish to copy and choose Edit-
Copy, go to each new sheet, click in A1, and Paste.
Click to expand...
Lather, rinse repeat.

Now, if you're linking ... that's a bit different.

Excel Support Technician
www.canhelpyou.com
-----------------------------------------------------------
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Embed the same Excel multiple times 0
Missing address Book 0
Macro to copy table of contents to a new doc 0
Copy entire row from another sheet onto first sheet if a unique text matches 1
How To Stop Excel Copying Named Functions When A Worksheet Is Copied? 2
Copying Conditional Formating to another worksheet 0
VBA to do a mailmerge from a Specific Excel worksheet 0
Format column widths from one table to a separate table on same page 1

Top