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 Worksheet tab, 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.