-1

I just want to know how to autofill all cell if I select value from 1 cell using drop down box. Suppose in 1st cell of the row I will select "Yes", then all the 5 adjacent cell of that row will also show "Yes". ther is data validation activated in all cell, but i dont need to select it each time.

HaveNoDisplayName
  • 8,291
  • 106
  • 37
  • 47
Ummey Salma Koli
  • 1
  • 1
  • SO is best for very concrete answers to specific programming related issues. You should at least try something yourself and provide a minimal code example of the things you are trying to achieve. Check the [guidelines](http://stackoverflow.com/help/how-to-ask) – Kris Feb 19 '16 at 09:40

1 Answers1

0

If the dropdown is in A1 then just make B1 be:

=A1

so it shows whatever is in cell A1

Ben Rhys-Lewis
  • 3,118
  • 8
  • 34
  • 45
  • Yes, i know that. but the thing is, the others cells also have data validation with drop down list. there should be option so that if any one want it "No" then he can change that. but primarily it will auto populate. – Ummey Salma Koli Feb 22 '16 at 01:47