Forum Discussion
how to Duplication a page layout on the same worksheet.
how do I Duplication a page layout on the same worksheet.
What do you mean under Page Layout? Here are margins, page size, background picture, but they are the same for all page on the sheet.
- Select the range of cells or the page layout that you want to duplicate.
Press Ctrl+C on your keyboard to copy the selected range.
Move the cursor to the destination location within the same worksheet where you want to duplicate the page layout.
Press Ctrl+V on your keyboard to paste the copied range.
The selected page layout will now be duplicated in the destination location within the same worksheet, including the formatting and content if applicable.thanks Niko but that doesn't work, it doesn't give me the same column widths.
- Thank you for your feedback. Could you please add additional information such as the Excel file (without sensitive data) or photos, excel version, file .extension, storage medium, operating system, etc.
This would help considerably to give you a concrete solution proposal or approach.
Thank you for your patience and understanding.
