{"id":1785,"date":"2022-06-14T11:40:10","date_gmt":"2022-06-14T03:40:10","guid":{"rendered":"https:\/\/www.fyndpro.com\/?p=1785"},"modified":"2026-08-27T16:11:08","modified_gmt":"2026-08-27T08:11:08","slug":"fillinblank","status":"publish","type":"post","link":"https:\/\/www.fyndpro.com\/cn\/fillinblank\/","title":{"rendered":"\u5c07\u7a7a\u767d\u5132\u5b58\u683c\u586b\u5165\u5167\u5bb9"},"content":{"rendered":"<h3>\u586b\u5165\u7a7a\u767d\u5132\u5b58\u683c\u5167\u5bb9<\/h3>\n<p>\u5728 Excel \u8a66\u7b97\u8868\u4e2d\uff0c\u7a7a\u767d\u5132\u5b58\u683c\u6709\u6642\u6703\u5f71\u97ff\u5de5\u4f5c\u8868\u7684\u6574\u9ad4\u5916\u89c0\u548c\u53ef\u8b80\u6027\u3002\u6709\u5e7e\u7a2e\u65b9\u6cd5\u53ef\u4ee5\u5feb\u901f\u586b\u5165\u9019\u4e9b\u7a7a\u767d\u5132\u5b58\u683c\uff0c\u6539\u5584\u5de5\u4f5c\u8868\u7684\u8996\u89ba\u6548\u679c\u3002<\/p>\n<h4>1. \u4f7f\u7528 Ctrl + G<\/h4>\n<ul>\n<li><strong>\u9078\u53d6\u7bc4\u570d<\/strong>: \u9078\u53d6\u8981\u586b\u5165\u7a7a\u767d\u7684\u5132\u5b58\u683c\u7bc4\u570d\u3002<\/li>\n<li><strong>\u6309 Ctrl + G<\/strong>: This opens the &#8220;Go To&#8221; dialog box.<\/li>\n<li><strong>Click on &#8220;Special&#8221;<\/strong>: In the dialog box, select &#8220;Special.&#8221;<\/li>\n<\/ul>\n<p><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-2361 size-full\" src=\"https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2022\/06\/%E5%B0%87%E7%A9%BA%E7%99%BD%E5%84%B2%E5%AD%98%E6%A0%BC%E5%A1%AB%E6%BB%BF%E5%85%A7%E5%AE%B91.jpg?resize=830%2C479&#038;ssl=1\" alt=\"\" width=\"830\" height=\"479\" srcset=\"https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2022\/06\/%E5%B0%87%E7%A9%BA%E7%99%BD%E5%84%B2%E5%AD%98%E6%A0%BC%E5%A1%AB%E6%BB%BF%E5%85%A7%E5%AE%B91.jpg?w=830&amp;ssl=1 830w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2022\/06\/%E5%B0%87%E7%A9%BA%E7%99%BD%E5%84%B2%E5%AD%98%E6%A0%BC%E5%A1%AB%E6%BB%BF%E5%85%A7%E5%AE%B91.jpg?resize=300%2C173&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2022\/06\/%E5%B0%87%E7%A9%BA%E7%99%BD%E5%84%B2%E5%AD%98%E6%A0%BC%E5%A1%AB%E6%BB%BF%E5%85%A7%E5%AE%B91.jpg?resize=768%2C443&amp;ssl=1 768w\" sizes=\"auto, (max-width: 830px) 100vw, 830px\" \/><\/p>\n<ul>\n<li><strong>Choose &#8220;Blanks&#8221;<\/strong>: \u9019\u6703\u9078\u53d6\u5df2\u6a19\u793a\u7bc4\u570d\u4e2d\u6240\u6709\u7684\u7a7a\u767d\u5132\u5b58\u683c\u3002<\/li>\n<\/ul>\n<p><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-2364 size-full\" src=\"https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2022\/06\/%E5%B0%87%E7%A9%BA%E7%99%BD%E5%84%B2%E5%AD%98%E6%A0%BC%E5%A1%AB%E6%BB%BF%E5%85%A7%E5%AE%B92.jpg?resize=875%2C509&#038;ssl=1\" alt=\"\" width=\"875\" height=\"509\" srcset=\"https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2022\/06\/%E5%B0%87%E7%A9%BA%E7%99%BD%E5%84%B2%E5%AD%98%E6%A0%BC%E5%A1%AB%E6%BB%BF%E5%85%A7%E5%AE%B92.jpg?w=875&amp;ssl=1 875w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2022\/06\/%E5%B0%87%E7%A9%BA%E7%99%BD%E5%84%B2%E5%AD%98%E6%A0%BC%E5%A1%AB%E6%BB%BF%E5%85%A7%E5%AE%B92.jpg?resize=300%2C175&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2022\/06\/%E5%B0%87%E7%A9%BA%E7%99%BD%E5%84%B2%E5%AD%98%E6%A0%BC%E5%A1%AB%E6%BB%BF%E5%85%A7%E5%AE%B92.jpg?resize=150%2C87&amp;ssl=1 150w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2022\/06\/%E5%B0%87%E7%A9%BA%E7%99%BD%E5%84%B2%E5%AD%98%E6%A0%BC%E5%A1%AB%E6%BB%BF%E5%85%A7%E5%AE%B92.jpg?resize=768%2C447&amp;ssl=1 768w\" sizes=\"auto, (max-width: 875px) 100vw, 875px\" \/><\/p>\n<ul>\n<li><strong>\u8f38\u5165\u516c\u5f0f<\/strong>: \u8f38\u5165\u516c\u5f0f\u00a0<code>=\u4e0a\u4e00\u500b\u5132\u5b58\u683c<\/code>. \u4f8b\u5982\uff0c\u5982\u679c\u8cc7\u6599\u7684\u7b2c\u4e00\u884c\u5f9e A2 \u958b\u59cb\uff0c\u4f60\u6703\u8f38\u5165\u00a0<code>=A2<\/code>.<\/li>\n<\/ul>\n<p><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-2365 size-full\" src=\"https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2022\/06\/%E5%B0%87%E7%A9%BA%E7%99%BD%E5%84%B2%E5%AD%98%E6%A0%BC%E5%A1%AB%E6%BB%BF%E5%85%A7%E5%AE%B93.jpg?resize=904%2C557&#038;ssl=1\" alt=\"\" width=\"904\" height=\"557\" srcset=\"https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2022\/06\/%E5%B0%87%E7%A9%BA%E7%99%BD%E5%84%B2%E5%AD%98%E6%A0%BC%E5%A1%AB%E6%BB%BF%E5%85%A7%E5%AE%B93.jpg?w=904&amp;ssl=1 904w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2022\/06\/%E5%B0%87%E7%A9%BA%E7%99%BD%E5%84%B2%E5%AD%98%E6%A0%BC%E5%A1%AB%E6%BB%BF%E5%85%A7%E5%AE%B93.jpg?resize=300%2C185&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2022\/06\/%E5%B0%87%E7%A9%BA%E7%99%BD%E5%84%B2%E5%AD%98%E6%A0%BC%E5%A1%AB%E6%BB%BF%E5%85%A7%E5%AE%B93.jpg?resize=150%2C92&amp;ssl=1 150w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2022\/06\/%E5%B0%87%E7%A9%BA%E7%99%BD%E5%84%B2%E5%AD%98%E6%A0%BC%E5%A1%AB%E6%BB%BF%E5%85%A7%E5%AE%B93.jpg?resize=768%2C473&amp;ssl=1 768w\" sizes=\"auto, (max-width: 904px) 100vw, 904px\" \/><\/p>\n<ul>\n<li><strong>\u6309 Ctrl + Enter<\/strong>: \u9019\u6703\u7528\u6307\u5b9a\u7684\u516c\u5f0f\u586b\u6eff\u6240\u6709\u9078\u53d6\u7684\u7a7a\u767d\u5132\u5b58\u683c\u3002<\/li>\n<\/ul>\n<h4>2. \u4f7f\u7528 =IF() \u51fd\u6578<\/h4>\n<ul>\n<li><strong>Formula<\/strong>: \u4f7f\u7528\u4ee5\u4e0b\u516c\u5f0f\u00a0<code>=IF(A2&lt;&gt;\"\", A2, D1)<\/code>.<\/li>\n<\/ul>\n<p><em><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-2371 size-full\" src=\"https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2022\/06\/%E5%B0%87%E7%A9%BA%E7%99%BD%E5%84%B2%E5%AD%98%E6%A0%BC%E5%A1%AB%E6%BB%BF%E5%85%A7%E5%AE%B94.jpg?resize=1116%2C645&#038;ssl=1\" alt=\"\" width=\"1116\" height=\"645\" srcset=\"https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2022\/06\/%E5%B0%87%E7%A9%BA%E7%99%BD%E5%84%B2%E5%AD%98%E6%A0%BC%E5%A1%AB%E6%BB%BF%E5%85%A7%E5%AE%B94.jpg?w=1116&amp;ssl=1 1116w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2022\/06\/%E5%B0%87%E7%A9%BA%E7%99%BD%E5%84%B2%E5%AD%98%E6%A0%BC%E5%A1%AB%E6%BB%BF%E5%85%A7%E5%AE%B94.jpg?resize=300%2C173&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2022\/06\/%E5%B0%87%E7%A9%BA%E7%99%BD%E5%84%B2%E5%AD%98%E6%A0%BC%E5%A1%AB%E6%BB%BF%E5%85%A7%E5%AE%B94.jpg?resize=1024%2C592&amp;ssl=1 1024w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2022\/06\/%E5%B0%87%E7%A9%BA%E7%99%BD%E5%84%B2%E5%AD%98%E6%A0%BC%E5%A1%AB%E6%BB%BF%E5%85%A7%E5%AE%B94.jpg?resize=150%2C87&amp;ssl=1 150w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2022\/06\/%E5%B0%87%E7%A9%BA%E7%99%BD%E5%84%B2%E5%AD%98%E6%A0%BC%E5%A1%AB%E6%BB%BF%E5%85%A7%E5%AE%B94.jpg?resize=768%2C444&amp;ssl=1 768w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/em><\/p>\n<ul>\n<li><strong>\u516c\u5f0f\u8aaa\u660e<\/strong>: \u6b64\u516c\u5f0f\u6703\u6aa2\u67e5 A2 \u662f\u5426\u4e0d\u70ba\u7a7a\u3002\u5982\u679c\u6709\u5167\u5bb9\uff0c\u8f38\u51fa A2 \u7684\u5167\u5bb9\uff1b\u5426\u5247\u63a1\u7528\u540c\u4e00\u6b04\u4e0a\u65b9\u7684\u5132\u5b58\u683c\uff08D\uff09\u7684\u5167\u5bb9\u3002\n<ul>\n<li>For example, in cell D2, if A2 is &#8220;\u6703\u8a08&#8221; the formula will return &#8220;\u6703\u8a08&#8221;<\/li>\n<li>\u5982\u679c A3 \u70ba\u7a7a\uff0c\u90a3\u9ebc\u5728 D3 \u4e2d\uff0c\u516c\u5f0f\u00a0<code>=IF(A3&lt;&gt;\"\", A3, D2)<\/code> will return the content from D2, which is also &#8220;\u6703\u8a08&#8221;<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>\u900f\u904e\u9019\u4e9b\u65b9\u6cd5\uff0c\u4f60\u53ef\u4ee5\u6709\u6548\u5730\u586b\u88dc Excel \u5de5\u4f5c\u8868\u4e2d\u7684\u7a7a\u767d\u5132\u5b58\u683c\uff0c\u63d0\u5347\u8868\u683c\u7684\u6e05\u6670\u5ea6\u8207\u5448\u73fe\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u586b\u5165\u7a7a\u767d\u5132\u5b58\u683c\u5167\u5bb9 \u5728 Excel \u8a66\u7b97\u8868\u4e2d\uff0c\u7a7a\u767d\u5132\u5b58\u683c\u6709\u6642\u6703\u5f71\u97ff\u5de5\u4f5c\u8868\u7684\u6574\u9ad4\u5916\u89c0\u548c\u53ef\u8b80\u6027\u3002\u6709\u5e7e\u7a2e\u65b9\u6cd5\u53ef\u4ee5\u5feb\u901f [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":3791,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_post_was_ever_published":false},"categories":[8,20],"tags":[275,293,27,92,190,191,267,279],"class_list":["post-1785","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","category-onlinesupport","tag-ctrlg-2","tag-excel","tag-if","tag-lookup","tag-powerquery","tag-special-target","tag-blank-cells","tag-data-filling"],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2026\/08\/new_covers_batch_03_1809_excel.jpg?fit=816%2C1088&ssl=1","_links":{"self":[{"href":"https:\/\/www.fyndpro.com\/cn\/wp-json\/wp\/v2\/posts\/1785","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.fyndpro.com\/cn\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.fyndpro.com\/cn\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.fyndpro.com\/cn\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.fyndpro.com\/cn\/wp-json\/wp\/v2\/comments?post=1785"}],"version-history":[{"count":10,"href":"https:\/\/www.fyndpro.com\/cn\/wp-json\/wp\/v2\/posts\/1785\/revisions"}],"predecessor-version":[{"id":3820,"href":"https:\/\/www.fyndpro.com\/cn\/wp-json\/wp\/v2\/posts\/1785\/revisions\/3820"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.fyndpro.com\/cn\/wp-json\/wp\/v2\/media\/3791"}],"wp:attachment":[{"href":"https:\/\/www.fyndpro.com\/cn\/wp-json\/wp\/v2\/media?parent=1785"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.fyndpro.com\/cn\/wp-json\/wp\/v2\/categories?post=1785"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.fyndpro.com\/cn\/wp-json\/wp\/v2\/tags?post=1785"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}