قالب وردپرس درنا توس
Home / Tips and Tricks / How to Use the Split-Screen Function of Excel

How to Use the Split-Screen Function of Excel



  Excel Logo

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.

 Screen on the tab

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.

 A1 cell selected

Then go back to the "View" tab and click "Share." Button. This splits your screen into four equal worksheets.

 four equilateral screens Excel

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:

 Horizontal Breakdown in Excel

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.


Source link