Arrange all
When you have multiple workbooks open in Excel, you can arrange them by going to the "View" menu ribbon, and selecting "Arrange All" from the Window section. The workbooks can be arranged 4 ways:
•
Tiled
•
horizontal
•
vertical,
•
cascade.
Tiled :
Tiled: Select this option button to have Excel arrange and
size the windows so that they all fit side by side on the screen in the order
in which you opened them.
horizontal :
Select this View button to have Excel , click the arrange all and choose the Horizontal and view .
Vertical:
Select this View button to have Excel , click the arrange all and choose the Vertical and view