ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Freezing 2 columns at once (https://www.excelbanter.com/excel-discussion-misc-queries/136669-freezing-2-columns-once.html)

Davidi

Freezing 2 columns at once
 
Is it possible to freeze 2 separate columns at once? ie. I'd like to freeze
column A and column Z. If so, how can this be done? When I select the two
columns and then go up to Window, Freeze panes, Excel only freezes one
column.

Thanks.

John

Freezing 2 columns at once
 
you can't freeze seperate columns but you can set up a split screen which
might help. Windowsplit & drag to the position you want
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)


"Davidi" wrote:

Is it possible to freeze 2 separate columns at once? ie. I'd like to freeze
column A and column Z. If so, how can this be done? When I select the two
columns and then go up to Window, Freeze panes, Excel only freezes one
column.

Thanks.



All times are GMT +1. The time now is 10:20 PM.

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