Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Filling in blank cells with cell above
I have a column and I would like to fill the cells below it with the same
data as above. Sometimes there are more than one blank row below the Policy number. Column A Policy line 1 20BSBEX3110 line 2 line 3 20BSBEX9371 line 4 line 5 BINDER8083096 line 6 line 7 line 8 line 9 BINDER8083096 Line 10 Line 11 Thanks Donna |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Filling in blank cells with cell above
Select the whole range of cells making up your data (A1:A11 in your example).
Press F5, then click Special Blanks OK. Now all the blank cells within your data are selected. Press the equal sign (=), then the up arrow. Hold down the Ctrl key and press Enter. This puts a formula in every blank cell, pulling the value from the cell above it. Finally, copy & paste the whole selected range in place as values. Hope this helps, Hutch "Donna" wrote: I have a column and I would like to fill the cells below it with the same data as above. Sometimes there are more than one blank row below the Policy number. Column A Policy line 1 20BSBEX3110 line 2 line 3 20BSBEX9371 line 4 line 5 BINDER8083096 line 6 line 7 line 8 line 9 BINDER8083096 Line 10 Line 11 Thanks Donna |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Filling in blank cells with cell above
Tom,
Thank you so much! It worked perfectly! Donna "Tom Hutchins" wrote: Select the whole range of cells making up your data (A1:A11 in your example). Press F5, then click Special Blanks OK. Now all the blank cells within your data are selected. Press the equal sign (=), then the up arrow. Hold down the Ctrl key and press Enter. This puts a formula in every blank cell, pulling the value from the cell above it. Finally, copy & paste the whole selected range in place as values. Hope this helps, Hutch "Donna" wrote: I have a column and I would like to fill the cells below it with the same data as above. Sometimes there are more than one blank row below the Policy number. Column A Policy line 1 20BSBEX3110 line 2 line 3 20BSBEX9371 line 4 line 5 BINDER8083096 line 6 line 7 line 8 line 9 BINDER8083096 Line 10 Line 11 Thanks Donna |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
problem filling in blank cells with data above - | Excel Discussion (Misc queries) | |||
Filling in blank cells with information from cells above it | Excel Discussion (Misc queries) | |||
Filling Blank Cells | Excel Worksheet Functions | |||
Filling Blank Cells | Excel Discussion (Misc queries) | |||
Filling in Blank Cells | New Users to Excel |