Method one, after copying the past, the following has a paste option, you choose to preserve the format on the line. If this paste option is not present, select only the area copy, and then paste, format, and column widths will change depending on the format of the pasted table if you copy the entire table, the margins, and the print area.
Method Two, 1, right-click the sheet tab, such as Sheet1
2. Select "Move or Copy Sheet" to select "Make a copy". As shown in the figure:
3, click "OK" button can be effective.
Note : More wonderful tutorials Please pay attention to the triple computer tutorial section, triple Computer office group: 189034526 welcome you to join