| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I make a range of cells in a column equal to another cell
|
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How do I make a range of cells in a column equal to another cell
Vague, and you should always elaborate on your query in the message area
(never leave it blank) Anyway, one thought .. Assume A1 will contain the common value for the range in B1:B5 Put in B1: =IF(A$1="","",A$1) Copy down to B5 -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "jggsfl" wrote in message ... How do I make a range of cells in a column equal to another cell |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| can I make cell "yes" equal 1, "no" equal 0 | Excel Discussion (Misc queries) | |||
| How do I make a range of cells equal to one cell | Excel Discussion (Misc queries) | |||
| How do I make a column equal a formula in Excel? | Excel Discussion (Misc queries) | |||
| How to make row height to exactly equal column width? | Excel Discussion (Misc queries) | |||
| How do I make a cell equal to another cells value and not it's fo. | Excel Worksheet Functions | |||
Linear Mode
