To print the History worksheet, click Print
.
To copy the history to another workbook, select the cells you want to copy, click Copy
, switch to another workbook, click where you want the copy to go, and click Paste
.
When you copy or print the history, you may also want to save or print a separate copy of the shared workbook. If the workbook continues to change as you or others work on it, the history that you copied may no longer apply. For example, cell locations, including row numbers, in the copied history may no longer be current.
If the shared workbook is protected, point to Protection on the Tools menu, and then click Unprotect Shared Workbook. Enter the password if prompted, and then click OK.
If the shared workbook is not protected, click Share Workbook on the Tools menu. Click the Advanced tab, and then click Don't keep change history.