Excel's file name incorrectly shows ":" and a number for # of
Both of you were very helpful. Thanks a lot.
--
Bill W
"RagDyeR" wrote:
That number following the colon in the Title bar is indicating how many
"Windows" exist of the WS.
Repeat :
<Ctrl < W
Until the number disappears ... THEN <Save
Each time you click on:
<Window <New Window
You create an additional copy of the WS, where you can then go to:
<Window <Arrange
And select a configuration to display concurrent, multiple views of the same
WS.
--
HTH,
RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===
"aligatrjoe" wrote in message
...
Wanting to understand why Excel adds a colon and a number for number of
sheets in its Title Bar. Really have two questions. First I deleted 7 of 9
sheets in an .xls file, resaved to a new file name, reloaded same and file
name still had the colon and 9 sheets. Looked like: myfile.xls:9 So how
do I correct this? Secondly, if I have two excel files open and I switch
them by looking on the task bar, I would prefer to view only the two files,
not all of the sheets as is happening now. Haven't figured out how to
accomplish this.
Would appreciate any help.
--
Bill W
|