View the sheets side by side
Hello,
I have data spread across two sheets. When I click sheet1 it will occupy the whole window. When I click sheet2, it is the same. I want to see both sheets at one time so that I can see data in sheet1 and side by side the corresponding data for sheet2 thanks, sk1234 |
View the sheets side by side
Click on Window | New then Window | Arrange | Vertical.
Hope this helps. Pete sk wrote: Hello, I have data spread across two sheets. When I click sheet1 it will occupy the whole window. When I click sheet2, it is the same. I want to see both sheets at one time so that I can see data in sheet1 and side by side the corresponding data for sheet2 thanks, sk1234 |
View the sheets side by side
Thaks. It works fine.
"Pete_UK" wrote: Click on Window | New then Window | Arrange | Vertical. Hope this helps. Pete sk wrote: Hello, I have data spread across two sheets. When I click sheet1 it will occupy the whole window. When I click sheet2, it is the same. I want to see both sheets at one time so that I can see data in sheet1 and side by side the corresponding data for sheet2 thanks, sk1234 |
View the sheets side by side
Thanks for feeding back.
Pete sk wrote: Thaks. It works fine. "Pete_UK" wrote: Click on Window | New then Window | Arrange | Vertical. Hope this helps. Pete sk wrote: Hello, I have data spread across two sheets. When I click sheet1 it will occupy the whole window. When I click sheet2, it is the same. I want to see both sheets at one time so that I can see data in sheet1 and side by side the corresponding data for sheet2 thanks, sk1234 |
All times are GMT +1. The time now is 08:33 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com