This brings a tight focus onto Q4 and the YTD totals in columns G and H. Then, by selecting a row below row 4 and scrolling up, you no longer see rows 5 through 9. In the figure below-because D5 was chosen-columns to its left (A-C) and rows above it (1-4) are frozen by the split. by selecting the cell below and to the right of where you want the split-then click Split. You can also split on both a row and a column. Select the column to the right of the column where you want to place the split, and use the Split command. You can also split a worksheet on the columns. You can remove the split simply by clicking the Split button again. To split this worksheet as shown above, you select below the row where you want the split – selecting row 13 splits the worksheet below row 12.
MICROSOFT EXCEL SPLIT CELLS IN HALF HOW TO
Would you like to know how to see his result together with the top 10 finishers at the top of the worksheet?īy splitting the worksheet, you can scroll down in the lower pane and still see the top rows in the upper pane. You found his name down in row 180 of your spreadsheet. Your friend Tomas finished a 5-K run last weekend, and you want to see the times of the top 10 finishers to compare his time with theirs. To remove the split panes, simply click the "Split" button again.Īn animation about how to split excel worksheet window into four panes horizontally and vertically is copied below.Excel for Microsoft 365 Excel 2021 Excel 2019 Excel 2016 Excel 2013 More. You can change the size of a pane by clicking, dragging and releasing the mouse pointer after its shape changed into double headed arrow. If you keep the mouse pointer over any of the split bar, the pointer changes to a double headed arrow, as shown in below image. Note that the Cell pointer we had selected (Cell address C351) to split the Excel worksheet into four panes became the top-left corner Cell of the bottom-right pane. Step 3 - Excel splits its worksheet window horizontally and vertically into four panes as shown in below image and displays two Split Pane bars horizontally and vertically with their point of intersection at the top-left corner of the selected Cell. Step 2 - Click "Split" button from Excel Ribbon > "View" Tab > "Window" Group to split Excel worksheet horizontally, as shown in below image. In this example, Cell address C351 is selected as shown in below image. The selected Cell will become the top-left corner Cell of the bottom-right pane, after Excel split the worksheet window into four Split Panes. Step 1 - Select the Cell where you want to split the Excel worksheet window to four panes horizontally and vertically. To split an Excel worksheet horizontally and vertically into four Split Panes, follow below steps. When you split Excel worksheet window into horizontally and vertically, you split Excel worksheet window into four Split Panes. When you split Excel worksheet window horizontally or when you split Excel worksheet window vertically, you split Excel worksheet window into two Split Panes. You can split Excel worksheet window into two or four Panes. Each Pane has separate scrollbar, so that you can scroll them separately. Once the active worksheet is split into different panes, you can compare different areas of worksheet by scrolling horizontally or vertically. There is a feature in Excel, which allows you to split the active worksheet into Split Panes horizontally or vertically. If the worksheet is too large, it is not possible to view different areas of the worksheet at the same time by zooming out the worksheet. When you are working in a very large Excel worksheet, sometimes you may want to view different areas of the worksheet at the same time.