Copying same worksheet format for entire book

  • Thread starter Thread starter su
  • Start date Start date
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?
 
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
-----------------------------------------------------------
 
Back
Top