Thread: [Solved] Place 0 in blank cell
View Single Post
 
Old 06-20-2014, 12:40 PM
Mjpunj Mjpunj is offline Windows 7 32bit Office 2010 32bit
Novice
 
Join Date: Jun 2014
Posts: 7
Mjpunj is on a distinguished road
Default

type a zero into a cell, copy it to your clip board, highlight the cells you want to replace blanks with zeros in, hit F5, click the radio button next to "blanks"; click OK, then hit CTRL+V
Reply With Quote