General Excel Question

[H.Schurch]

Dear Experts

I work for a large company. The spreadsheet I often use has as all
worksheets its name listed above the toolbar. But also includes a semicolon
) after the name and a number. What I would like to know what the number
after the name represents. Could one of you experts satisfy my curiosity.

Regards

Hans

 

[Debra Dalgleish]

You have more than one window open in the workbook. To close the
additional windows, click the lower X at the top right of the Excel
window. There's a picture here:

http://www.contextures.com/xlfaqApp.html#TwoWindows

The additional windows are created if you choose Window>New Window.

 

[Dave Peterson]

You can make new "views" into your workbook by:

Window|new window

This allows you to use Window|arrange|Horizontal/Vertical/tiled and you can see
different parts of the workbook in different windows.

You can use it to see stuff in different worksheets or even stuff in different
parts of the same worksheet.

If you don't like this, you can select the window you don't want and hit ctrl-w.

When the title bar returns to normal (no :#), remember to save your workbook (so
you won't have to clean this up again).

 

[JE McGimpsey]

It means you have more than one window open to the same workbook
(Window/New Window). Close all but one window and the colon-number will
disappear.