Thread: [Solved] Place 0 in blank cell
View Single Post
 
Old 06-19-2014, 05:10 PM
macropod's Avatar
macropod macropod is offline Windows 7 32bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,340
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
If you want to put 0s into blank cells:
• insert a 0 in to any cell
• copy the 0 to the clipboard
• select the destination range (even spanning cells that aren't empty, but not including cells that have formulae)
• use Paste Special>Values>Add
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote