Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Split file
Hi there,
I keep accidentally splitting Excel files that I have open. So that when I look on my Windows drop down menu, I see: Orange file.xls:1 Orange file.xls:2 What am I doing wrong? Thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Split file
Clicking WINDOW in the menu & selecting NEW WINDOW opens another window with
the same workbook. There aren't 2 different versions of the file, just two views of the same file, which is handy if you need to make edits in one area of the workbook and wish to see the impact of those edits on formulas in other areas of the workbook. Click the Close Window command button, the smaller x button on the right side of the menu bar to close extra windows. -- Kevin Backmann "Sarah" wrote: Hi there, I keep accidentally splitting Excel files that I have open. So that when I look on my Windows drop down menu, I see: Orange file.xls:1 Orange file.xls:2 What am I doing wrong? Thanks! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Split file
You're choosing Windows/New Window from the menu (either directly or
with a keyboard shortcut or macro). If you close all but one of the windows, then save the file, there should only be one window when you next open the file. In article , Sarah wrote: Hi there, I keep accidentally splitting Excel files that I have open. So that when I look on my Windows drop down menu, I see: Orange file.xls:1 Orange file.xls:2 What am I doing wrong? Thanks! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Split file
You are activating WindowNew Window.
Close one of them then save. Gord Dibben MS Excel MVP On Mon, 22 Oct 2007 07:14:05 -0700, Sarah wrote: Hi there, I keep accidentally splitting Excel files that I have open. So that when I look on my Windows drop down menu, I see: Orange file.xls:1 Orange file.xls:2 What am I doing wrong? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I split screen an excel and abobe scanned file? | Excel Discussion (Misc queries) | |||
Why do I have a split screen on a saved Excel file? | Excel Discussion (Misc queries) | |||
i want to open large file 300 col, how to split between worksheets | Excel Discussion (Misc queries) | |||
Split a Value | Excel Discussion (Misc queries) | |||
Is it possible to view Excel split screen by tab within same file | Excel Discussion (Misc queries) |