Thanks Thanks:  0
Likes Likes:  0
Results 1 to 7 of 7

Thread: Problems using "Go to special - Blanks"

  1. #1
    Board Regular
    Join Date
    Jan 2007
    Location
    LIVERPOOL UK
    Posts
    704
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Problems using "Go to special - Blanks"

    Hello All,
    I'm trying to use the "Go to Special" - Blanksfunction.
    This is something I've used many times without a problem but this time it's just returning "No cells were found". I've tried the same principal on another worksheet with made up numbers and it works ok, so I know I'm using it ok. My gut feeling is that it's a formatting issue? Can anyone please help.
    Using Excel 2007
    Thanks Jase
    Last edited by Spraggs; Jun 6th, 2011 at 01:05 PM.

  2. #2
    MrExcel MVP Jonmo1's Avatar
    Join Date
    Oct 2006
    Location
    Bryan, TX
    Posts
    44,054
    Post Thanks / Like
    Mentioned
    19 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Problems using "Go to special - Blanks"

    Sounds like your blanks are not truely blank.

    Were they formulas returning "", that you have since done copy / paste special / values ?

    If so, "" is not truely blank, it's a null text string.
    Even after paste special / values.

    Try highlight the column,
    Click Data - Text To Columns
    Click Finish


    Hope that helps.
    Use the MrExcel HTML Maker to post nicely formatted tables in your forum posts.
    Find a link in post number 31

    The more we learn, and the better we get at our trade, the easier it becomes to overlook the obvious.

    Life moves pretty fast. If you don't stop and look around once in a while, you could miss it.
    Ferris Bueller A.K.A. John Hughes, 1986

  3. #3
    Board Regular
    Join Date
    Jan 2007
    Location
    LIVERPOOL UK
    Posts
    704
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Problems using "Go to special - Blanks"

    Spot on Jonmo,
    Regards Jase

  4. #4
    New Member
    Join Date
    May 2011
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Problems using "Go to special - Blanks"

    What would be your suggestion if the Text to Columns advice did not work?
    I've tried cutting/pasting, (with just values), in different workbooks, on different sheets. I would say too that they are not truelly blank, but I'm out of ideas how to make this just "cut" or Past just the text (or lack of)...


    Thanks!

  5. #5
    New Member
    Join Date
    Feb 2016
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Problems using "Go to special - Blanks"

    I just found this thread, and had the same issue. After attempting to copy - paste values, I was still unable to jump the blank cells with Ctrl + down arrow.

    Text to column did fix the issue however.

    If you run into this problem try this:

    - Select column
    - Copy - paste values
    - Select column
    - Text to Column
    - Delimited
    - "Tab" box only
    - Next
    - Finish

    After that, all my functionality was restored and could bounce and select blanks as needed.

  6. #6
    New Member
    Join Date
    Sep 2017
    Location
    Fort Worth TX
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Problems using "Go to special - Blanks"

    Not working I tried this solution and I am still getting the "no cell found" error ..... any different solution?

  7. #7
    New Member
    Join Date
    Sep 2017
    Location
    Fort Worth TX
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Problems using "Go to special - Blanks"

    Got it... I did a Data Filter picked the blank cells and clear the contents and it now works .... YEAH

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
  •