ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   View the sheets side by side (https://www.excelbanter.com/new-users-excel/107843-view-sheets-side-side.html)

sk

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

Pete_UK

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



sk

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




Pete_UK

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