Copy an Excel page

[Mark]

Now that I've created page one on sheet one, and I want
to have five duplicate pages, how do I copy page one
multiple times?

 

[Don Guillett]

Simple way is to copy and then paste, paste, paste.
Do you mean page 1 of worksheet 1 of workbook 1? where page is a part of a
worksheet.

 

[peter]

Hi,
Right click the tab, select move or copy, check the copy
box click OK.

peter

 

[Mark]

Correct. I'm in book one, sheet one and I've created page
1. I then go to the bottom right corner of page one and
drag my mouse to the upper left corner to select all the
cells on the page. I'm in page break preview so I can see
where page 2 starts. I click in that cell and paste page
one and that works fine. However, when I go to print
preview, both pages appear there but the second page is
sort of greyed out and it is not numbered "Page 2". Then,
when I click print, only one page prints.
Thanks!

 

[Mark]

I'd rather not create a new sheet. I just want multiple
pages under the sheet 1 tab.

 

[Andy B]

Mark

You don't need to do it in Page Break Preview. Try it in normal view and
when you have pasted your copies you can insert your own page breaks where
you like.

Andy.

 

[Lady Layla]

Mark

In order to print and see the additional pages in the page break mode, you need
to reset the print area

Select entire area you want to print, go to file Print Area Set




: Correct. I'm in book one, sheet one and I've created page
: 1. I then go to the bottom right corner of page one and
: drag my mouse to the upper left corner to select all the
: cells on the page. I'm in page break preview so I can see
: where page 2 starts. I click in that cell and paste page
: one and that works fine. However, when I go to print
: preview, both pages appear there but the second page is
: sort of greyed out and it is not numbered "Page 2". Then,
: when I click print, only one page prints.
: Thanks!
: >-----Original Message-----
: >Simple way is to copy and then paste, paste, paste.
: >Do you mean page 1 of worksheet 1 of workbook 1? where
: page is a part of a
: >worksheet.
: >
: message
: >: >> Now that I've created page one on sheet one, and I want
: >> to have five duplicate pages, how do I copy page one
: >> multiple times?
: >
: >
: >.
: >