![]() Select the Freeze Panes command, then choose Freeze Panes from the drop-down menu.In our example, we want to freeze rows 1 and 2, so we'll select row 3. Select the row below the row(s) you want to freeze.How do you freeze multiple rows in Excel? Excel inserts two lines to indicate where the frozen panes begin.Select View tab, Windows Group, click Freeze Panes from the menu bar.Select the cell in the upper-left corner of the range you want to remain scrollable.To freeze horizontal and vertical headings simultaneously: A black line appears below the rows that are frozen in place.Īccordingly, how do I freeze panes vertically and horizontally at the same time?.For example, if you want rows 1 and 2 to always appear at the top of the worksheet even as you scroll, then select row 3. Select the row below the rows you want frozen.You will want your cursor to be below the row(s) you want to freeze and to the right of any column(s) you want to freeze.Īlso, how do I freeze multiple rows in Excel 2010? To freeze rows: To lock more than one row or column, or to lock both rows and columns at the same time, choose the View tab, and then click Freeze Panes. Keeping this in consideration, how do I freeze rows and columns at the same time in Excel? Select View > Freeze Panes > Freeze Panes. ![]() Select the cell below the rows and to the right of the columns you want to keep visible when you scroll.
0 Comments
Leave a Reply. |