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

Word VBA - Automatic change content of a cell in table using dropdown list 5
Copy addition formula of non-consecutive horizontal cells 2
Merging from an Excel file with graphics 1
How do I link a cell in a workbook? 1
How to remove a bracket that is itallicised for an entire document 1
Testing a cell value for a specific weekday. 4
Pasting a range to a single cell 0
Word macro that can call cells out of Excel for a find and replace 0

Top