How to Copy an Excel Worksheet with Photos and Formatting Intact
Question details
The user needs to duplicate a client data worksheet for a new month without losing or distorting photos, layout, and formatting.
- Product
- Excel
- Device & OS
- not provided
- Scenario
- Creating new monthly spreadsheet tabs based on an existing client data template that contains embedded images and specific formatting.
- Observed behavior
- When copying and pasting data into a new blank worksheet, formatting is distorted, and photos are either missing or incorrectly resized.
Make sure you save your current workbook before duplicating sheets, and if you intend to copy the worksheet to a different file, ensure that the destination workbook is currently open.
Duplicate the Entire Worksheet Using 'Move or Copy'
Using the built-in 'Move or Copy' tool is the most reliable method to clone a worksheet while keeping all images, formulas, column widths, and formatting exactly as they are.
Standard copy-and-paste operations often fail to retain column widths and row heights, causing images to distort or misalign to the new default grid. Duplicating the sheet at the tab level bypasses the clipboard and perfectly replicates the original layout.
Locate the sheet tab you want to copy at the bottom of your Excel window and right-click on it to open the context menu.
Click on 'Move or Copy...' from the list of options.
In the dialog box, use the 'To book' dropdown to select where you want the copied sheet to go. You can keep it in the current workbook or choose another open workbook.
Check the box at the bottom that says 'Create a copy'. This is crucial, otherwise the sheet will be moved instead of duplicated.
Select the position where you want the new tab to appear under 'Before sheet', then click 'OK'. Your new monthly tab is now perfectly duplicated.
Easily Duplicate Worksheets with WPS Spreadsheet
WPS Office provides a powerful, highly compatible spreadsheet tool that lets you seamlessly duplicate complex worksheets, preserving high-resolution photos and intricate formatting with just a few clicks.
- 1. Open your file in WPS: Launch WPS Spreadsheet and open the workbook containing the worksheet you want to copy.
- 2. Right-click the sheet tab: Right-click the specific worksheet tab at the bottom of the screen.
- 3. Select Move or Copy: Click 'Move or Copy Sheet' from the right-click menu.
- 4. Create the copy: Check the 'Create a copy' box, select the desired placement, and click 'OK' to finish.
Frequently Asked Questions
Why do my photos resize when I standard copy and paste in Excel?
When you use regular copy and paste (Ctrl+C and Ctrl+V), Excel attempts to fit the copied content into the destination cells. If the destination cells have different column widths or row heights than the original, the embedded photos will stretch, shrink, or distort to match the new grid.
Can I copy a formatted worksheet to a completely different workbook?
Yes. Open both the original and the target workbook. Right-click the worksheet tab you want to copy, select 'Move or Copy', and in the 'To book' drop-down menu, select the name of the target workbook. Remember to check 'Create a copy' before clicking OK.
How do I duplicate multiple worksheets at the same time?
Hold down the 'Ctrl' key (or 'Cmd' on a Mac) and click on each sheet tab you want to duplicate so they are all highlighted. Then, right-click on one of the selected tabs, choose 'Move or Copy', check 'Create a copy', and click OK.
Will formulas break when I duplicate a worksheet?
No, duplicating the entire worksheet using the 'Move or Copy' feature keeps all internal cell references perfectly intact. However, if your formulas reference cells on other sheets, they will continue to point to those original sheets unless manually updated.
