This is no programming question, at least I wouldn't put it that way unless I needed VBA for that. Visual Aid on Freeze Panes in Excel 2010 - Microsoft Reference Guide (More Complicated, but resourceful none the less). You could also freeze columns A and B and row 1, by selecting cell C2 and clicking 'Freeze Panes'. For future reference, selecting Freeze Panes in Excel will freeze the rows above your selected cell and the columns to the left of your selected cell.įor example, to freeze rows 1 and 2 and column A, you could select cell B3 and click Freeze Panes. Select cell B2 and click 'Freeze Panes' this will freeze Row 1 and Column A. For example, to freeze top two rows in Excel, we select cell A3 or the entire row 3, and click Freeze Panes: As the result. On the View tab, click Freeze Panes > Freeze Panes. Select the row (or the first cell in the row) right below the last row you want to freeze. 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. Freeze panes to lock the first row or column - Freeze the first column If you'd rather freeze the leftmost column instead, on the View tab, click Freeze First Column.
0 kommentar(er)
