{"id":870,"date":"2017-10-18T15:55:46","date_gmt":"2017-10-18T07:55:46","guid":{"rendered":"http:\/\/owa.sodexo-cn.com\/blog\/?p=870"},"modified":"2017-10-19T13:17:16","modified_gmt":"2017-10-19T05:17:16","slug":"excel-three-strokes-let-you-quickly-copy-visible-cells","status":"publish","type":"post","link":"https:\/\/owa.sodexo-cn.com\/blog\/?p=870","title":{"rendered":"[Excel] Three skills let you quickly copy # visible cells"},"content":{"rendered":"

 <\/p>\n

Copy, paste, is the most two common commands in Excel. However, only copy the visible cells, are you sure you will?<\/p>\n

Problem\uff1f
\n<\/strong><\/span><\/p>\n

For example, in the case of B hiding, if you choose A1: D4 to copy and paste, Excel defaults to copy the hidden 1 columns together. What should we do?<\/p>\n

\"\"<\/p>\n

Method One\uff1aUse go special<\/strong><\/span><\/p>\n


\n<\/strong><\/span><\/p>\n

\"\"
\n\u9009\u4e2d\u5355\u5143\u683c\u4ee5\u540e\uff0c\u6309\u4e0bF5\uff0c\u7136\u540e\u5728\u5b9a\u4f4d\u6761\u4ef6\u4e2d\u9009\u62e9”\u53ef\u89c1\u5355\u5143\u683c”,<\/span>\u590d\u5236\u7136\u540e\u7c98\u8d34\u3002<\/p>\n


\n<\/span><\/p>\n

Method Two\uff1aUse shortcut keys<\/strong><\/span><\/p>\n


\n<\/strong><\/span><\/p>\n

\"\"
\n<\/span><\/p>\n

\n
\n
\n
\n
\n
\n
\n
When you select a cell, press ALT +;\u00a0 \u00a0key to make a selection of visible cells, copy and paste.<\/span><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n


\n<\/span><\/p>\n

Method Three\uff1aAdd Command\u00a0<\/strong><\/span><\/p>\n

<\/div>\n

\"\"
\n<\/strong><\/span><\/p>\n

\n
\n
\n
\n
\n
\n
\n
\n
\n

Right-click on the toolbar and select the customize the Ribbon.<\/p>\n<\/div>\n<\/article>\n<\/section>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n

\"\"
\n<\/span><\/p>\n

\n
\n
\n
\n
\n
\n
\n
In Excel options, add a feature command called Select visible cells.<\/span><\/div>\n
Note, however, that as a non-default display command, you must first create a custom group (as shown in the figure above) and then add the feature command to select visible cells.<\/span><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n

\"\"<\/span><\/p>\n

\n
\n
\n
\n
\n
\n
\n
After the setup is complete, the Excel Feature tab will have one more function command.<\/span><\/div>\n
Later, when you select a cell, you can select only the visible cells by clicking the feature.<\/span><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

  Copy, paste, is the most two common commands in … \u9605\u8bfb\u66f4\u591a<\/a><\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-870","post","type-post","status-publish","format-standard","hentry","category-tips"],"views":2606,"_links":{"self":[{"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/870","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=870"}],"version-history":[{"count":6,"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/870\/revisions"}],"predecessor-version":[{"id":880,"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/870\/revisions\/880"}],"wp:attachment":[{"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=870"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=870"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=870"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}