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

Excel

Discussion in 'Microsoft Office Specialist (MOS)' started by Peter, Jun 9, 2005.

  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,282
    73
    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...