Forum Discussion
How to do freeze drop down in excel files
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
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.
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.