View Two Worksheets Side by Side

[adam]

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.

[HansV]

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.

x504.png

[adam]

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.

[HansV]

To find out, record a macro, then look at the recorded code.

[adam]

Thanks for the reply I've got it solved.