When a worksheet contains split panes in Excel, you can also move the splits. Split Panes in Excel – Instructions and Video Lesson: A picture of a large Excel workbook that is horizontally split into two separate panes. To turn it off, click into the worksheet and then click the same “Split” button again. Then click the “Split” button in the “Window” button group to split the worksheet. After making either selection, then click the “View” tab in the Ribbon. Alternatively, to vertically split a worksheet into two panes, click the gray column heading (where the actual column letters appear) of the column to the right of where you want the split to appear. To horizontally split a worksheet into two panes, click the gray row header (where the actual row number appears) of the row below where you want the split to appear. You can click the “Split” button again to remove the split panes, when finished. This lets you scroll each pane to independent sections of the same worksheet. Then click the “Split” button in the “Window” button group to split the current worksheet into four separate panes. To split a worksheet into four separately scrollable quadrants, first click to select the cell below and to the right of where you want the split to appear. For example, you could split a large worksheet to see column headings in the top row and totals in the bottom row at the same time. Therefore, you can scroll each pane separately to view information from different sections of the worksheet. Each pane contains its own horizontal and vertical scroll bars. This command lets you split the Excel worksheet into different panes. Want to unfreeze a row, column, or both? On the View tab, click Unfreeze Panes.To split panes in Excel when viewing a large worksheet, use the “Split” command in Excel. Any time you freeze rows and columns, the border below the last frozen row and to the right of the last frozen column appears a little thicker (here, below row 4 and to the right of column C).
You'd select cell D5, and then on the View tab, click Freeze Panes. Say you want to freeze the top four rows and leftmost three columns. To freeze multiple columns, select the column to the right of the last column you want frozen and click Freeze Panes. To freeze multiple rows (starting with row 1), select the row below the last row you want frozen and click Freeze Panes. Want to freeze multiple rows and/or columns? You can freeze as many as you want, as long as you always start with the top row and the first column.
Then, on the View tab, click Freeze Panes.įreeze as many rows or columns as you want To freeze the top row and the first column at the same time, click cell B2.
When you do this, the line to the right of column A is a little darker than the other lines, meaning that the column to its left is frozen. If you'd rather freeze the leftmost column instead, on the View tab, click Freeze First Column. When you do this, the border under row 1 is a little darker than other borders, meaning that the row above it is frozen. If the Freeze buttons aren't available on the View tab, make sure you switch to Normal view. To do this, you use the Freeze buttons on the View tab.
You want to scroll, but you want to see your top row or left column to stay still. Excel for Microsoft 365 for Mac Excel 2021 for Mac Excel 2019 for Mac Excel 2016 for Mac Excel for Mac 2011 More.
0 kommentar(er)
