Forum Discussion

Aniket Ayare's avatar
Aniket Ayare
Copper Contributor
May 28, 2018

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

2 Replies

  • Logaraj Sekar's avatar
    Logaraj Sekar
    Steel Contributor

    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.

    • Aniket Ayare's avatar
      Aniket Ayare
      Copper Contributor

      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.