Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 6 of 6

Thread: Fill In space

  1. #1
    Guest

    Default

    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

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.

  3. #3
    Guest

    Default

    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

  4. #4
    Guest

    Default

    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

  5. #5
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.

  6. #6
    Guest

    Default

    That is so cool
    Thanks alot Mark

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •