Suppose it lists a long list of id and names. You can not select freeze top row and freeze first column simultaneously. You have to select a cell in the excel sheet which exactly lies below the rows and next to the columns you want to freeze. If you select freeze column 1, you can’t also choose to freeze row a… however, you can select cell b2 and click “freeze panes” this will freeze row 1 and column a simultaneously. Freeze top row only (regardless of cursor location): Go to the view tab, and click freeze panes. To avoid this problem, freeze the rows and columns. To freeze the first column in a sheet, click view tab > freeze panes > freeze first column. The next step is to go back to freeze panes and choose freeze panes this time instead of freeze top row. Usually, in excel first row contains our headers, and the first column contains the column headers. Whenever your excel spreadsheet consists of a lot of elements, it’s always useful to freeze rows and columns so that they stay visible as you scroll down the seemingly endless stream of data. Click freeze panes under the freeze panes in the view tab: These options are visible on the view tab, in the freeze panes menu. #3 freeze or lock both column and row at the same time in excel.

As an example, take a look at the spreadsheet below. Yes, you can freeze the 7 th row and the first column at the same time. How to freeze rows and columns simultaneously? Scroll down your worksheet to make sure the first row stays at the top. Please note that there are two separation lines. Top row will also become the header row if you have headers in the topmost row of the spreadsheet. Freezing locks specific columns or rows in place so that no matter where you scroll they're always visible on the top or side of the sheet. If you want to freeze only the top row of a list in a worksheet, choose freeze top row from the menu.įirst, highlight cell b2, and then go to the view tab and select freeze panes > freeze panes. On the freeze panes button, click the small triangle in the lower right corner. Select the cell immediately below and to the right of the rows and columns that you want to freeze. Excel provides the option of freezing rows and columns simultaneously. In this case, you’ll need to freeze a group of rows or columns.Ĭomputer Applications MicroSoft Excel Spreadsheet Go to the view tab, click freeze panes > freeze panes.Įxcel spreadsheet freeze row and column simultaneously. In this example, we want to freeze rows 1 to 6, so we've selected row 7.

How to freeze cells in excel 2016 video