How to do freeze drop down in excel files

[Aniket Ayare]

how to freeze the drop down in excel file.

when i'll select one column then 2nd column value should automatically come.

if anyone have solution plzz advise

[#2]

Hi @Aniket Ayare

1.Did you mean about Freeze Panes? (i.e. Freezing Rows / Columns while scrolling)

2. On which basis you want to bring the value second column.

Make it clear.

[#3]

no not the Freeze panes. 

I have to make an order form where one value is linked with another. so I need to find an solution where order form is fill with all the values but if I am deleting any 1 cell value then all the cell should get refreshed automatically showing the null. refer to attached order form.