How to populate a bunch of cells at once

  • Thread starter Thread starter Danny
  • Start date Start date
D

Danny

My spreadsheet is huge and I would like the user to be able to populate an
entire chunck of cells in the colum based on some criteria.

So, if the user enters a value in one cell, a prompt could come up and ask
"would you like to populate all the cells with this value that have the
color red as the key" etc etc.

Please give me a hint as to how to go about it. Once I get the idea, I will
be set.

Thanks so much
 
Hi
maybe not what you're looking for, but:
- select all desired cells
- enter your value
- finish the entry with CTRL+ENTER (not with a single ENTER)
 
Back
Top