How to freeze only 4 columns

[Heera]

Hi Team,

I would like to know how to freeze only four column in excel 2013. For example from Column A to Column D. Cell range from A1:D40. And I want to add data from column F from F1 to my requirement. For example F1 to P 80. When I scroll the data from F1, the range from A1:D40 should not more..this table should freeze. It should freeze at the top to see the result.

Please help me.

Regards,
Heera

 

[krausr79]

I don't know if a complicated freeze is possible, but perhaps extra views would do what you want? (I'm in excel 2010). Under view, choose 'New window' Then arrange the windows so that one is always looking at the stuff you want frozen. You will be able to move the other window howver you want without the first moving.

 

[Gandor]

Select the cell immediately below and to the right of the data you wish to freeze, then click the Freeze Panes drop down on the View tab and choose Freeze Panes.

 

[Heera]

HI Krausr : Ur suggestion don't fill my requirement. Please suggest any.

Hi Gandor : If I do that that I am not able to see first 15 rows. That is why I have mention that I would like to freeze the column range from A1:D40. And I would like to put data from column F1 to P80 or...P100. Please suggest if any possible way.

Can anyone help me on this please ?

Regards,
Heera

 

[Heera]

Anyone who can help me ?

Regards,