When working with Excel, it is very common to copy a table to a new location. However, the format of the table often changes in the new location. To quickly format the table in the new location the same as the original one, please see below for details:
Step 1: Select the original table;
Step 2: Copy the table to a new worksheet or in the same worksheet. In this post, we copy to a new worksheet;
Step 3: In the worksheet with the original table, select all the table columns by clicking the column headers;
Step 4: Click the "Format Painter" in the "Home" tab from the ribbon;
Please note that one-time click the "Format Painter" for the one-time formatting, and double-click for multiple times formatting.
Step 5: In the new location, click the column headers of all table columns. This is to format all columns the same as the original table;
Step 6: Go back to the original table, and select all the rows by clicking the row headers;
Step 7: Click the "Format Painter" again in the "Home" tab from the ribbon;
Step 8: In the new location, click the row headers of all table rows. This is to format all rows the same as the original table. At this moment, the two tables should be exactly the same for the row and column width, the font, etc.