| 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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do you fill down value until it changes
Works for me.
1. Highlight all of the cells, including the blanks you want to fill. 2. Press F5, click special and go to blanks 3. Type "=" then UP ARROW (equal sign, then Up Arrow) and press Ctrl- Enter. The blank cells are filled in with the cell from above. HTH JP On Apr 9, 8:03*pm, Dorian wrote: 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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do you fill down value until it changes
Thanks. It still wasn't working for me and after playing around a bit, I
found out that if the cells are formatted as text, it won't work - it filled in "=A5" into ALL the blanks. After changing the format to General, it worked. Just FYI. "JP" wrote: Works for me. 1. Highlight all of the cells, including the blanks you want to fill. 2. Press F5, click special and go to blanks 3. Type "=" then UP ARROW (equal sign, then Up Arrow) and press Ctrl- Enter. The blank cells are filled in with the cell from above. HTH JP On Apr 9, 8:03 pm, Dorian wrote: 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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do you fill down value until it changes
Ah, I think I understand. A more careful reading of your original
message might have yielded the proper results. Glad to hear it worked out for you! --JP On Apr 14, 5:08*pm, Dorian wrote: Thanks. *It still wasn't working for me and after playing around a bit, I found out that if the cells are formatted as text, it won't work - it filled in "=A5" into ALL the blanks. *After changing the format to General, it worked. *Just FYI. * |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do you fill down value until it changes
Yes, fill would not change text. You wouldn't want that. Think about it.
Tyro "Dorian" wrote in message ... Thanks. It still wasn't working for me and after playing around a bit, I found out that if the cells are formatted as text, it won't work - it filled in "=A5" into ALL the blanks. After changing the format to General, it worked. Just FYI. "JP" wrote: Works for me. 1. Highlight all of the cells, including the blanks you want to fill. 2. Press F5, click special and go to blanks 3. Type "=" then UP ARROW (equal sign, then Up Arrow) and press Ctrl- Enter. The blank cells are filled in with the cell from above. HTH JP On Apr 9, 8:03 pm, Dorian wrote: 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? |
| Reply |
| 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 | |||
Linear Mode
