I know that I can inmovilize a line and a column in Excel, but I don´t know how.
S Slaydo Jan 24, 2008 #1 I know that I can inmovilize a line and a column in Excel, but I don´t know how.
N Niek Otten Jan 24, 2008 #2 To have Column A and Row 1 immobilized, select cell B2, Windows, Freeze Panes -- Kind regards, Niek Otten Microsoft MVP - Excel |I know that I can inmovilize a line and a column in Excel, but I don´t know | how.
To have Column A and Row 1 immobilized, select cell B2, Windows, Freeze Panes -- Kind regards, Niek Otten Microsoft MVP - Excel |I know that I can inmovilize a line and a column in Excel, but I don´t know | how.
D Dave Peterson Jan 24, 2008 #3 In xl2003 and below: Select A1 (just so you can see it) select B2 Window|Freeze Panes (in xl2003) Everything above the activecell and to the left of that activecell will be frozen. If you have data|filter|autofilter applied, show all the data before you freeze panes.
In xl2003 and below: Select A1 (just so you can see it) select B2 Window|Freeze Panes (in xl2003) Everything above the activecell and to the left of that activecell will be frozen. If you have data|filter|autofilter applied, show all the data before you freeze panes.
