Fill In space

[Guest]

Hello
I am wondering if I have a data with the following format
Data
12




23



45



67
I need to fill in the space with the number above, is there an easy way to do that?
Please help
Thank you

 

[Mark W.]

Select your column of values. Choose the Edit | Go To... | Special Blanks menu command. Type a reference to the unselected cell above the active cell (i.e., if your first data value is in cell A1, the you'd be entering =A1 into the active cell, A2). Press Control+Enter which will place the entered formula in each selected, empty cell. Select your column of values once more and perform Copy/Paste Special Values.

 

[Guest]

This is easy but I hope that I can give you the correct steps as I have the menu in hebrew:
Choose the cells that in column containing data and blanks
Edit
Move to
Special
Blanks
now enter in the active cell formula "=A1"
Ctrl+Enter
This will fill all blanks with the data above them
Eli

 

[Guest]

Thanks Mark
it works the way i need it
One more question, is there a way to make those duplicated cells blank?
eg. makes the number in white text
please help
Thanks again

 

[Mark W.]

On 2002-03-07 08:34, Anonymous wrote:
Thanks Mark
it works the way i need it
One more question, is there a way to make those duplicated cells blank?
eg. makes the number in white text
please help
Thanks again

Yes, using Conditional Formatting with a Formula Is condition of...

=A2=A1

Before applying this condition select column A and tab to cell A2 to make it the active cell.

 

[Guest]

That is so cool
Thanks alot Mark