| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Fill in blank cells with line above
I need to fill in the blank cells with the information from the cell above
until the next cell is not null. For example: Column A Bill blank blank Bob I need the blanks to read as Bill. Is there a function or something I can use. |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Fill in blank cells with line above
Watch this short video:
http://www.contextures.com/xlVideos01.html#FillBlanks -- Biff Microsoft Excel MVP "gleakos" wrote in message ... I need to fill in the blank cells with the information from the cell above until the next cell is not null. For example: Column A Bill blank blank Bob I need the blanks to read as Bill. Is there a function or something I can use. |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Fill in blank cells with line above
Select the column then F5SpecialBlanksOK
Type an = sign in active blank cell then point or arrow up to cell above. Hit CTRL + ENTER CopyPaste SpecialValuesOKEsc Gord Dibben MS Excel MVP On Mon, 15 Sep 2008 14:01:01 -0700, gleakos wrote: I need to fill in the blank cells with the information from the cell above until the next cell is not null. For example: Column A Bill blank blank Bob I need the blanks to read as Bill. Is there a function or something I can use. |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Fill in blank cells with line above
Hi Gord Dibben, Good Work dear Thanks =============================== "Gord Dibben" wrote: Select the column then F5SpecialBlanksOK Type an = sign in active blank cell then point or arrow up to cell above. Hit CTRL + ENTER CopyPaste SpecialValuesOKEsc Gord Dibben MS Excel MVP On Mon, 15 Sep 2008 14:01:01 -0700, gleakos wrote: I need to fill in the blank cells with the information from the cell above until the next cell is not null. For example: Column A Bill blank blank Bob I need the blanks to read as Bill. Is there a function or something I can use. |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Fill in blank cells with line above
I did this, but must be missing something.. It kept blanks highlighted blue
but only copied to the cell below.. it did not fill all blanks with the data above as shown in video. "T. Valko" wrote: Watch this short video: http://www.contextures.com/xlVideos01.html#FillBlanks -- Biff Microsoft Excel MVP "gleakos" wrote in message ... I need to fill in the blank cells with the information from the cell above until the next cell is not null. For example: Column A Bill blank blank Bob I need the blanks to read as Bill. Is there a function or something I can use. |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Fill in blank cells with line above
Thanks.. the CNTRL ENTER is what was missing from the prior reply.. Thanks
again "Gord Dibben" wrote: Select the column then F5SpecialBlanksOK Type an = sign in active blank cell then point or arrow up to cell above. Hit CTRL + ENTER CopyPaste SpecialValuesOKEsc Gord Dibben MS Excel MVP On Mon, 15 Sep 2008 14:01:01 -0700, gleakos wrote: I need to fill in the blank cells with the information from the cell above until the next cell is not null. For example: Column A Bill blank blank Bob I need the blanks to read as Bill. Is there a function or something I can use. |
|
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Fill in blank cells with line above
Watch the video again. It is there.
Fat Jack Utah wrote: Thanks.. the CNTRL ENTER is what was missing from the prior reply.. Thanks again "Gord Dibben" wrote: Select the column then F5SpecialBlanksOK Type an = sign in active blank cell then point or arrow up to cell above. Hit CTRL + ENTER CopyPaste SpecialValuesOKEsc Gord Dibben MS Excel MVP On Mon, 15 Sep 2008 14:01:01 -0700, gleakos wrote: I need to fill in the blank cells with the information from the cell above until the next cell is not null. For example: Column A Bill blank blank Bob I need the blanks to read as Bill. Is there a function or something I can use. -- Dave Peterson |
|
#8
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Fill in blank cells with line above
try this idea from a posting of mine today. Sub copydn() mc = 2 'column B For i = 1 To cells(rows.count,mc).end(xlup).row If Cells(i + 1, mc) = "" Then Cells(i + 1, mc) = Cells(i, mc) End If Next i End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "Fat Jack Utah" wrote in message ... I did this, but must be missing something.. It kept blanks highlighted blue but only copied to the cell below.. it did not fill all blanks with the data above as shown in video. "T. Valko" wrote: Watch this short video: http://www.contextures.com/xlVideos01.html#FillBlanks -- Biff Microsoft Excel MVP "gleakos" wrote in message ... I need to fill in the blank cells with the information from the cell above until the next cell is not null. For example: Column A Bill blank blank Bob I need the blanks to read as Bill. Is there a function or something I can use. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Fill in blank cells | Excel Discussion (Misc queries) | |||
| Fill blank cells with spaces | Excel Worksheet Functions | |||
| FILL IN BLANK CELLS | Excel Discussion (Misc queries) | |||
| how can i fill blank cells in column with abc while the right col. | Excel Discussion (Misc queries) | |||
| Fill blank cells | Excel Discussion (Misc queries) | |||
Linear Mode
