16 total posts
Opening two Excel workbooks side by side.
Minimise the two (or more) opened Excel workbooks to the task bar. Right click at an empty area of the task bar, and from the cpntext menu. Choose Tile windows virtically (or horizontally). Before closing the windows, remember to untile.
Re: Opening two Excel workbooks side by side
Papa Echo, I tried your instructions but to no avail. Even if I reduce the size of both workbooks only one will appear. Soon as I click on the other excel Workbook (button) on the taskbar it comes up and the other one disappears back to the taskbar. I have tried tiling, locking and unlocking the the taskbar but nothing seems to work.
You are not.....
supposed to click at the icon at the task bar. I mentioined an empty area . Try again. It should work. It is designed to work this way.
I didn't state things cleary
I guess I didn't state what I did clearly. When I click on the task bar and then click on tile vertically or horizontally only one excel workbook opens up, other things on the task bar tile correctly, but just not the 2nd workbook.
...select the minimised files (at the task bar) which you want to tile by highlighting one icon, press down Ctrl and select another file... Then right click at one of the selected file icon, or an empty area of the task bar....
The problem may be caused by somethng else.
Both workbooks were opened via useing a shortcut on my desktop. Following Kees advice and opening the workbooks from within Excel seems to solve the problem. For some reason windows doesn't seem to want to tile the Excel workbooks when opened via a shortcut.
Re: more windows side by side
As long as they aren't maximized you can change the size of each window (not only Excel, but most applications) by dragging the margins of the window around (when the cursus has become a double sided arrow) and drag it around by a left click in the (blue) title bar, then moving your mouse.
That way, you can get as many windows in any size and position you like on the screen. It's just as easy to put Excel next to Excel as it is to put Internet Explorer next to Word.
Hope this helps.
No Problem opeing windows side by side
Kees, I have no problem opening windows side by side. Just can't open two excel workbooks open side by side. What I have had to do is convert a particular spreadsheet from a workbook into word format. Then I can have the word document ( converted excel spreadsheet)along side my other excell workbook.
Before you do....
...what Kees suggested, configure the system (at Folder Options) to open files with their own windows. If you then reduce the sizes of the windows of the two separate Excel files, you can resize and slide them into position.
However, "tile windows" mentioned above will do that automatically whether you have configured files to open in the same window or separate windows. This works with "windows" generally: Internet Explorer and Firefox side by side, a received e-mail and its reply, MS Word side by side with a web page for reference when writing the term paper, etc.
Re: excel windows
It might not work, maybe, if you open the two workbooks in one instance of the application (by clicking on the xls-file in Windows Explorer). I didn't try it.
But it should surely work if you run Excel from Start>Programs or from an icon on your desktop and File>Open to open the first workbook, and then repeat the same procedure to open the second workbook (so run twice from Start>Programs). That way it are totally independent applications, like Excel and Word. No reason to expect any problems. In fact, I just did it here and it worked as expected.
Give it a try, and post back.
That worked. I much appreciate your input. I am now a happy camper.
Forgot to say which worked
Going through Start, then to excel and opening up the workbook and then doing it again for the second workbook.
(NT) You're welcome.
Did you try the Excel 2000 menu Window - Arrange"?
I didn't see anyone mention the menus in Excel 2000. They built in the exact tool to do just this. Maybe it's overlooked: The "Window" menu (next to Help) has an "Arrange" button where you can choose the typical cascade, vertical, horizontal, etc.
It's one of the things I never use, alas.
Just yesterday I had to copy information from a series of spreadsheets to one other spreadsheet, and it certainly should have been useful had I realized this.