How to hold a row or a column

ctbiu · May 9th, 2002, 09:54 PM

Hi

I have got an excel file that the column A and row 1 can be hold when I scroll the the scroll bar. How can I enable this function in excel?

Bill.

Tom Schreiner · May 9th, 2002, 09:59 PM

I think you might be talking about "Freeze Panes"?
Select row 2, the entire row, then choose the Window menu item or Alt-W, then choose "Freeze Panes"
Tom

Qroozn · May 9th, 2002, 09:59 PM

if you want to always see column A too then
click on b2 then goto window/freezepanes

_________________
All The Best
Qroozn
If I can do It anyone can

[ This Message was edited by: Qroozn on 2002-05-09 21:01 ]

ctbiu · May 10th, 2002, 09:23 AM

Problem is solved. Thanks

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 9th, 2002, 09:54 PM	#1
ctbiu New Member Join Date: May 2002 Posts: 3	Hi I have got an excel file that the column A and row 1 can be hold when I scroll the the scroll bar. How can I enable this function in excel? Bill.

May 9th, 2002, 09:59 PM	#2
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	I think you might be talking about "Freeze Panes"? Select row 2, the entire row, then choose the Window menu item or Alt-W, then choose "Freeze Panes" Tom

May 9th, 2002, 09:59 PM	#3
Qroozn Board Regular Join Date: Mar 2002 Location: Sydney/Brisbane , Australia Posts: 539	if you want to always see column A too then click on b2 then goto window/freezepanes _________________ All The Best Qroozn If I can do It anyone can [ This Message was edited by: Qroozn on 2002-05-09 21:01 ]

May 10th, 2002, 09:23 AM	#4
ctbiu New Member Join Date: May 2002 Posts: 3	Problem is solved. Thanks