ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Free panes (https://www.excelbanter.com/charts-charting-excel/156501-free-panes.html)

Daniel

Free panes
 
Hi
How to divide excel sheet to 2 parts. One part is free pane and other is
active?
I tried split left and right sheet by click window/free panes but left and
right are still
active?
Thanks
Daniel

David Biddulph[_2_]

Free panes
 
If you want to freeze columns A and B, select column C, then Window/ Freeze
Panes.
--
David Biddulph

"Daniel" wrote in message
...
Hi
How to divide excel sheet to 2 parts. One part is free pane and other is
active?
I tried split left and right sheet by click window/free panes but left and
right are still
active?
Thanks
Daniel




Daniel

Free panes
 
Thanks David
What if I want column A and B active and the right side is freeze?
Thanks
Daniel

"David Biddulph" wrote:

If you want to freeze columns A and B, select column C, then Window/ Freeze
Panes.
--
David Biddulph

"Daniel" wrote in message
...
Hi
How to divide excel sheet to 2 parts. One part is free pane and other is
active?
I tried split left and right sheet by click window/free panes but left and
right are still
active?
Thanks
Daniel





Jon Peltier

Free panes
 
Daniel -

Sorry, Excel doesn't freeze panes that way.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Daniel" wrote in message
...
Thanks David
What if I want column A and B active and the right side is freeze?
Thanks
Daniel

"David Biddulph" wrote:

If you want to freeze columns A and B, select column C, then Window/
Freeze
Panes.
--
David Biddulph

"Daniel" wrote in message
...
Hi
How to divide excel sheet to 2 parts. One part is free pane and other
is
active?
I tried split left and right sheet by click window/free panes but left
and
right are still
active?
Thanks
Daniel








All times are GMT +1. The time now is 01:17 PM.

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