| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel worksheet has seperated - How do I return to a single W/S?
I am using Microsoft Office XP Home.
Why has my Excel worksheet changed? Can I return it to its original form? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel worksheet has seperated - How do I return to a single W/S?
No idea what what your problem is other than something doesn't look right to
you. Do you have a Workbook open? Do you have multiple worksheets in that workbook? Do you have multiple views(windows) of one or more of those worksheets? More detail please or a screenshot of the window. BTW...........what is Microsoft Office XP Home? XP Home is a Windows version. Office XP is Office 2002 version. Gord Dibben MS Excel MVP On Sat, 19 May 2007 09:57:25 -0700, Wally Pierce <Wally wrote: I am using Microsoft Office XP Home. Why has my Excel worksheet changed? Can I return it to its original form? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel worksheet has seperated - How do I return to a single W/
"Gord Dibben" wrote: No idea what what your problem is other than something doesn't look right to you. It not only doesn't look right, but it is very awkward to work with! Do you have a Workbook open? Yes, but It is hard to explain - The best I can say is that it is two windows with one inside the other. In order to open up the inside window you first have to open (widen) the outside window first. This is making it very awkward to work with more than one worksheet. I have to keep changing the size of all worksheets in order to work with the one I want. (is this making any sence?) Do you have multiple worksheets in that workbook? yes Do you have multiple views(windows) of one or more of those worksheets? yes More detail please or a screenshot of the window. How do I make a screenshot and how can I show it to you? BTW...........what is Microsoft Office XP Home? There are two versions - Home & Business. XP Home is a Windows version. Yes, they are both Windows versions. Office XP is Office 2002 version. I am not familure with that. Gord Dibben MS Excel MVP On Sat, 19 May 2007 09:57:25 -0700, Wally Pierce <Wally wrote: I am using Microsoft Office XP Home. Why has my Excel worksheet changed? Can I return it to its original form? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel worksheet has seperated - How do I return to a single W/
If you click on Window | Arrange you will be presented with a series
of choices regarding how to arrange your windows within the Excel window - click Horizontal and you will see the windows arranged one above the other to fit your screen resolution. Hope this helps. Pete On May 19, 7:47 pm, Wally Pierce wrote: "Gord Dibben" wrote: No idea what what your problem is other than something doesn't look right to you. It not only doesn't look right, but it is very awkward to work with! Do you have a Workbook open? Yes, but It is hard to explain - The best I can say is that it is two windows with one inside the other. In order to open up the inside window you first have to open (widen) the outside window first. This is making it very awkward to work with more than one worksheet. I have to keep changing the size of all worksheets in order to work with the one I want. (is this making any sence?) Do you have multiple worksheets in that workbook? yes Do you have multiple views(windows) of one or more of those worksheets? yes More detail please or a screenshot of the window. How do I make a screenshot and how can I show it to you? BTW...........what is Microsoft Office XP Home? There are two versions - Home & Business. XP Home is a Windows version. Yes, they are both Windows versions. Office XP is Office 2002 version. I am not familure with that. Gord Dibben MS Excel MVP On Sat, 19 May 2007 09:57:25 -0700, Wally Pierce <Wally wrote: I am using Microsoft Office XP Home. Why has my Excel worksheet changed? Can I return it to its original form?- Hide quoted text - - Show quoted text - |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel worksheet has seperated - How do I return to a single W/
I forgot to add - when you can see all windows, you can close unwanted
ones in turn by clicking the Close icon at the top of the sheet window (not the Excel window) until you have only one left, and then click on the Restore icon to maximise this. Save the file, and the next time you open it you will have only one window visible. Hope this helps. Pete On May 19, 9:12 pm, Pete_UK wrote: If you click on Window | Arrange you will be presented with a series of choices regarding how to arrange your windows within the Excel window - click Horizontal and you will see the windows arranged one above the other to fit your screen resolution. Hope this helps. Pete On May 19, 7:47 pm, Wally Pierce wrote: "Gord Dibben" wrote: No idea what what your problem is other than something doesn't look right to you. It not only doesn't look right, but it is very awkward to work with! Do you have a Workbook open? Yes, but It is hard to explain - The best I can say is that it is two windows with one inside the other. In order to open up the inside window you first have to open (widen) the outside window first. This is making it very awkward to work with more than one worksheet. I have to keep changing the size of all worksheets in order to work with the one I want. (is this making any sence?) Do you have multiple worksheets in that workbook? yes Do you have multiple views(windows) of one or more of those worksheets? yes More detail please or a screenshot of the window. How do I make a screenshot and how can I show it to you? BTW...........what is Microsoft Office XP Home? There are two versions - Home & Business. XP Home is a Windows version. Yes, they are both Windows versions. Office XP is Office 2002 version. I am not familure with that. Gord Dibben MS Excel MVP On Sat, 19 May 2007 09:57:25 -0700, Wally Pierce <Wally wrote: I am using Microsoft Office XP Home. Why has my Excel worksheet changed? Can I return it to its original form?- Hide quoted text - - Show quoted text -- Hide quoted text - - Show quoted text - |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel worksheet has seperated - How do I return to a single W/
Wally
Sounds like your windows are not maximized properly. Try this. Close Excel Go to the Start button on the Windows Taskbar........lower left end and hit that button. Select Run and type in excel.exe then "Run" This should open Excel with no workbook. Hit the Maximize button on the title bar at top. Now FileOpen and pick a file to open. Maximize it also if not maximized. As to the other stuff..................you can make a screen shot by hitting PrtScrn and pasting into MS Paint or similar then saving as a *.jpg file and posting that file. Sorry, I forgot there was a Microsoft Office XP Home version MS Office XP is also known as MS Office 2002. Gord On Sat, 19 May 2007 11:47:01 -0700, Wally Pierce wrote: "Gord Dibben" wrote: No idea what what your problem is other than something doesn't look right to you. It not only doesn't look right, but it is very awkward to work with! Do you have a Workbook open? Yes, but It is hard to explain - The best I can say is that it is two windows with one inside the other. In order to open up the inside window you first have to open (widen) the outside window first. This is making it very awkward to work with more than one worksheet. I have to keep changing the size of all worksheets in order to work with the one I want. (is this making any sence?) Do you have multiple worksheets in that workbook? yes Do you have multiple views(windows) of one or more of those worksheets? yes More detail please or a screenshot of the window. How do I make a screenshot and how can I show it to you? BTW...........what is Microsoft Office XP Home? There are two versions - Home & Business. XP Home is a Windows version. Yes, they are both Windows versions. Office XP is Office 2002 version. I am not familure with that. Gord Dibben MS Excel MVP On Sat, 19 May 2007 09:57:25 -0700, Wally Pierce <Wally wrote: I am using Microsoft Office XP Home. Why has my Excel worksheet changed? Can I return it to its original form? |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel worksheet has seperated - How do I return to a single W/
Thank you - you came up with the answer. I still don't know how my excel got
into in that situation, but you figured it out. Now, if only I will remember the solution, if that happens again. Thank you - thank you - Thank you!!! Wally Pierce "Gord Dibben" wrote: Wally Sounds like your windows are not maximized properly. Try this. Close Excel Go to the Start button on the Windows Taskbar........lower left end and hit that button. Select Run and type in excel.exe then "Run" This should open Excel with no workbook. Hit the Maximize button on the title bar at top. Now FileOpen and pick a file to open. Maximize it also if not maximized. As to the other stuff..................you can make a screen shot by hitting PrtScrn and pasting into MS Paint or similar then saving as a *.jpg file and posting that file. Sorry, I forgot there was a Microsoft Office XP Home version MS Office XP is also known as MS Office 2002. Gord On Sat, 19 May 2007 11:47:01 -0700, Wally Pierce wrote: "Gord Dibben" wrote: No idea what what your problem is other than something doesn't look right to you. It not only doesn't look right, but it is very awkward to work with! Do you have a Workbook open? Yes, but It is hard to explain - The best I can say is that it is two windows with one inside the other. In order to open up the inside window you first have to open (widen) the outside window first. This is making it very awkward to work with more than one worksheet. I have to keep changing the size of all worksheets in order to work with the one I want. (is this making any sence?) Do you have multiple worksheets in that workbook? yes Do you have multiple views(windows) of one or more of those worksheets? yes More detail please or a screenshot of the window. How do I make a screenshot and how can I show it to you? BTW...........what is Microsoft Office XP Home? There are two versions - Home & Business. XP Home is a Windows version. Yes, they are both Windows versions. Office XP is Office 2002 version. I am not familure with that. Gord Dibben MS Excel MVP On Sat, 19 May 2007 09:57:25 -0700, Wally Pierce <Wally wrote: I am using Microsoft Office XP Home. Why has my Excel worksheet changed? Can I return it to its original form? |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel worksheet has seperated - How do I return to a single W/
Thanks for the feedback.
Sometimes we guess correctly. I sent you the long way 'round through the StartRun just in case but you could probably have done it from your original view of Excel Window and the worksheet. Gord On Sat, 19 May 2007 20:42:01 -0700, Wally Pierce wrote: Thank you - you came up with the answer. I still don't know how my excel got into in that situation, but you figured it out. Now, if only I will remember the solution, if that happens again. Thank you - thank you - Thank you!!! Wally Pierce "Gord Dibben" wrote: Wally Sounds like your windows are not maximized properly. Try this. Close Excel Go to the Start button on the Windows Taskbar........lower left end and hit that button. Select Run and type in excel.exe then "Run" This should open Excel with no workbook. Hit the Maximize button on the title bar at top. Now FileOpen and pick a file to open. Maximize it also if not maximized. As to the other stuff..................you can make a screen shot by hitting PrtScrn and pasting into MS Paint or similar then saving as a *.jpg file and posting that file. Sorry, I forgot there was a Microsoft Office XP Home version MS Office XP is also known as MS Office 2002. Gord On Sat, 19 May 2007 11:47:01 -0700, Wally Pierce wrote: "Gord Dibben" wrote: No idea what what your problem is other than something doesn't look right to you. It not only doesn't look right, but it is very awkward to work with! Do you have a Workbook open? Yes, but It is hard to explain - The best I can say is that it is two windows with one inside the other. In order to open up the inside window you first have to open (widen) the outside window first. This is making it very awkward to work with more than one worksheet. I have to keep changing the size of all worksheets in order to work with the one I want. (is this making any sence?) Do you have multiple worksheets in that workbook? yes Do you have multiple views(windows) of one or more of those worksheets? yes More detail please or a screenshot of the window. How do I make a screenshot and how can I show it to you? BTW...........what is Microsoft Office XP Home? There are two versions - Home & Business. XP Home is a Windows version. Yes, they are both Windows versions. Office XP is Office 2002 version. I am not familure with that. Gord Dibben MS Excel MVP On Sat, 19 May 2007 09:57:25 -0700, Wally Pierce <Wally wrote: I am using Microsoft Office XP Home. Why has my Excel worksheet changed? Can I return it to its original form? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| extracting comma seperated from a single cell and auto populating in selected cells o | Excel Discussion (Misc queries) | |||
| Exctracting comma seperated data from a single cell | Excel Discussion (Misc queries) | |||
| Find Multiple instances of Single Criterion in Row & Return To a Single Col | Excel Worksheet Functions | |||
| Splitting data in a single cell that is seperated by commas, then moving to make individual rows | Excel Discussion (Misc queries) | |||
| Save a single worksheet in Excel as a single file. | New Users to Excel | |||
Linear Mode
