To split panes, simply follow the steps below: One will be able to browse through important numbers while keeping other significant digits viewable. In this case, working with Excel will be more systematic and organized which equates to time and energy saved. Split Panes lets you split your spreadsheet into 2 or 4 areas, keeping two areas in place while the other two moveable. Or you have several rows at the top that you want to see and freezing all of them doesn’t work. This is more helpful than freezing rows if you have lots of columns on the left. It’s by using the ‘Split Option’ to freeze and separate your rows into different worksheets.
Now, there’s another way on how to do this. Locate your Tool Bar and choose Layout Menu.ĭrag down the menu and click Unfreeze panes. To unlock the panes that were once grouped together, follow these steps: This will make the leftmost column visible at all times while you scroll to the right. To freeze the first column in a sheet, click View tab > Freeze Panes > Freeze First Column. To do such, follow these simple steps:Īrranging your Excel spreadsheet to its default setting is easy. Freezing columns in Excel is done similarly by using the Freeze Panes commands. Users also have the option to lock in view the first column or the first row of the spreadsheet. Notice that A1 to A6 are now locked and a grey line separates these rows from the rest of the rows in your Spreadsheet.
A grey line separates locked rows from the unlocked ones.įor instance, one would like to lock A1 to A6 of their Spreadsheet. Now, all the rows above are locked and stay in place even when scrolling. Notice that columns A to C are now locked and a grey line separates these columns from the rest of the columns in your Spreadsheet.Ĭhoose the cell below the row that you want to freeze. A grey line separates locked columns from the unlocked ones.įor instance, one would like to lock A to C of their Spreadsheet. Now, all the specific columns are locked and stay in place as you navigate your Spreadsheet. This lets you highlight the columns that you want to freeze.Ĭlick on the Freeze Panes icon and select Freeze Panes from the menu. The first row is locked in place during Spreadsheet navigation. The first column is locked in place during Spreadsheet navigation. The same principle applies to “Columns to repeat at left”.Freeze Panes gives users the option to freeze specific columns or specific rows only. To take that example to the extreme, if you selected row 500 at “Rows to repeat at top” it would not begin repeating until the page after the page that row 500 naturally prints on. If you select rows 4 and 5 as “Rows to repeat at top” page 1 will still print as it appears on screen but beginning with page 2, only rows 4 and 5 (not 1-3) will appear at the top of each printed page. Let’s say you have a report heading in rows 1 through 3 and column headings in rows 4 and 5. The rows you selected don’t have to be at the top of your worksheet – i.e. Also, you only select entire rows (or columns) to repeat. The rows (or columns) to repeat have to be adjacent, for example you can’t select rows 1 and 3, but not 2.