Question

In MSexcel , which command is used to fix row /column
​

Answer 1

Answer:

Freeze panes command

Explanation:

-->Select the cell below the rows and to the right of the columns you want to keep visible when you scroll.

-->Select View > Freeze Panes > Freeze Panes.

Answer 2

• The ROW function returns the row number for a cell or range.
• For example, =ROW(C3) returns 3, since C3 is the third row in the spreadsheet.
• When no reference is provided, ROW returns the row number of the cell which contains the formula.
• ROW takes just one argument, called reference, which can be empty, a cell reference, or a range.
• When no reference is provided, ROW returns the row number of the cell which contains the formula.