Thread: how do I validate an entire colume instead of a cell
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default how do I validate an entire colume instead of a cell
Select A1:A100

Type a price in A1 then hit CTRL + ENTER


Gord Dibben MS Excel MVP

On Thu, 19 Mar 2009 12:26:01 -0700, de_diver
wrote:

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!

Reply With QuoteReply With Quote