View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
aligatrjoe aligatrjoe is offline
external usenet poster
 
Posts: 14
Default 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