How to freeze a row or column in Excel
How do I freeze a row or column in Excel.
Answer
This can be done by selecting the Menu VIEW and pressing the split button.
If you selected a single cell, it will create a split of the sheet in the top
left corner of the cell and freeze the left and upper part of the sheet.
If you selected a column, the split will be done on the left side of the
column and the sheet will be frozen on the left side of the column.
If you selected a row, the spit will be done on the upper part of the row and
the sheet will be frozen on the upper part of the row.
You can find similar Excel Questions and Answer hereunder
1) In a Table , how can I add a Total Row that displays the maximum value in a column of numbers?
2) I have to retrieve data from a specific column in a Table. In Excel, how can I do that?
3) How do you know which column was used last, Here the explanation to find it with VBA
4) How do i apply a formula to an entire column in Excel
5) How can I find the last used cell in a Column in VBA?
6) How do you know which row was used the last. Here the explanation to find it with VBA
7) Vba delete entire row if contains certain text in Excel
8) How can I convert Column numbers into Column names for use in range definition?
9) Split one long column into multiple smaller columns in Excel
10) How can I get the last non-zero value in a row?