+ Reply to Thread
Results 1 to 5 of 5

Blank Cells

  1. 04-19-2005, 02:52 PM #1
    GSmith
    GSmith is offline
    Registered User
    Join Date
    04-19-2005
    Posts
    8

    Blank Cells

    Hello.

    If I want to select blank cells in a range, and if I select that range and do

    F5>Special>Blanks>OK... it says 'no blank cells were found'

    Any tips?

    Edit: well, those blank cells were formatted bold and centered... when I changed them back to regular and left-aligned, the problem persists. Please help.
    Last edited by GSmith; 04-19-2005 at 02:54 PM.
    Reply With QuoteRegister To Reply
  2. 04-19-2005, 03:29 PM #2
    GSmith
    GSmith is offline
    Registered User
    Join Date
    04-19-2005
    Posts
    8
    can anyone please help me with this? I searched and couldn't find anything that would help me!
    Reply With QuoteRegister To Reply
  3. 04-19-2005, 04:40 PM #3
    GSmith
    GSmith is offline
    Registered User
    Join Date
    04-19-2005
    Posts
    8
    anyone? I can see that those cells are blank but Excel does not select them
    Reply With QuoteRegister To Reply
  4. 04-20-2005, 08:33 AM #4
    Domenic
    Domenic is offline
    Forum Expert
    Join Date
    06-18-2004
    Location
    Canada
    MS-Off Ver
    Office 2016
    Posts
    1,474
    Do the "empty cells" actually contain formulas?
    Reply With QuoteRegister To Reply
  5. 04-20-2005, 08:40 AM #5
    cycling-rod
    cycling-rod is offline
    Forum Contributor
    Join Date
    08-23-2004
    Posts
    210
    I've had no problems selecting blank cells in a range using excel97. Have you tried in a new sheet or new workbook?
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1