View Different Parts of a Worksheet at Once in Excel

Add to Favorites

View different sections of the same worksheet when the sections are far apart.  This allows you to better work on large spreadsheets that contain a lot of data.

Steps to View Multiple Different Sections of a Worksheet at Once

  1. Go to the View tab and click the Split button:
  2. Once you do that, your screen will be divided into 4 sections:

    You have 4 different views of the same worksheet.
  3. Click on the middle of the dividers that appeared and resize them so they work for your data:

    If you move the dividers all the way to the top, you will have a dual split screen like this:

    If you move them all the way to the left, the screen will be split like this:

    To get back to the original 4 way split, just click the Split button on the View tab once to remove it all and then again to bring it back.
  4. Once you have the view that you want, move the sliders at the bottom of the window and to the right of the window to adjust the view.  This might be a little confusing at first, so play around with it until you get what you want.

If I was going to view all 4 sections of the worksheet without using this view feature, I would have to zoom out or have a big monitor and it would look like this:

Notes

To go back to the default view, click the Split button again on the View tab.

This view is kind of confusing to use at first.  Play around with it until you understand how it works and become comfortable with the interface.  When working on large worksheets, this view is a really helpful feature to use.

Download the sample worksheet that comes with this tutorial so you can try this out and see how it works.


Downloadable Files: Excel File

Similar Content on TeachExcel
View Separate Parts of a Worksheet at Once in Excel
Tutorial: View separate parts of a large worksheet while in the same Excel window. This allows you t...
Display all Formulas at Once in Excel
Tutorial: How to view all of the formulas at once in Excel so that you can troubleshoot the spreadsh...
Print All Worksheets at Once in Excel
Tutorial: How to print all worksheets at once from Excel. This saves you the time of having to go to...
Print Only Specific Parts of a Worksheet in Excel
Tutorial: In Excel you can select parts of a worksheet to print while ignoring all of the other data...
Filter Data Sets on Multiple Columns with Multiple Criteria at Once in Excel - AutoFilter
Macro: This Excel macro allows you to filter a data set on multiple columns and criteria at o...
Quickly Resize Multiple Columns or Rows at Once in Excel
Tutorial: How to quickly resize multiple columns and rows at once in Excel.  This avoids having to ...