Excel Optimize

Problem: As shown in Fig. 57, and without any apparent reason, a “:2” appeared after the spreadsheet name in the title bar of your spreadsheet. What is this and what caused it?

Strategy: This is an annoying thing. It got turned on when you accidentally chose Window – New Window from the menu. This setting applies to the workbook and persists from one usage of Excel to the next, so it is possible that the :2 showed up months ago and has been stuck there ever
since. The other symptom is that you appear have two copies of the same workbook open in the Window menu as shown in Fig. 58.

To remove the :2, switch to the :2 version of the workbook. Use the black X to close that window, as shown in Fig. 59.

This will close the second window of the workbook and both the :2 and :1 will be removed from the title bar.

Additional Information: Is there ever a time that you would want to use this feature? Is it useful to have two versions of the workbook? Yes. Let’s say that you want to see both Sheet1 and Sheet2 of the workbook at the same time. Follow these steps:
1) From the menu, select Window – New Window.
2) In the :2 version of the workbook, switch to Sheet2.
3) From the menu, select Window – Arrange.
4) In the Arrange dialog, choose Windows of Active Workbook and Vertical. Choose OK.

Result: As shown in Fig. 60, you can see the two different sheets, side by side.
Summary: The :2 usually happens when you accidentally choose Window – New Window. It can be removed. In certain instances it can also be useful.