When working with multiple worksheets in a workbook, you may find that you are not happy with the original order of the worksheets. You can move worksheets around, rearranging them into the most logical order. You can also copy worksheets within a workbook. But be carefulcopying and moving worksheets can affect formulas and charts, and moving a worksheet may cause errors in your workbook.
To move a worksheet within a workbook:
To copy a worksheet within a workbook:
To move more than one worksheet, press on the keyboard and click the worksheets you want to move. If the worksheets are not consecutive, then press on the keyboard instead. | |
|