Horizontal - windows are placed one below another.Tiled - windows are arranged as equally sized squares in the order you opened them.Or choose another option that suits you best: In the Arrange Windows dialog box, select Vertical to place the sheets next to each other. To change the default composition, click the Arrange All button on the View tab. When using the View Side by Side feature, Excel positions two windows horizontally. How to arrange sheets side-by-side vertically In case you have more than two files open, the Compare Side by Side dialog box will pop up asking you to choose the workbook to be compared with the active one. In each workbook window, click the tab you want to compare.To view two sheets in different workbooks side by side, this is what you need to do: To arrange the tabs vertically, use the Arrange All feature. The image below shows the default horizontal arrangement. In each window, click the desired sheet tab.On the View tab, in the Window group, click View Side by Side.This will open another window of the same workbook. On the View tab, in the Window group, click New Window.If the sheets you want to compare are in the same workbook, here are the steps to place them side by side: How to view two Excel sheets side by side
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |