Monday, July 16, 2012

Fill in a Range with 0's

Have you ever wanted to fill in the blank cells with the same number?  You can by following these little steps.

Select range > F5 > Special > Blanks > OK > 0 then Ctrl+Enter

No comments:

Post a Comment