Weirdest thing I ever saw

  • Thread starter Thread starter Steve H.
  • Start date Start date
S

Steve H.

OK................when I open a certain (only one) excel file excel is
opening three separate identical files to the one I open.

Excel will normally not open more than one file with identical names. What
it is doing is naming them as follows filename.xls:1 , filename.xls:2, and
filename.xls:3.

I have never seen a : after the xls extension.

Any of you experts know whats up?

Steve Hubbard
 
These are actually just separate windows into the same excel workbook.

Select one of the windows you don't want and hit ctrl-w to close it.

Repeat until you're down to just one window and save the workbook.

This can be very useful if you want to see different parts of the same
workbook/worksheet at the same time (used in conjunction with window|arrange).
 
Hi Steve,
You can close either of those views and the numbers will disappear
when you have only one view left. Then you can start over again
and create a view to see the numbers reappear with View, New Window.

Very useful for looking at a total on a worksheet at the same time
you scroll around, or for looking at one worksheet while scrolling
through another worksheet.

It won't do you much good if the spreadsheet is maximized, so use
the restore button next the close button to get out of maximized view.
The on the view menu you can choose tiled, for instance. That is if
you want to experiment with multiple views.
-
 
Thanks alot Dave. I never experienced that before. Sounds handy though. How
would I duplicate this if I wanted to do it again?

Steve Hubbard
 
Thanks again.

Steve


David McRitchie said:
Hi Steve,
You can close either of those views and the numbers will disappear
when you have only one view left. Then you can start over again
and create a view to see the numbers reappear with View, New Window.

Very useful for looking at a total on a worksheet at the same time
you scroll around, or for looking at one worksheet while scrolling
through another worksheet.

It won't do you much good if the spreadsheet is maximized, so use
the restore button next the close button to get out of maximized view.
The on the view menu you can choose tiled, for instance. That is if
you want to experiment with multiple views.
-
Click to expand...
 
You're welcome, doesn't usually happen that we do actually
manage to answer the question before it's asked <grin>
One of the other Davids
 
Back
Top