Home / Discussions

Reply to Message

Goto
Select the complete range (Ctrl+A)
Press Ctrl + G (Goto)
Press Alt + S (Special)
Press K (for Blanks) and then press enter

Press 0 and then press Ctrl + Enter to populate all blanks with zero's

Do let me know how it goes!
Posted by Sherinx
Updated - 29th Sep 2011