To have it done, select column D on the left of which the split should be made:Īs the result, the worksheet is divided into two vertical panes, each having its own scrollbar. In the dataset below, suppose you want to display the item details (columns A through C) and sales numbers (columns D through H) in separate panes. 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |