Autofilling Zip Code

[JustForJeeps]

Instead of Ctrl-D each column is there a way to autofill the entire column for each zip code. Please see the image below.
http://site.justforjeeps.com/zip.bmp

[olasa]

It can be done by using the C column.
C2: =IF(ISBLANK(A2),A1,A2)
copy down the formula and then Copy and Paste special>Values over the B column values.

Ola Sandström

[JustForJeeps]

Where exactly do I paste that forumla into? I need a little more direction on what to do since I have never used formulas in Excel before. I also provided a link to a more detailed picture. Thanks!

http://site.justforjeeps.com/excel.jpg

[swatsp0p]

I understand you are struggling with the instructions in my first post. I'll try to guide you through this, step by step. Can you print these instructions to keep handy as you go through this?

Per your example, I first wonder if the zip code cells in column F are merged? If not, skip to the next paragraph. If so, you must first "unmerge" them. With the range in column F selected, click Format on the menu at the top of the screen then click Cells, the Format Cells dialog box opens. On the Alignment tab, make sure there is no check mark in the Merge box. Click OK, to apply any changes and close the dialog box

Then you will need to insert a new column G (it will be deleted when done) Place your cursor over the Letter G at the top of the column, right click and select Insert. A new, blank column G will appear.

Enter this formula in cell G6 =IF(ISBLANK(F6),F5,F6)

and copy this formula down your entire range of data. With the cursor in G6, point your mouse over the small box in the lower right corner of the cell. It will change to a cross. Click and drag this down to the end of your range of data.

Next, highlight this range in column G (it will now have all of your zip codes listed in column F and should still be highlighted from copying the formulas down) and click Edit on the main menu and select Copy.

Then, select cell F6 and Edit>Paste Special... in the box that opens, click on Values and click OK. Now your list of Zip Codes are in column F without the formulas (just the values were pasted).

Finally, delete the column G with the formulas. Same steps as when you inserted the column, except select Delete from the menu.

Did that explain it better for you?

Bruce

[swatsp0p]

Upon reviewing Ola's formula, I find a slight error that causes it not to work as planned:

=IF(ISBLANK(A2),A1,A2) should be:

=IF(ISBLANK(A2),B1,A2)

NOW, all is well.

Bruce