{"id":9398,"date":"2019-10-31T08:01:02","date_gmt":"2019-10-31T06:01:02","guid":{"rendered":"http:\/\/www.officetodo.com\/public\/?p=9398"},"modified":"2019-10-31T08:01:03","modified_gmt":"2019-10-31T06:01:03","slug":"how-to-fill-cells-with-similar-information-with-a-quick-function-excel-2007","status":"publish","type":"post","link":"https:\/\/www.officetodo.com\/public\/how-to-fill-cells-with-similar-information-with-a-quick-function-excel-2007\/","title":{"rendered":"How to fill cells with similar information with a quick function? | Excel 2007"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Let&#8217;s say\nyou have some cells in one column filled with numbers and other cells in the\nsame column are empty. What we want to do now is enter zeros into the cells\nthat are empty. Select the area you want to be filled. Go to the Home tab under\nEditing section and choose Find &amp; Select. From the drop-down menu choose\n&#8220;Replace &#8230;&#8221; Into the &#8220;Find what&#8221; do not enter anything\nand into &#8220;Replace with&#8221; enter a zero. Now press the &#8220;Replace\nAll&#8221; button.<\/p>\n\n\n\n<!--more-->\n\n\n\n<figure class=\"wp-block-embed-youtube wp-block-embed is-type-video is-provider-youtube wp-embed-aspect-4-3 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe loading=\"lazy\" title=\"How to fill cells with similar information with a quick function? | Excel 2007\" width=\"625\" height=\"469\" src=\"https:\/\/www.youtube.com\/embed\/i5FChf2l7V4?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Let&#8217;s say you have some cells in one column filled with numbers and other cells in the same column are empty. What we want to do now is enter zeros into the cells that are empty. Select the area you want to be filled. Go to the Home tab under Editing section and choose Find [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3501],"tags":[3509,3795,3794],"class_list":["post-9398","post","type-post","status-publish","format-standard","hentry","category-excel-2007","tag-excel-2007","tag-function","tag-quick"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/posts\/9398","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/comments?post=9398"}],"version-history":[{"count":1,"href":"https:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/posts\/9398\/revisions"}],"predecessor-version":[{"id":9399,"href":"https:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/posts\/9398\/revisions\/9399"}],"wp:attachment":[{"href":"https:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/media?parent=9398"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/categories?post=9398"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/tags?post=9398"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}