Hi anyone,
Is it possible to view two worksheets of the same workbook; side by side horizontally in Excel. If so how may I do this?
Any help on this would be kindly appreciated.
Thanks in advance.
View Two Worksheets Side by Side
-
- SilverLounger
- Posts: 2347
- Joined: 23 Feb 2010, 12:07
View Two Worksheets Side by Side
Best Regards,
Adam
Adam
-
- Administrator
- Posts: 78647
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: View Two Worksheets Side by Side
In Excel 2007/2010:
- Activate the View tab of the ribbon.
- Click New Window in the Window group of the ribbon.
- Click Arrange All in the Window group of the ribbon.
- Tick the check box "Windows of active workbook".
- Select "Horizontal".
- Click OK.
- Activate the View tab of the ribbon.
- Click New Window in the Window group of the ribbon.
- Click Arrange All in the Window group of the ribbon.
- Tick the check box "Windows of active workbook".
- Select "Horizontal".
- Click OK.
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans
Hans
-
- SilverLounger
- Posts: 2347
- Joined: 23 Feb 2010, 12:07
Re: View Two Worksheets Side by Side
Thanks for the reply Hans. Could this be done through a macro Code so as when the user clicks the macro button in sheet1 only the sheet 2 gets opened in new window as specified in post 41728,
Any help on this would be kindly appreciated.
Any help on this would be kindly appreciated.
Best Regards,
Adam
Adam
-
- Administrator
- Posts: 78647
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: View Two Worksheets Side by Side
To find out, record a macro, then look at the recorded code.
Best wishes,
Hans
Hans
-
- SilverLounger
- Posts: 2347
- Joined: 23 Feb 2010, 12:07