Duplicate Page 1 on Page 2 - Same Worksheet

[meighkee]

Greetings,

I've created a form on page 1 of Sheet 1 and I'm having trouble cutting and pasting that to page 2, page 3, etc. (same Sheet). The row heights don't follow the pasted selections.

In otherwords I want to create multiple pages of the same form on the same sheet but, again, the row heights of the original arent the same on successive pages.

Any help greatly appreciated,

Thank you.
Mike

 

[JoeMo]

Why not just copy the sheet? Right-click the sheet tab and choose Move/Copy.

 

[meighkee]

Why not just copy the sheet? Right-click the sheet tab and choose Move/Copy.

Thanks much for the reply.

What I'm hoping to do is copy the contents of Page 1, Sheet 1, and paste/append it below Page 1, onto Page 2, of the same Sheet. I've moved the page break to the bottom of Page 1. Sheet 1 now consists of multiple pages.

Again, the problem I'm running into is when I paste the contents of Page 1 onto Page 2 I'm having to readjust the row heights on Page 2. I was hoping the pasted contents would include the formatting (row heights, etc.) of the original contents.

I hope I'm not confusing you with "Pages" and "Sheets". I'm only working with Sheet 1, but with multiple pages.

 

[JoeMo]

Select page 1 and copy. Then paste special "formats" to page 2, then immediately do another paste special and select "all".

 

[meighkee]

Thanks very much Joe. Worked fine. I greatly appreciate your help.

 

[moirangthem]

Not working with me.