{"id":7930,"date":"2018-04-16T06:41:10","date_gmt":"2018-04-16T06:41:10","guid":{"rendered":"https:\/\/www.nurturetechacademy.in\/?p=7930"},"modified":"2018-04-16T06:42:37","modified_gmt":"2018-04-16T06:42:37","slug":"copy-paste-filtered-visible-data","status":"publish","type":"post","link":"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/copy-paste-filtered-visible-data\/","title":{"rendered":"How to Copy and paste filtered or visible Data only"},"content":{"rendered":"

As an excel user, you may have come across a problem where you have a big data in excel, in which few rows are hidden or the data is filtered and you wish to copy the visible or filtered data and paste it anywhere, sometimes excel behave weird and paste the complete data instead of only visible or filtered data.<\/p>\n

Let\u2019s first understand the problem and then discuss the solution in detail.<\/p>\n

The Problem:<\/strong><\/p>\n

Below is an example with some dummy data-<\/p>\n

 <\/p>\n

\"1\"<\/p>\n

Let\u2019s hide few rows (Row numbers 3 to 11 )-<\/p>\n

\"2\"<\/p>\n

How to hide rows?<\/p>\n

Select rows from 3 to 11 -> Right click on selected rows -> then click on \u201chide\u201d<\/p>\n

\"3\"<\/p>\n

Ctrl+A-> Ctrl+C (Copy)->Paste(Ctrl+V) on your desired location,<\/p>\n

Ooops! Excel pasted the whole data.<\/p>\n

\"4\"<\/p>\n

The Solutions-<\/strong><\/p>\n

Press Ctrl+A on the data having hidden rows-> Ctrl+G or press F5. This action will open \u201cGo to\u201d dialog box.<\/p>\n

-> Click on \u201cSpecial\u201d option<\/p>\n

\"5\"<\/p>\n

Choose \u201cVisible cells only\u201d -> Click OK ( this action will select only visible cells from complete data)<\/p>\n

\"6\"<\/p>\n

Now copy your data and paste wherever you want, you will get only visible cells-<\/p>\n

\"7\"<\/p>\n

\"8\"<\/p>\n

Happy Learning \ud83d\ude42<\/p>\n

For any advance excel training in corporate or for individual query, kindly contact us.<\/a><\/p>\n

 <\/p>\n

<\/div>\n

<\/path><\/svg><\/i> \"Loading\"<\/p>\n

<\/div>\n","protected":false},"excerpt":{"rendered":"

As an excel user, you may have come across a problem where you have a big data in excel, in which few rows are hidden or the data is filtered and you wish to copy the visible or filtered data <\/p>\n

<\/div>\n

<\/path><\/svg><\/i> \"Loading\"<\/p>\n

<\/div>\n","protected":false},"author":1,"featured_media":7946,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"footnotes":""},"categories":[56],"tags":[265,266,263,243,264,257,260,259,249,256,248,244,250,252,245,253,254,246,251,267,255,262,258,247,261],"class_list":["post-7930","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","tag-corporate-training-companies","tag-corporate-training-companies-in-delhi","tag-corporate-training-courses","tag-corporate-training-in-delhi","tag-corporate-training-programs","tag-excel-course-online","tag-excel-courses-online","tag-excel-online-course","tag-excel-online-training","tag-excel-training-in-delhi","tag-excel-training-online","tag-learn-microsoft-excel","tag-learn-ms-excel-online","tag-learning-excel-online","tag-learning-microsoft-excel","tag-microsoft-excel-course","tag-microsoft-excel-online-training","tag-microsoft-excel-training","tag-ms-excel-learning","tag-ms-excel-online-training","tag-ms-excel-training-in-delhi","tag-online-corporate-training","tag-online-excel-course","tag-online-excel-training","tag-online-excel-training-courses"],"_links":{"self":[{"href":"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-json\/wp\/v2\/posts\/7930","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-json\/wp\/v2\/comments?post=7930"}],"version-history":[{"count":6,"href":"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-json\/wp\/v2\/posts\/7930\/revisions"}],"predecessor-version":[{"id":7950,"href":"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-json\/wp\/v2\/posts\/7930\/revisions\/7950"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-json\/wp\/v2\/media\/7946"}],"wp:attachment":[{"href":"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-json\/wp\/v2\/media?parent=7930"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-json\/wp\/v2\/categories?post=7930"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-json\/wp\/v2\/tags?post=7930"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}