| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I validate an entire colume instead of a cell
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! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to multiply entire colume? | New Users to Excel | |||
| Colume Headings | Excel Worksheet Functions | |||
| Can I validate a cell only if a certain condition is met? | Excel Discussion (Misc queries) | |||
| 3 COLUME CHART | Excel Worksheet Functions | |||
| How can I look up max of one colume and display the colume to the. | Excel Worksheet Functions | |||
Linear Mode
