Filling Blank Rows w/ Values

**NBVC** · 10-13-2009, 08:35 AM

Select column A and then hold the CTRL key and select A1.

Then go to Edit|Go To and click Special....select Blanks and click Ok.

enter an = sign and hit the up arrow key.

Hold the CTRL key again and hit ENTER.

You may have to fix whatever was in A1.

**XtremeSki2001** · 10-13-2009, 09:19 AM

Originally Posted by NBVC

Select column A and then hold the CTRL key and select A1.

Then go to Edit|Go To and click Special....select Blanks and click Ok.

enter an = sign and hit the up arrow key.

Hold the CTRL key again and hit ENTER.

You may have to fix whatever was in A1.

Awesome! You da man. Thank you.