{"id":12196,"date":"2014-05-28T12:47:15","date_gmt":"2014-05-28T12:47:15","guid":{"rendered":"http:\/\/www.learnexcelmacro.com\/wp\/?p=3664"},"modified":"2014-05-28T12:47:15","modified_gmt":"2014-05-28T12:47:15","slug":"excel-trick-formatting-sheet-a-better-method","status":"publish","type":"post","link":"https:\/\/vmlogger.com\/excel\/2014\/05\/excel-trick-formatting-sheet-a-better-method\/","title":{"rendered":"Excel Trick – SMART Method to make White Background"},"content":{"rendered":"

Dear Readers,
\n 
\nIf you are a Microsoft Excel user then you must have come to a situation where you want to show you data in a particular area and rest all the area you want to make it plane white (without lines or grid). Something like depicted in below image:
\n

\"My

My Data Sheet - Formating Trick<\/p><\/div><\/p>\n

How do we do this formatting GENERALLY? <\/h3>\n

Generally we follow the below steps to achieve this formatting:
\nStep 1. <\/strong>
\nSelect the whole sheet by clicking on the corner of the sheet
\n\"How
\nStep 2. <\/strong>
\nNow Select “No Border” as shown in Image
\n\"Select
\nStep 3. <\/strong> Your whole sheet looks something like this
\n\"Grey
\nStep 4. <\/strong> Now you fill white color in it.
\n\"Fill
\nStep 5. <\/strong> Format your data area in whatever format you want to. Rest all will remain as while plain background.<\/p>\n

Now you are done with your formatting !!<\/h3>\n

Same formatting mentioned above can be achieved in a SMARTER way<\/p>\n

A SMART way of doing the above formatting<\/h3>\n

Follow the below steps:
\nStep 1. <\/strong>
\nSelect the whole sheet by clicking on the corner of the sheet
\n\"How
\nStep 2. <\/strong>
\nNow Select “No Border” as shown in Image
\n\"Select
\nStep 3. <\/strong> Format your data area in whatever format you want to.
\nStep 4. <\/strong> NOW THIS IS THE SMART STEP – Rather filling White color in rest all the cells you just select the whole sheet and “Uncheck” the “Gridlines” checkbox under “View” tab in the Ribbon:
\n\"Uncheck<\/p>\n

Now you are done with your formatting !!<\/h3>\n

Why Second method is Better than the First One?<\/h3>\n

There are 3 benefits of doing so:<\/p>\n

1. Faster<\/h3>\n

This formatting can be achieved simply after or before your “Data Area” formatting. But if you are doing it by first method then you should first do the background formatting and then your data area formatting. If missed to do so then your data area formatting will be overridden by this formatting but this is not the case with the second method. That is why I call it as “SMART” method as well.<\/p>\n

2. File Size<\/h3>\n

Size of the Workbook with the first formatting method is always more than the second method used. I have created 2 Workbook with 4 Sheets in each workbook.
\nIn all the 4 sheets I did the same formatting as above using both the methods and you can see the file size using the Method 1 and Method 2 as show below:<\/p>\n

\"Fill

Fill White Color and No Gridline<\/p><\/div>\n

Try doing the second method for such formatting. You can find it easy and lighter \ud83d\ude1b <\/h2>\n

Cheers !!! Got simply another BETTER way of doing things in Excel <\/h3>\n<\/span>","protected":false},"excerpt":{"rendered":"

Dear Readers,   If you are a Microsoft Excel user then you must have come to a situation where you want to show you data in a particular area and rest all the area you want to make it plane white (without lines or grid). Something like depicted in below image: How do we do […]<\/p>\n","protected":false},"author":45,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[1676,1682],"tags":[],"class_list":["post-12196","post","type-post","status-publish","format-standard","hentry","category-excel-tips","category-popular-articles"],"yoast_head":"\nExcel Trick - SMART Method to make White Background - Let's excel in Excel<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/vmlogger.com\/excel\/2014\/05\/excel-trick-formatting-sheet-a-better-method\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel Trick - SMART Method to make White Background\" \/>\n<meta property=\"og:description\" content=\"Dear Readers,   If you are a Microsoft Excel user then you must have come to a situation where you want to show you data in a particular area and rest all the area you want to make it plane white (without lines or grid). Something like depicted in below image: How do we do […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/vmlogger.com\/excel\/2014\/05\/excel-trick-formatting-sheet-a-better-method\/\" \/>\n<meta property=\"og:site_name\" content=\"Let's excel in Excel\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/vmlogger\" \/>\n<meta property=\"article:author\" content=\"http:\/\/www.facebook.com\/vmlogger\" \/>\n<meta property=\"article:published_time\" content=\"2014-05-28T12:47:15+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/learnexcelmacro.com\/wp\/wp-content\/uploads\/sites\/11\/2014\/05\/MyDataSheet.png\" \/>\n<meta name=\"author\" content=\"Vishwamitra Mishra\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@https:\/\/www.twitter.com\/learnexcelmacro\" \/>\n<meta name=\"twitter:site\" content=\"@learnexcelmacro\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Vishwamitra Mishra\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2014\/05\/excel-trick-formatting-sheet-a-better-method\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2014\/05\/excel-trick-formatting-sheet-a-better-method\/\"},\"author\":{\"name\":\"Vishwamitra Mishra\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"headline\":\"Excel Trick – SMART Method to make White Background\",\"datePublished\":\"2014-05-28T12:47:15+00:00\",\"dateModified\":\"2014-05-28T12:47:15+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2014\/05\/excel-trick-formatting-sheet-a-better-method\/\"},\"wordCount\":439,\"commentCount\":4,\"publisher\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"image\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2014\/05\/excel-trick-formatting-sheet-a-better-method\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2014\/05\/MyDataSheet.png\",\"articleSection\":[\"Excel Tips\",\"Popular Articles\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/vmlogger.com\/excel\/2014\/05\/excel-trick-formatting-sheet-a-better-method\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2014\/05\/excel-trick-formatting-sheet-a-better-method\/\",\"url\":\"https:\/\/vmlogger.com\/excel\/2014\/05\/excel-trick-formatting-sheet-a-better-method\/\",\"name\":\"Excel Trick - SMART Method to make White Background - Let's excel in Excel\",\"isPartOf\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2014\/05\/excel-trick-formatting-sheet-a-better-method\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2014\/05\/excel-trick-formatting-sheet-a-better-method\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2014\/05\/MyDataSheet.png\",\"datePublished\":\"2014-05-28T12:47:15+00:00\",\"dateModified\":\"2014-05-28T12:47:15+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2014\/05\/excel-trick-formatting-sheet-a-better-method\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/vmlogger.com\/excel\/2014\/05\/excel-trick-formatting-sheet-a-better-method\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2014\/05\/excel-trick-formatting-sheet-a-better-method\/#primaryimage\",\"url\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2014\/05\/MyDataSheet.png\",\"contentUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2014\/05\/MyDataSheet.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2014\/05\/excel-trick-formatting-sheet-a-better-method\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/vmlogger.com\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel Tips\",\"item\":\"https:\/\/vmlogger.com\/excel\/excel-tips\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Excel Trick – SMART Method to make White Background\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#website\",\"url\":\"https:\/\/vmlogger.com\/excel\/\",\"name\":\"Let's excel in Excel\",\"description\":\"Let's share knowledge\",\"publisher\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/vmlogger.com\/excel\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\",\"name\":\"Vishwamitra Mishra\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png\",\"contentUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png\",\"width\":528,\"height\":560,\"caption\":\"Vishwamitra Mishra\"},\"logo\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/\"},\"description\":\"My name is Vishwamitra Mishra. Friends Call me Vishwa. I hold a Bachelor\u2019s Degree in Computer Science from D.A.V.V. Indore & currently working as a Technical Lead having over 7 years of experience.\",\"sameAs\":[\"http:\/\/www.learnexcelmacro.com\",\"http:\/\/www.facebook.com\/vmlogger\",\"https:\/\/x.com\/https:\/\/www.twitter.com\/learnexcelmacro\",\"https:\/\/www.youtube.com\/c\/VMLogger\"],\"url\":\"https:\/\/vmlogger.com\/excel\/author\/vishwamitra\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Excel Trick - SMART Method to make White Background - Let's excel in Excel","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/vmlogger.com\/excel\/2014\/05\/excel-trick-formatting-sheet-a-better-method\/","og_locale":"en_US","og_type":"article","og_title":"Excel Trick - SMART Method to make White Background","og_description":"Dear Readers,   If you are a Microsoft Excel user then you must have come to a situation where you want to show you data in a particular area and rest all the area you want to make it plane white (without lines or grid). Something like depicted in below image: How do we do […]","og_url":"https:\/\/vmlogger.com\/excel\/2014\/05\/excel-trick-formatting-sheet-a-better-method\/","og_site_name":"Let's excel in Excel","article_publisher":"http:\/\/www.facebook.com\/vmlogger","article_author":"http:\/\/www.facebook.com\/vmlogger","article_published_time":"2014-05-28T12:47:15+00:00","og_image":[{"url":"http:\/\/learnexcelmacro.com\/wp\/wp-content\/uploads\/sites\/11\/2014\/05\/MyDataSheet.png"}],"author":"Vishwamitra Mishra","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/www.twitter.com\/learnexcelmacro","twitter_site":"@learnexcelmacro","twitter_misc":{"Written by":"Vishwamitra Mishra","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/vmlogger.com\/excel\/2014\/05\/excel-trick-formatting-sheet-a-better-method\/#article","isPartOf":{"@id":"https:\/\/vmlogger.com\/excel\/2014\/05\/excel-trick-formatting-sheet-a-better-method\/"},"author":{"name":"Vishwamitra Mishra","@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"headline":"Excel Trick – SMART Method to make White Background","datePublished":"2014-05-28T12:47:15+00:00","dateModified":"2014-05-28T12:47:15+00:00","mainEntityOfPage":{"@id":"https:\/\/vmlogger.com\/excel\/2014\/05\/excel-trick-formatting-sheet-a-better-method\/"},"wordCount":439,"commentCount":4,"publisher":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"image":{"@id":"https:\/\/vmlogger.com\/excel\/2014\/05\/excel-trick-formatting-sheet-a-better-method\/#primaryimage"},"thumbnailUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2014\/05\/MyDataSheet.png","articleSection":["Excel Tips","Popular Articles"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/vmlogger.com\/excel\/2014\/05\/excel-trick-formatting-sheet-a-better-method\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/vmlogger.com\/excel\/2014\/05\/excel-trick-formatting-sheet-a-better-method\/","url":"https:\/\/vmlogger.com\/excel\/2014\/05\/excel-trick-formatting-sheet-a-better-method\/","name":"Excel Trick - SMART Method to make White Background - Let's excel in Excel","isPartOf":{"@id":"https:\/\/vmlogger.com\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/vmlogger.com\/excel\/2014\/05\/excel-trick-formatting-sheet-a-better-method\/#primaryimage"},"image":{"@id":"https:\/\/vmlogger.com\/excel\/2014\/05\/excel-trick-formatting-sheet-a-better-method\/#primaryimage"},"thumbnailUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2014\/05\/MyDataSheet.png","datePublished":"2014-05-28T12:47:15+00:00","dateModified":"2014-05-28T12:47:15+00:00","breadcrumb":{"@id":"https:\/\/vmlogger.com\/excel\/2014\/05\/excel-trick-formatting-sheet-a-better-method\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/vmlogger.com\/excel\/2014\/05\/excel-trick-formatting-sheet-a-better-method\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/vmlogger.com\/excel\/2014\/05\/excel-trick-formatting-sheet-a-better-method\/#primaryimage","url":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2014\/05\/MyDataSheet.png","contentUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2014\/05\/MyDataSheet.png"},{"@type":"BreadcrumbList","@id":"https:\/\/vmlogger.com\/excel\/2014\/05\/excel-trick-formatting-sheet-a-better-method\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/vmlogger.com\/excel\/"},{"@type":"ListItem","position":2,"name":"Excel Tips","item":"https:\/\/vmlogger.com\/excel\/excel-tips\/"},{"@type":"ListItem","position":3,"name":"Excel Trick – SMART Method to make White Background"}]},{"@type":"WebSite","@id":"https:\/\/vmlogger.com\/excel\/#website","url":"https:\/\/vmlogger.com\/excel\/","name":"Let's excel in Excel","description":"Let's share knowledge","publisher":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/vmlogger.com\/excel\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5","name":"Vishwamitra Mishra","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/","url":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png","contentUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png","width":528,"height":560,"caption":"Vishwamitra Mishra"},"logo":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/"},"description":"My name is Vishwamitra Mishra. Friends Call me Vishwa. I hold a Bachelor\u2019s Degree in Computer Science from D.A.V.V. Indore & currently working as a Technical Lead having over 7 years of experience.","sameAs":["http:\/\/www.learnexcelmacro.com","http:\/\/www.facebook.com\/vmlogger","https:\/\/x.com\/https:\/\/www.twitter.com\/learnexcelmacro","https:\/\/www.youtube.com\/c\/VMLogger"],"url":"https:\/\/vmlogger.com\/excel\/author\/vishwamitra\/"}]}},"_links":{"self":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts\/12196"}],"collection":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/users\/45"}],"replies":[{"embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/comments?post=12196"}],"version-history":[{"count":0,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts\/12196\/revisions"}],"wp:attachment":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/media?parent=12196"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/categories?post=12196"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/tags?post=12196"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}