Copy cells to fill in blank fields

[RevJeff]

Hi,

I have a spreadsheet with company names in the Column A and items they ordered in Column B. The company name is only listed next to the first item they ordered, so if they have ordered multiple items, there are blank cells under the company name. Then the next company name is listed with the items they ordered. This continues for thousands of rows, leaving a lot of blank cells in Column A. My boss wants to fill in all of the blank cells with the company names. So my question is: Is there a feature/function that tells Excel to copy a cell into all of the blank cells below it until it reaches a non-blank cell?

Thanks!

[benishiryo]

hi RevJeff. assuming your data is from A1:B100
1. select A1.
2. click & drag the scroll bar to the end where the data of column A ends (row 100)
3. press & hold the SHIFT key & left click on the last cell in column A (A100). you should see them all selected
4. press CTRL + G -> Special -> Blanks -> OK. now only blanks are selected
5. do not click anywhere else. press the "=" sign
6. press the UP arrow key
7. hit CTRL & ENTER

[RHCPgergo]

Hi,

there is a very simple and elegant way that I recently learned. Here are the steps:
1. highlight the whole column A
2. press ctrl+G or F5 to bring up "Go to" box
3. click "Special" button
4. Select "Blanks" and click "OK".
5. type "=" (just an equals sign)
6. press UP arrow
7. press Ctrl+Enter

Voilá! All the highlighted cells (empty cells in this case) are filled with the data above them. After this you should copy and paste column A back again with paste special (values) to make the functions disappear.

[dilipandey]

Hi Rev,

Here is a quick way.
Select the column A
Press F5
click on Special
Select Blanks
Ok
press keys "=" and "up Arrow"
Press Ctrl + Enter

Regards,
DILIPandey

<click on below 'star' if this helps>

[RevJeff]

WOW!!!! Thank you so much!!! I was scared I would have to copy/paste the whole thing.

[dilipandey]

Great..!!

If that solves your query, suggest you to mark this thread as [SOLVED]... thanks.


Regards,
DILIPandey

<click on below 'star' if this helps>