how do I validate an entire colume instead of a cell

D

de_diver

I have multiple columns of prices and I want to use one cell, the header
cell, to populate all the cells in my price sheet column once I choose the
header price I want. I have tried cell validation but that only does one
cell at a time and I want to do the whole column from one cell. Please help!
 
G

Gord Dibben

Select A1:A100

Type a price in A1 then hit CTRL + ENTER


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Looking up Text as a result of a formula 1
Testing a cell value for a specific weekday. 3
Create One Formula for Entire Column 1
Create Generic Formula for Entire Column 1
adding a percentage to a column of numbers 3
HOW DO I GET A CELL TO RETURN A NEIGHBORING CELL'S VALUE 6
How do I tell Excel to insert data from a cell 4 to the left? 1

Top