After freeze the bottom row, now, you need to freeze the top row in the above worksheet, please click one cell in the above window, and click View > Freeze Panes > Freeze Top Row, see screenshot: 6. Then click OK, and now, you can see the two workbooks have been arranged horizontally, you can adjust the vertical height of both windows to your need, and scroll down to the bottom row in the below worksheet. And then click View > Arrange All, in the Arrange Windows dialog box, select Horizontal option under Arrange, see screenshots: Tip: If there are multiple opened workbooks, you need to check Windows of active workbook option. Then click View > New Window to open this worksheet in a new window, see screenshot: 3. Open your workbook and activate the desired worksheet. Normally, most of us may consider viewing the data in two different windows side by side.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |