Freezing both Horizontal and Vertical Panes

  • Thread starter Thread starter Pheng
  • Start date Start date
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
 
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)
 
You must log in or register to reply here.

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

Freeze panes 3
Sharing Worksheets 1
Freezing both horizontally and vertically 3
Freeze panes 4
Show horizontal grid lines only in xl2003.. 1
Doing a VLOOKUP (probably using the INDEX and MATCH function), withboth vertical and horizontal valu 2
hiding freeze pane reference lines 3
How to freeze one column vertically, one horizontal in same sprdsh 4

Back
Top