Split (split) your sheet to view multiple parts of the sheet at once in Excel. You can split the sheet into 2 parts, the upper part and the lower part by the following way.
Join the channel Telegram of the AnonyViet 👉 Link 👈 |
How to use Split in Excel
1. First, select a cell in column A.
2. On the View tab, in the Windows group, select Split.
3. Notice the two vertical scroll bars. For example, use the bottom vertical scroll bar to move to row 49. As you can see, the first 6 rows are still visible.
4. To change the layout, use the horizontal divider to adjust it to your liking.
5. To remove split, simply double click on the horizontal split bar.
Note: in a similar way, you can split your window into left and right areas by selecting a cell in row 1 before clicking View -> Split. You can even split your window into 4 regions by selecting a cell that is not column A or row 1. Any changes you make to one area are immediately reflected in the other zones. .
In addition, you can also view many other excel articles here.