Explainry Tutorials to Expert in IT

Split Worksheet in Excel

If you want to view different distant parts of a worksheet of Excel at once on your screen, you can split the worksheet in Excel by following steps:

1. Select a cell, from where you want to split a worksheet. 2. In the View tab, select the Split option in Window section. you may perform the same command by pressing one by one Alt, W, and S.

3. Excel will create a horizontal line and two vertical scroll bars, by using them you can view line no 21 while keeping line no 7 visible at once.

4. To remove the split, simply double-click on it or press one by one Alt, W, and S.

Note: You may split the worksheet horizontally or into a left and right pane by clicking on a column where you want the split then repeat same above-mentioned steps.

Copyright © 2016 - 2020 Explainry.com | All Rights Reserved