Splitting screens (vertical or horizontal) is an excellent way to optimize your workflow when using Excel. With this feature, you can simultaneously view individual sections of a spreadsheet to quickly compare data. That's how it's done.
Using Split Screen
If a table is populated with data, navigating the table can be very cumbersome, especially if you want to compare data from different sections of the table. By using the Split Screen feature of Excel, this process can be optimized. In Excel, you can also customize the layout of the screen so you have complete control over your specific needs.
Finding the Split Screen feature is easy enough. Just go to the "View" tab and click on the "Share" option.
That is, there are some ways to divide the screen
Creating four equal quadrants
In Excel, you can divide the screen into four equal quadrants split. This will give you four copies of your current worksheet on the same screen! First, make sure that you have selected the A1 cell.
Then go back to the "View" tab and click "Share." Button. This splits your screen into four equal worksheets.
You can also adjust the position of the division by clicking and dragging on one side of a worksheet or the middle area
Vertical and Horizontal Splits
If you do not need four copies of the worksheet, you can split the screen into two parts instead. Depending on your needs, you can divide the screen horizontally or vertically.
To divide the screen horizontally, select a cell from column A on any row (except for the A1 cell). Then click on the "Share" button on the "View" tab. The split is displayed above the selected line. For example, if we select cell A5, the partition looks like this:
Splitting the screen vertically is just as easy. Select a cell from any column (except column A) in row 1 and click the "Share" button.
<img class = "alignnone size-full wp-image-411803" data-pagespeed-lazy-src = "https://www.howtogeek.com/wp-content/uploads/2019/04/xsplit-screen -vertically.png.pagespeed.gp + jp + jw + pj + ws + js + rj + rp + rw + ri + cp + md.ic.wIdu-FjfhE.png "alt =" Vertical Screen "width =" 276 " height = "288" src = "/ pagespeed_static / 1. JiBnMqyl6S.gif" onload = "pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon (this);" onerror = "this.onerror = null; pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon (this); [19459024IfyouselectanycellfromarowthetableissplitandtheonlythingtokeepinmindisthatifyoudonotselectacellfromthefirstroworfromcolumnAthescreenwillbeinfourinsteadofintwoisshared
<img class = "alignnone size-full wp-image-411804" data-pagespeed-lazy-src = "https://www.howtogeek.com/wp-content/uploads/2019/04 /xuneven-screen-split.png.pagespeed.gp+jp+jw+pj+ws+js+rj+rp+rw+ri+cp+md.ic.cbMxzuolG8.png " alt = "uneven screen split" width = "252" height = "342" src = "/pagespeed_static/1.JiBnMqyl6S.gif" onload = "pagespeed.lazyLoadImages.favisibleAndMaybeBeacon (this);" onerror = "this.onerror = null; pagespeed.la_LoadImages.loadIfVirachArrada is this; 19659005] When you're done with the feature and you're ready to switch the screen back to a single worksheet, just click the Share option again to turn it off. Alternatively, you can drag the sides of the split screen bars to the edge of the window to disable the feature.