1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.
  1. Peter

    Peter Byte Poster

    232
    0
    28
    I am stuck,
    How can you deleate blank cells in a colum that is huge and that has blank spaces all the way through, I know how to sort but that just sorts in order,

    I want to leave the doc as it is but just get rid of the blanks,
    I want do do this in one block so that they all go at the same time, not having to go through the whole doc highlighting blanks and deleating,
    Any Idea's,:rolleyes:
     
    Certifications: Elec & Eelc Eng A+
    WIP: CCNA-CCNP
  2. Mitzs
    Honorary Member

    Mitzs Ducktape Goddess

    3,286
    85
    152
    here a macro for deleting rows.

    http://www.cpearson.com/excel/deleting.htm
     
    Certifications: Microcomputers and network specialist.
    WIP: Adobe DW, PS
  3. sirdragon

    sirdragon Nibble Poster

    70
    0
    11
    try using an filter or autofilter on the col where there are blanks then copy and paste if you need to.
     
  4. Peter

    Peter Byte Poster

    232
    0
    28
    Thanks for that guys the auto filter done the trick:D :D :D
     
    Certifications: Elec & Eelc Eng A+
    WIP: CCNA-CCNP

Share This Page

Loading...