+ Reply to Thread
Results 1 to 4 of 4

Auto-fill blanks with zeros

  1. 06-18-2014, 02:07 PM #1
    jtneher
    jtneher is offline
    Registered User
    Join Date
    12-13-2013
    Location
    Mount Pleasant, SC
    MS-Off Ver
    Excel 2010
    Posts
    6

    Auto-fill blanks with zeros

    How do I auto-fill the blanks in a range with zeros?
    Reply With QuoteRegister To Reply
  2. 06-18-2014, 02:23 PM #2
    sktneer
    sktneer is offline
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,648

    Re: Auto-fill blanks with zeros

    Try this...

    Ctrl+G --> Special --> Blank --> input 0 and press Ctrl+Enter.

    Does that help?
    Regards
    sktneer

    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.
    Reply With QuoteRegister To Reply
  3. 06-18-2014, 02:36 PM #3
    jtneher
    jtneher is offline
    Registered User
    Join Date
    12-13-2013
    Location
    Mount Pleasant, SC
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: Auto-fill blanks with zeros

    that did it. Thanks!
    Reply With QuoteRegister To Reply
  4. 06-18-2014, 02:44 PM #4
    sktneer
    sktneer is offline
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,648

    Re: Auto-fill blanks with zeros

    You're welcome.
    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. Fill blanks with zeros
    By Snark in forum Excel General
    Replies: 1
    Last Post: 07-15-2008, 04:33 PM
  2. formulas with blanks and zeros
    By rebraku in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 09-18-2007, 06:39 PM
  3. How do I auto fill long col. filling blanks with last filled cell
    By MBBeginner in forum Excel General
    Replies: 3
    Last Post: 01-14-2006, 08:50 PM
  4. [SOLVED] How do I auto fill blanks cells immediately below with the same i.
    By leo in forum Excel General
    Replies: 2
    Last Post: 03-16-2005, 02:06 PM
  5. Ignore blanks or zeros
    By gil0730 in forum Excel General
    Replies: 1
    Last Post: 02-03-2005, 12:12 AM

Tags for this Thread

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