So, without any further ado, let’s go through how to split a cell horizontally in Excel. Scenario at hand: For this article, we are going to split the first and last names into two different columns.

5] How to split windows vertically and horizontally in Excel To split windows in Excel . Click a row or column heading, select Split on the View tab in the Window Group .

Yes, in Excel it’s called Freezing Panes, which can be applied to columns or rows (or both), and it’s super-simple. We’ll also show you how to split screens, a similar feature.