How do I inmovilize 2 panels in Excel?

  • Thread starter Thread starter Slaydo
  • Start date Start date
S

Slaydo

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.
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top