ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I freeze more than one location on my worksheet? (https://www.excelbanter.com/excel-worksheet-functions/68083-how-do-i-freeze-more-than-one-location-my-worksheet.html)

Melody

How do I freeze more than one location on my worksheet?
 

--
Snicker''''s Mom

Anne Troy

How do I freeze more than one location on my worksheet?
 
You don't, Ma. Try using Split instead.
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

"Melody" wrote in message
...

--
Snicker''''s Mom




Melody

How do I freeze more than one location on my worksheet?
 
Okay, what is split? I am the definition of a rookie!
--
Snicker''''s Mom


"Anne Troy" wrote:

You don't, Ma. Try using Split instead.
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

"Melody" wrote in message
...

--
Snicker''''s Mom





Anne Troy

How do I freeze more than one location on my worksheet?
 
Same menu as Freeze.
Window--Split. You really have to try it to see it. Place your cursor in
the middle of your window before you Split, and it'll split it 4 ways. You
can navigate any of those 4 panes independently. If that's not cool for you,
let us know exactly what the issue is and perhaps we can help. :)
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

"Melody" wrote in message
...
Okay, what is split? I am the definition of a rookie!
--
Snicker''''s Mom


"Anne Troy" wrote:

You don't, Ma. Try using Split instead.
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

"Melody" wrote in message
...

--
Snicker''''s Mom








All times are GMT +1. The time now is 06:10 AM.

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