# Filling in blank cells with previous cell data

#### dpbarry

##### Board Regular
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
ABCDE
1Legal SurnameLegal ForenameRegTeacherSubject
2AustinGemma10AMrs G CochraneMusic
3Mrs F NoonanH. Econ
4Mr N Wilson
5Miss H WrightEnglish
6Mrs C MartinFrench
7Dr B HenryGeography
8Dr M MurphyHistory
9Mr I HackneyMaths
10Mr N WilsonReligion
11Mrs E CollinsScience
12Miss J McGrailArt
13Mrs H McCambridgeP E
15Mrs C HannaIrish
16Mrs K CraigSpanish
17Mr N WilsonForm Class
18BoguesRachel10AMrs G CochraneMusic
19Mrs F NoonanH. Econ
20Mr N WilsonForm Class
21Mr P MaginnLatin
ReportData

### Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.
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.

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 said:
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.

Domenic said:
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

Replies
8
Views
126
Replies
1
Views
131
Replies
1
Views
178
Replies
5
Views
182
Replies
6
Views
107

1,196,514
Messages
6,015,649
Members
441,913
Latest member
Lhayden_69

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back