| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| View tabs side by side? | Excel Discussion (Misc queries) | |||
| Is it possible to compare side by side vertically in Excel 2003? | Excel Discussion (Misc queries) | |||
| Same view for multiple sheets | Excel Discussion (Misc queries) | |||
| xl Headers and Footers always use 3/4 inch side margins??? | New Users to Excel | |||
| There is no way to view multiple sheets from one workbook | Excel Discussion (Misc queries) | |||
Linear Mode
