View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ron Coderre Ron Coderre is offline
external usenet poster
 
Posts: 2,118
Default keep first left colum visible

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)


"panambi" wrote in message
...
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!