+ Reply to Thread
Results 1 to 4 of 4

Locate blank cells in large table

  1. 11-30-2016, 02:49 PM #1
    Davjel
    Davjel is offline
    Registered User
    Join Date
    11-05-2014
    Location
    Lancashire
    MS-Off Ver
    2007
    Posts
    6

    Locate blank cells in large table

    I have a large table of data 15 columns and in excess of 15,000 rows.
    Is there any way I can search for blank cells and replace with zero.
    Thanks for any help
    Reply With QuoteRegister To Reply
  2. 11-30-2016, 02:59 PM #2
    rahi_feri
    rahi_feri is offline
    Registered User
    Join Date
    09-09-2013
    Location
    Iran
    MS-Off Ver
    Excel 2010
    Posts
    56

    Re: Locate blank cells in large table

    Hi
    select the range
    then open Goto Special window
    1)
    index.jpg

    and select Blamks
    2)
    doc-select-blank-cells-01.jpg

    and type 0 and press ctrl+enter
    Last edited by rahi_feri; 11-30-2016 at 03:09 PM.
    Islam = Peace
    Shia = Peace
    Iran = Peace
    Reply With QuoteRegister To Reply
  3. 11-30-2016, 03:04 PM #3
    Pete_UK
    Pete_UK is offline
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    25,411

    Re: Locate blank cells in large table

    Highlight all the data in the table, do Ctrl-H (Find & Replace), and:

    Find what: leave blank
    Replace with: 0
    Click Replace All.

    Hope this helps.

    Pete
    Reply With QuoteRegister To Reply
  4. 12-02-2016, 01:24 AM #4
    Davjel
    Davjel is offline
    Registered User
    Join Date
    11-05-2014
    Location
    Lancashire
    MS-Off Ver
    2007
    Posts
    6

    Re: Locate blank cells in large table

    Thank you for your help
    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)

Similar Threads

  1. Pivot table in blank cells it says blank.... i want it empty
    By appell in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-27-2014, 09:43 AM
  2. HELP: Counting the number of cells in with values in a large table
    By tyler3135 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-14-2014, 08:32 PM
  3. How remove zero values representing blank cells from original table connected to new table
    By _Rapier_ in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 11-22-2013, 02:52 PM
  4. Locate blank cells, insert dynamic value
    By rynofrowan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-14-2013, 07:30 AM
  5. Filter out blank cells in large spreadsheet
    By toadeh in forum Excel General
    Replies: 3
    Last Post: 10-04-2012, 10:02 AM
  6. Removing blank cells in a large matrix
    By Bandit in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-13-2009, 02:47 PM
  7. pivot table counting blank cells in data table
    By nicko54 in forum Excel General
    Replies: 4
    Last Post: 09-23-2008, 11:26 AM
  8. pivot table counting blank cells in data table Continued
    By nicko54 in forum Excel General
    Replies: 2
    Last Post: 09-23-2008, 11:01 AM

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