Freezing both Horizontal and Vertical Panes

P

Pheng

Hi all,

Can I ask a stupid question?

How do you freeze both the Horizontal and Vertical Panes in the sam
worksheet?


Cheers
 
P

Peo Sjoblom

It depends where you want the freeze? If you want first column and first row
select B2 and
do windows>freeze panes

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adjust Vertical Pane Splitter 0
Vertical short line in front of word 0
Show horizontal grid lines only in xl2003.. 1
Text in note pane of "normal" display suddenly much larger 1
How to freeze one column vertically, one horizontal in same sprdsh 4
Freeze panes 4
Sharing Worksheets 1
Secondary axis alignment 0

Top