{"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 Data Sheet - Formating Trick<\/p><\/div><\/p>\n
Generally we follow the below steps to achieve this formatting: Same formatting mentioned above can be achieved in a SMARTER way<\/p>\n Follow the below steps: There are 3 benefits of doing so:<\/p>\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 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. Fill White Color and No Gridline<\/p><\/div>\n 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":"\n
\nStep 1. <\/strong>
\nSelect the whole sheet by clicking on the corner of the sheet
\n
\nStep 2. <\/strong>
\nNow Select “No Border” as shown in Image
\n
\nStep 3. <\/strong> Your whole sheet looks something like this
\n
\nStep 4. <\/strong> Now you fill white color in it.
\n
\nStep 5. <\/strong> Format your data area in whatever format you want to. Rest all will remain as while plain background.<\/p>\nNow you are done with your formatting !!<\/h3>\n
A SMART way of doing the above formatting<\/h3>\n
\nStep 1. <\/strong>
\nSelect the whole sheet by clicking on the corner of the sheet
\n
\nStep 2. <\/strong>
\nNow Select “No Border” as shown in Image
\n
\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<\/p>\n
Now you are done with your formatting !!<\/h3>\n
Why Second method is Better than the First One?<\/h3>\n
1. Faster<\/h3>\n
2. File Size<\/h3>\n
\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>\nTry 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":"