keep first left colum visible

P

panambi

Hi,
how do I keep the first left colum visible when I work with up to 100
columns to the right?

the left colum has information I need to see when working at the right.

I know this is possible, but I don't know how to set it...

thanks for help!
 
R

Ron Coderre

Try this:

Set the headings where your want them on the screen
Select the first cell below the headings

Example:
If you always want to see rows 1:3 and column A
Select cell B4

From the Excel Main Menu:
<window><freeze panes>

Does that help?
Post back if you have more questions.
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)
 
C

Chip Pearson

Select cell B1 and choose Freeze Pane from the Window menu.


--
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)
 
P

panambi

Thank you so much!

one more question: how do I do the set up, if I want to have the first
column printed on each page?
 
Top