Benefits Of The Split Command In Excel 2007
February 11, 2010 by Elliott Harris
Filed under Online Trainings
The Split command can be found in the View Tab of the Excel Ribbon. It allows you to split an Excel spreadsheet window into either two or four individual panes and is particularly useful for comparing data in different parts of a large worksheet.
To use the Split command, you must first activate the cell where you want the split to occur then click on the split button in the Window section of the View Tab of the Excel Ribbon. The horizontal and vertical bars which mark the split can be repositioned simply by dragging them. Separate scrollbars are displayed for each section; so, in the case of a vertical and horizontal split, you will have two horizontal scrollbars and two vertical scrollbars. To remove the split at any time, simply click on the split button once more.
A second and more intuitive method of using the split command is to use the split boxes. The split boxes are tiny icons located above the vertical scroll bar and to the right of the horizontal scroll bar. Let’s say that we have a spreadsheet containing rows of sales figures. Suppose we want to be able to compare the sales figures of one person with the sales figures of other individuals. We can create two vertical panes by dragging the vertical split box. We can then scroll to make the first person’s sales figures visible and in the top pane then do the same to position the sales figures of any other sales person in the bottom pane.
Excel offers us a delightfully simple way of removing the split: simply double-click on the split line.
Suppose we then want to focus on the total for each individual and that the totals are shown in column J. We can create vertical and horizontal splits by dragging each of the two split boxes. We can then display the salesperson’s name displayed in the left pane while in the pane on the right we can scroll across to reveal the total.
As we scroll up and down, we would then see the totals for each sales person next to the sales person’s name. If we would also like the heading to remain in place, we simply resize the top pane to make it one row deep, displaying only the headings, while we scroll the bottom pane up and down.
When we have finished reviewing our totals, we can remove the vertical split and leave the horizontal split in place. To do this, we just double-click on the vertical split line. To return to a completely normal Excel window, we would also double-click on the horizontal split line.
The The writer of this article is a trainer and developer with TrainingCompany.Com, a UK IT training company offering Microsoft Excel 2007training courses in London and throughout the UK.