Freezing panes in Excel

scoochie · 01-18-2006, 01:47 PM

Is there a simple way to freeze more than just the top and left pane selections in Excel? In other words, is it possible to "frame" the entire view of the work sheet by have frozen cells along all four sides of the view? I realize that this may sound like a silly or impossible question as the grid may be dependant on this not to work this way. (But at the risk of looking foolish, I thought that I would put it out there anyway.)

Thanks,

Scoochie

dheerajnagpal · 01-19-2006, 04:04 AM

Try Window -> Split.

It is sort of having multiple splits. Maybe that will help you more than just Freeze. This is the closest i could think of to your problem. Maybe some VBA programmers might have a better idea.

01-18-2006, 01:47 PM	#1 (permalink)
scoochie Registered User Join Date: Jan 2006 Posts: 18 OS: xp	Freezing panes in Excel Is there a simple way to freeze more than just the top and left pane selections in Excel? In other words, is it possible to "frame" the entire view of the work sheet by have frozen cells along all four sides of the view? I realize that this may sound like a silly or impossible question as the grid may be dependant on this not to work this way. (But at the risk of looking foolish, I thought that I would put it out there anyway.) Thanks, Scoochie

01-19-2006, 04:04 AM	#2 (permalink)
dheerajnagpal Registered User Join Date: Mar 2005 Location: Sydney Posts: 48 OS: Win XP-Prof SP2 My System	Try Window -> Split. It is sort of having multiple splits. Maybe that will help you more than just Freeze. This is the closest i could think of to your problem. Maybe some VBA programmers might have a better idea.