Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel's file name incorrectly shows ":" and a number for # of shee
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel's file name incorrectly shows ":" and a number for # of shee
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel's file name incorrectly shows ":" and a number for # of shee
You have inadvertantly added at least two windows with a view of the same
workbook through WindowNew Window. If you go to Window you will see the list. Hit CTRL + w untill only one remains. Save that one. To have two workbooks open side by side, open both then WindowNew Window. WindowArrange to suit. Gord Dibben MS Excel MVP On Sat, 3 Nov 2007 10:01:00 -0700, aligatrjoe wrote: 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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lost "File Menu" - now it's "Edit / View / Insert.." but no "F | Excel Discussion (Misc queries) | |||
When I type "13" the spreadsheet shows "14." Possibilities? | Excel Discussion (Misc queries) | |||
In Excel a cell formatted "currency" shows "######" help! | Excel Worksheet Functions | |||
Truncated font list in Excel's "Insert Symbol" menu selection | Excel Discussion (Misc queries) | |||
Utility to "clean up" or "defrag" large Excel file | Excel Discussion (Misc queries) |