Home >Topic List >How to copy an Excel table to make it the same size as the original
How to copy an Excel table to make it the same size as the original
This topic brings you related articles on how to copy an excel table to be as large as the original to help you solve the problem.
Copy the excel table to be the same size as the originalSteps to copy a table in Excel to the same size as the original: 1. Open the Excel table to be copied and select the cell range to be copied; 2. Copy the selected cell range; 3. Right-click the mouse on the location to be pasted. Select "Paste Option"; 4. Paste the table to the new location; 5. Adjust the size of the new table. You can adjust multiple borders at the same time to maintain the width and height ratio of the original table; 6. Check the format of the new table to ensure that the new table The format is the same as the original table, including font, font size, color, border, etc.
How to copy an Excel table to make it the same size as the originalMethod: First open the excel table that needs to be operated and select the cells that need to be copied; then right-click the mouse and select "Copy" in the pop-up right-click menu; then open another excel table and select the specified cell; finally click the right mouse button. , select "Paste" in the pop-up right-click menu.
How to copy and retain the original formula in excelCopy and retain the original formula in excel: 1. First open an excel table, and then select the formula you want to copy. 2. Click the right button of the mouse and "Copy". 3. Select a suitable location to paste. 4. Then click the right button of the mouse and "Paste Special". 5. Then select "Formula" and click "OK", and then you are done
Related Resource DownloadsMore>
Related TutorialsMore>