M
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?
to have five duplicate pages, how do I copy page one
multiple times?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
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.
Do you mean page 1 of worksheet 1 of workbook 1? where page is a part of a
worksheet.
P
peter
Hi,
Right click the tab, select move or copy, check the copy
box click OK.
peter
Right click the tab, select move or copy, check the copy
box click OK.
peter
M
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!
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!
M
Mark
I'd rather not create a new sheet. I just want multiple
pages under the sheet 1 tab.
pages under the sheet 1 tab.
A
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.
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.
L
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?
: >
: >
: >.
: >
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?
: >
: >
: >.
: >