LinkBack URL
About LinkBacks
Dear excel users
Yellow highlighted area should be freez while I am scrooling up and down
other part of sheet
Example
Column A till D and ROw 1 till 25 Should freez
from column E to onward work as usual
Is this Possible
Freez Specific area in Excel Sheet
Dear excel users
Yellow highlighted area should be freez while I am scrooling up and down
other part of sheet
Example
Column A till D and ROw 1 till 25 Should freez
from column E to onward work as usual
Is this Possible
if you click on E25 and Freeze panes
does that work for you
you will need to zoom out until all the area is visible on the screen
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
thanks but its not the solution for my concern....
rather than just say its not correct - why not also say why its not correct and what you require
Otherwise we will just continue to guess !
it does this
Column A till D and ROw 1 till 25 Should freez
You can display that area in a second window. I think that's as close as you'll get.
Entia non sunt multiplicanda sine necessitate
if i will do what yoy said then i ll not perform my task.
let me explain in other way
no movement of Column A,B,C,D neither scrool up down nor left right
but other sheet would woek as usual
Etaf's solution does exactly what you want: A1:D24 is "frozen".
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks