ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I inmovilize 2 panels in Excel? (https://www.excelbanter.com/excel-discussion-misc-queries/174241-how-do-i-inmovilize-2-panels-excel.html)

Slaydo

How do I inmovilize 2 panels in Excel?
 
I know that I can inmovilize a line and a column in Excel, but I don“t know
how.

Niek Otten

How do I inmovilize 2 panels in Excel?
 
To have Column A and Row 1 immobilized, select cell B2, Windows, Freeze Panes

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"Slaydo" wrote in message ...
|I know that I can inmovilize a line and a column in Excel, but I don“t know
| how.



Dave Peterson

How do I inmovilize 2 panels in Excel?
 
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.

Slaydo wrote:

I know that I can inmovilize a line and a column in Excel, but I don“t know
how.


--

Dave Peterson


All times are GMT +1. The time now is 04:13 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com