And then click View > Arrange All, in the Arrange Windows dialog box, select Horizontal option under Arrange, see screenshots: Then click View > New Window to open this worksheet in a new window, see screenshot:ģ. Open your workbook and activate the desired worksheet.Ģ. Normally, most of us may consider viewing the data in two different windows side by side. There is no direct way for us to solve this problem, fortunately, we can use some workaround ways to deal with this task.įreeze both top and bottom row with viewing the data side by sideįreeze both top and bottom row with creating a table Sometimes, there is a large worksheet has long list data, and we want to freeze both the top row and bottom row, so that we can view the top headers row and last row at the same. In Excel, we can easily freeze top row of a worksheet. How to freeze top and bottom row at once in Excel?
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |