{"id":5407,"date":"2017-02-15T23:52:34","date_gmt":"2017-02-15T22:52:34","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=5407"},"modified":"2023-11-30T21:16:59","modified_gmt":"2023-11-30T20:16:59","slug":"quick-reports-using-excel-custom-views","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/quick-reports-using-excel-custom-views\/","title":{"rendered":"Quick Reports Using Excel Custom Views"},"content":{"rendered":"<p>Whenever I wanted to print my Excel worksheet for a report, I usually had to trim down the data and do changes like hiding the columns so it could fit into one page.<\/p>\n<p>Other common scenarios would be, hiding employee\u00a0salaries or\u00a0filtering out specific customer data.<\/p>\n<p>It is cumbersome because after printing it out I had to undo the layout changes one by one!<\/p>\n<p>Thankfully Excel has\u00a0<strong>Custom Views<\/strong> that lets you revert and save your layout changes in a single click!<\/p>\n<p>&nbsp;<\/p>\n<div class=\"after-post-box\">\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/YoqnHPqvvJQ?rel=0 \" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><a href=\"https:\/\/www.youtube.com\/c\/MyExcelOnlinecomtutorials?sub_confirmation=1\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"alignmiddle wp-image-111468 size-full\" style=\"vertical-align: middle;\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/04\/1.yt_.png\" alt=\"\" title=\"\"><\/a><\/p>\n<p class=\"line-two\"><a class=\"IRPP_minimalist icon-download button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Custom-Views.xlsx\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Custom-Views.xlsx\" data-leadbox-id=\"147284833f72a2:12f08263ab46dc\"><span class=\"ctaText px-3 text-capitalize\"> download excel workbook <i class=\"fa fa-download\"><\/i><\/span><span class=\"postTitle px-3\">Custom-Views.xlsx<\/span><\/a><\/p>\n<\/div>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 1:<\/strong> <\/span>You need to set a default view first.<\/p>\n<p>Once you have the layout that you use most of the time, go to <strong><em>View &gt; Custom Views<\/em>:<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Custom-Views-01.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Quick Reports Using Excel Custom Views\"  class=\"alignnone size-full wp-image-5413\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Custom-Views-01.png\" alt=\"Quick Reports Using Excel Custom Views\" width=\"548\" height=\"127\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Custom-Views-01.png 548w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Custom-Views-01-300x70.png 300w\" sizes=\"(max-width: 548px) 100vw, 548px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 2:<\/strong> <\/span>Click\u00a0<strong>Add\u00a0<\/strong>to create a new Custom View.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Custom-Views-02.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Quick Reports Using Excel Custom Views\"  class=\"alignnone size-full wp-image-5414\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Custom-Views-02.png\" alt=\"Quick Reports Using Excel Custom Views\" width=\"345\" height=\"182\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Custom-Views-02.png 345w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Custom-Views-02-300x158.png 300w\" sizes=\"(max-width: 345px) 100vw, 345px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>Type in\u00a0<strong>Normal View\u00a0<\/strong>and click\u00a0<strong>OK.<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Custom-Views-03.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Quick Reports Using Excel Custom Views\"  class=\"alignnone size-full wp-image-5415\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Custom-Views-03.png\" alt=\"Quick Reports Using Excel Custom Views\" width=\"307\" height=\"171\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Custom-Views-03.png 307w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Custom-Views-03-300x167.png 300w\" sizes=\"(max-width: 307px) 100vw, 307px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 3:<\/strong> <\/span>In preparation for the second\u00a0<strong>Custom View<\/strong>, select the first 4 columns, right click and select\u00a0<strong>Hide<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Custom-Views-04.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Quick Reports Using Excel Custom Views\"  class=\"alignnone size-full wp-image-5416\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Custom-Views-04.png\" alt=\"Quick Reports Using Excel Custom Views\" width=\"750\" height=\"328\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Custom-Views-04.png 750w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Custom-Views-04-300x131.png 300w\" sizes=\"(max-width: 750px) 100vw, 750px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 4:<\/strong> <\/span>Go to <strong><em>View&gt; Custom Views<\/em>:<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Custom-Views-05.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Quick Reports Using Excel Custom Views\"  class=\"alignnone size-full wp-image-5417\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Custom-Views-05.png\" alt=\"Quick Reports Using Excel Custom Views\" width=\"536\" height=\"126\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Custom-Views-05.png 536w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Custom-Views-05-300x71.png 300w\" sizes=\"(max-width: 536px) 100vw, 536px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 5:<\/strong> <\/span>Click\u00a0<strong>Add\u00a0<\/strong>to create a new Custom View.<\/p>\n<p>Type in\u00a0<strong>Hidden Columns\u00a0<\/strong>and click\u00a0<strong>OK.<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Custom-Views-06.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Quick Reports Using Excel Custom Views\"  class=\"alignnone size-full wp-image-5418\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Custom-Views-06.png\" alt=\"Quick Reports Using Excel Custom Views\" width=\"307\" height=\"171\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Custom-Views-06.png 307w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Custom-Views-06-300x167.png 300w\" sizes=\"(max-width: 307px) 100vw, 307px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 6:<\/strong> <\/span>Let us now try out our Custom Views in action.<\/p>\n<p>Go to <strong><em>View &gt; Custom Views.<\/em><\/strong><\/p>\n<p>Select\u00a0<strong>Normal View<\/strong> and click\u00a0<strong>Show.<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Custom-Views-07.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Quick Reports Using Excel Custom Views\"  class=\"alignnone size-full wp-image-5419\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Custom-Views-07.png\" alt=\"Quick Reports Using Excel Custom Views\" width=\"345\" height=\"182\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Custom-Views-07.png 345w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Custom-Views-07-300x158.png 300w\" sizes=\"(max-width: 345px) 100vw, 345px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>You can see all of the columns displayed.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Custom-Views-08.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Quick Reports Using Excel Custom Views\"  class=\"alignnone size-full wp-image-5420\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Custom-Views-08.png\" alt=\"Quick Reports Using Excel Custom Views\" width=\"1036\" height=\"136\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Custom-Views-08.png 1036w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Custom-Views-08-300x39.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Custom-Views-08-1024x134.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Custom-Views-08-768x101.png 768w\" sizes=\"(max-width: 1036px) 100vw, 1036px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 7:<\/strong> <\/span>Now let us try the second custom view.<\/p>\n<p>Go to <strong><em>View &gt; Custom Views.<\/em><\/strong><\/p>\n<p>Select\u00a0<strong>Hidden Columns<\/strong>\u00a0and click\u00a0<strong>Show.<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Custom-Views-09.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Quick Reports Using Excel Custom Views\"  class=\"alignnone size-full wp-image-5421\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Custom-Views-09.png\" alt=\"Quick Reports Using Excel Custom Views\" width=\"345\" height=\"182\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Custom-Views-09.png 345w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Custom-Views-09-300x158.png 300w\" sizes=\"(max-width: 345px) 100vw, 345px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>The columns are hidden right away in a click! \u00a0Imagine if you have multiple layout customizations, it is now doable and saved in a Custom View!<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Custom-Views-10.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Quick Reports Using Excel Custom Views\"  class=\"alignnone size-full wp-image-5422\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Custom-Views-10.png\" alt=\"Quick Reports Using Excel Custom Views\" width=\"869\" height=\"217\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Custom-Views-10.png 869w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Custom-Views-10-300x75.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Custom-Views-10-768x192.png 768w\" sizes=\"(max-width: 869px) 100vw, 869px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/100-21.html\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" title=\"Add Hyphens To Serial Numbers Using Excel Flash Fill\"  class=\"alignnone wp-image-4472 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/09\/OzTraining_728x90.jpg\" alt=\"Add Hyphens To Serial Numbers Using Excel Flash Fill\" width=\"728\" height=\"90\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/09\/OzTraining_728x90.jpg 728w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/09\/OzTraining_728x90-300x37.jpg 300w\" sizes=\"(max-width: 728px) 100vw, 728px\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Whenever I wanted to print my Excel worksheet for a report, I usually had to trim down the data and do changes like hiding the columns so it could fit into one page. Other common scenarios would be, hiding employee\u00a0salaries or\u00a0filtering out specific customer data. It is cumbersome because after printing it out I had [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":17712,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[10,7],"tags":[211],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/5407"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=5407"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/5407\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/17712"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=5407"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=5407"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=5407"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}