I like this method which I copied from a post here, but have also seen in a
John Walkenbach book:

Select column A. Hit F5. Click on Special. Click on Blanks, then OK.
Type = and then hit Up Arrow. Hold Control Key and hit Enter.

--
Kevin Vaughn


"excelmad" wrote:

I have a very large file in which I need to copy the SSN down to the point
where the next SSN begins. How can I accomplish this task?

I have information in a worksheet as follows:

SocialSec # Acct Bal Type Amount
Row1 SSN Account BalA 50.00
Row2 Account BalC 100.00
Row3 Account BalD 250.00
Row4 SSN #2 Account BalA 50.00
Row5 Account BalC 14.00
Row6 Account BalD 75.50
Row7 Account BalE 35.00
Row8 SSN #3 Account BalA 22.00
Row9 Account BalB 25.00