filling in empty cells -

S

stumped-in-excel

When I download a database into excel - it sets up the data fields as follows:

company name person
Acme Smith
Jones
Brown
Bender Howard
Mason
Fortune
Black Rain


Is there a way to auto fill the blanks with the company name above?

so it looks like

company name person
Acme Smith
Acme Jones
Acme Brown
Bender Howard
Bender Mason
Bender Fortune
Black Rain


any help would be appreciated!
 
J

Jacob Skaria

Just give this try..

Enter the formula in say D2
=D1

Select column A.
Press F5. Click Special
From GoTo window select Blanks.
Right click>Paste Special>Formulas..
 
J

Jacob Skaria

It should be...

Enter the formula in say D2
=D1
Copy cell D2
Select column A.
Press F5. Click Special
From GoTo window select Blanks.
Right click>Paste Special>Formulas..
 
S

stumped-in-excel

Jacob -
Yes that did work... Thanks... I have no Idea why it worked but hey, it's
all about results -
 
J

Jacob Skaria

The formula entered is to get the value from top cell. So once we select the
blank cells and paste formulas; excel adjust the formula reference to pick
the value from the top cell of each selected cell.

Note that now you are having formulas in ColA (not values). To change that
Select column A. Copy. Rightclick PasteSpecial >Values..to have all the cells
with values...

If this post helps click Yes
 
S

Shane Devenshire

Hi,

Here is another approach that does the same thing:

1. Select the entire range of cell, blanks and not and press F5, Special,
Blanks, OK
2. Type = , Up Arrow, Ctrl+Enter (the three keystrokes = UpArrow Ctrl Enter)

In general you will next want to convert these formulas to values:
1. Select all the cells and press Ctrl C
2. Choose Edit, Paste Special, Values
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top