| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do you fill down value until it changes
I am using Excel 2003.
I have column A with customer names. Data in columns B, C ..... relate to the customer.The customer name is entered only once with blanks below it until the customer name changes. I want to fill the customer name into the blank cells below it. I have tried selecting column A, Then F5 special blanks. In first active cell, I enter = and select the customer name above it. Then CNTL + ENTER. This enters =celladdress of first active cell into ALL the blanks and obviously doesn't work. Can anyone advise? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Erase fill print then bring fill back | Excel Discussion (Misc queries) | |||
| Fill in form to type Item descrictions and costs and fill in funct | Excel Worksheet Functions | |||
| Edit Fill Series - How do I fill using minute increments | Excel Discussion (Misc queries) | |||
| I have a list of data, fill in the gaps. FILL function won't work | Excel Discussion (Misc queries) | |||
| The fill feature in Excel that gives option to fill or copy | New Users to Excel | |||
Threaded Mode
