Home

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.

224

excel Copy table

Table of Contents

How to copy an Excel table to make it the same size as the original

Copy the excel table to be the same size as the original

Steps 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.

Aug 02, 2023 am 10:45 AM

excel

How to copy an Excel table to make it the same size as the original

Method: 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.

May 06, 2021 pm 02:01 PM

excel Copy table

How to copy and retain the original formula in excel

Copy 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

Jul 30, 2019 am 11:01 AM

excel