Merge worksheets
The Merge feature allows you to combine 2 or more worksheets at a time. This is a very useful tool if you want to quickly create one large worksheet from many.
-
Make sure that you have one worksheet open.
-
From the File menu, select Merge.
-
Select one worksheet or as many others you would like to merge into your current worksheet by using the shift and ctrl keys.
-
Click Open.
Items from the selected worksheets will be added automatically to the current worksheet. Merge will automatically consolidate your worksheet for you.
Purge worksheets
When a worksheet is saved over and over, it grows in size. You can use the Purge command periodically to control a file's size. This command mimics the purge command available in AutoCAD.
Note: This operation cannot be undone. However, a backup file will be created in the same folder as the original file.
-
From the File menu, select Purge.
-
When you see the confirmation message, click Yes.