To separate two areas of the spreadsheet vertically, select the column to the right of the column where you wish the split to appear and click the Split button. On the View tab, in the Windows group, click the Split button.ĭepending on your selection, the worksheet window can be divided horizontally, vertically or both, so you have two or four separate sections with their own scrollbars.Select the row/column/cell before which you want to place the split.To split up a worksheet into two or four parts, this is what you need to do: Splitting is a one-click operation in Excel. Splitting screen between two different sheets.This can be done by using Excel's Split Screen feature. When working with large datasets, it can be helpful to see a few areas of the same worksheet at a time to compare different subsets of data. In this article, you'll learn how to display certain rows and/or columns in separate panes by splitting the worksheet into two or four parts.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |