Filling in blank cells with previous cell data

[dpbarry]

Hi all

I have the following excel sheet which shows student information. Is there a quick way of filling in the blank cells with the data from the previous row. i.e, in column A-C from row 3 - 17, fill these rows in with the data from Row 2 (A - C) and then the data in row 18 filling in the next set of blanks and so on.

This SS has 920 pupils each with approx 19 subject matched to them. I'm looking to use the data in an Access database but need each row with the corresponding data attached to it.

Hope everyone understands what I am looking for.

Declan

Book1.xls
	A	B	C	D	E
1	Legal Surname	Legal Forename	Reg	Teacher	Subject
2	Austin	Gemma	10A	Mrs G Cochrane	Music
3				Mrs F Noonan	H. Econ
4				Mr N Wilson
5				Miss H Wright	English
6				Mrs C Martin	French
7				Dr B Henry	Geography
8				Dr M Murphy	History
9				Mr I Hackney	Maths
10				Mr N Wilson	Religion
11				Mrs E Collins	Science
12				Miss J McGrail	Art
13				Mrs H McCambridge	P E
14				Mrs K Andersson	Technology
15				Mrs C Hanna	Irish
16				Mrs K Craig	Spanish
17				Mr N Wilson	Form Class
18	Bogues	Rachel	10A	Mrs G Cochrane	Music
19				Mrs F Noonan	H. Econ
20				Mr N Wilson	Form Class
21				Mr P Maginn	Latin
ReportData

 

[NBVC]

If those student names are prefilled in A-C every so often, then I think the easiest way is to select the the 3 cells and copy down to the next student and so on. Even if you use a formula, you will have to do the copy down thing.

 

[Domenic]

Try the following...

1) Select/highlight Columns A, B, and C

2) Edit > Go To > Special > Blanks > Ok

3) Press =

4) Press the 'Up Arrow'

5) Confirm with CONTROL+ENTER

Hope this helps!

 

[NBVC]

Try the following...

1) Select/highlight Columns A, B, and C

2) Edit > Go To > Special > Blanks > Ok

3) Press =

4) Press the 'Up Arrow'

5) Confirm with CONTROL+ENTER

Hope this helps!

Domenic, that's cool

Didn't know about that one.

 

[dpbarry]

Try the following...

1) Select/highlight Columns A, B, and C

2) Edit > Go To > Special > Blanks > Ok

3) Press =

4) Press the 'Up Arrow'

5) Confirm with CONTROL+ENTER

Hope this helps!

Wheee!!! Worked a treat. In fact it worked so well that it also answered my next question where I wanted to delete the entire row if any of the cells in the row were blank.

1) Select/highlight Column with blank cell in it

2) Edit > Go To > Special > Blanks > Ok

3) Edit > Delete > Entire Row

Many Thanks

Declan