ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do i freeze multiplue areas? (https://www.excelbanter.com/excel-worksheet-functions/8241-how-do-i-freeze-multiplue-areas.html)

Quiana

How do i freeze multiplue areas?
 
I'm trying to freeze panes verically and horizantly, can any one help with
this?

Frank Kabel

Hi
for example move your cursor to cell C4 and goto 'Windows - Freeze panes'.
This freezes rows 1-3 and column A:B.

You can only freeze the top and left though

--
Regards
Frank Kabel
Frankfurt, Germany

Quiana wrote:
I'm trying to freeze panes verically and horizantly, can any one help
with this?




Quiana

Hi,

Ok i was able to freeze column A & B. Is it possible to freeze the top as
well, row 1-4?

Thanks!

"Frank Kabel" wrote:

Hi
for example move your cursor to cell C4 and goto 'Windows - Freeze panes'.
This freezes rows 1-3 and column A:B.

You can only freeze the top and left though

--
Regards
Frank Kabel
Frankfurt, Germany

Quiana wrote:
I'm trying to freeze panes verically and horizantly, can any one help
with this?





Frank Kabel

Hi
as said: Move the cursor to C5. This feature freezes all rows to the top and
all columns to the left of the active cell

--
Regards
Frank Kabel
Frankfurt, Germany

Quiana wrote:
Hi,

Ok i was able to freeze column A & B. Is it possible to freeze the
top as well, row 1-4?

Thanks!

"Frank Kabel" wrote:

Hi
for example move your cursor to cell C4 and goto 'Windows - Freeze
panes'. This freezes rows 1-3 and column A:B.

You can only freeze the top and left though

--
Regards
Frank Kabel
Frankfurt, Germany

Quiana wrote:
I'm trying to freeze panes verically and horizantly, can any one
help with this?




Quiana

That worked, thanks so much for your help!

"Frank Kabel" wrote:

Hi
as said: Move the cursor to C5. This feature freezes all rows to the top and
all columns to the left of the active cell

--
Regards
Frank Kabel
Frankfurt, Germany

Quiana wrote:
Hi,

Ok i was able to freeze column A & B. Is it possible to freeze the
top as well, row 1-4?

Thanks!

"Frank Kabel" wrote:

Hi
for example move your cursor to cell C4 and goto 'Windows - Freeze
panes'. This freezes rows 1-3 and column A:B.

You can only freeze the top and left though

--
Regards
Frank Kabel
Frankfurt, Germany

Quiana wrote:
I'm trying to freeze panes verically and horizantly, can any one
help with this?






All times are GMT +1. The time now is 05:32 AM.

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