![]() To freeze horizontal and vertical headings simultaneously: Keeping this in view, how do I freeze panes vertically and horizontally at the same time? A black line appears below the rows that are frozen in place.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 Know, 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. Select View > Freeze Panes > Freeze Panes.Ĭorrespondingly, how do I freeze rows and columns at the same time in Excel?.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. |