{"appState":{"pageLoadApiCallsStatus":true},"articleState":{"article":{"headers":{"creationTime":"2016-03-26T07:16:03+00:00","modifiedTime":"2016-03-26T07:16:03+00:00","timestamp":"2022-09-14T17:48:24+00:00"},"data":{"breadcrumbs":[{"name":"Technology","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33512"},"slug":"technology","categoryId":33512},{"name":"Software","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33618"},"slug":"software","categoryId":33618},{"name":"Microsoft Products","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33642"},"slug":"microsoft-products","categoryId":33642},{"name":"Excel","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33644"},"slug":"excel","categoryId":33644}],"title":"How to Format Tables with the Quick Analysis Tool in Excel 2016","strippedTitle":"how to format tables with the quick analysis tool in excel 2016","slug":"how-to-format-tables-with-the-quick-analysis-tool-in-excel-2016","canonicalUrl":"","seo":{"metaDescription":"You can use Excel 2016's handy Quick Analysis tool to quickly format your data as a new table. Simply select all the cells in the table, including the cells in ","noIndex":0,"noFollow":0},"content":"<p>You can use Excel 2016's handy Quick Analysis tool to quickly format your data as a new table. Simply select all the cells in the table, including the cells in the first row with the column headings. As soon as you do, the Quick Analysis tool appears in the lower-right corner of the cell selection (the outlined button with the lightning bolt striking the selected data icon).</p>\n<p>When you click this tool, the Quick Analysis options palette appears with five tabs (Formatting, Charts, Totals, Tables, and Sparklines).</p>\n<p>Click the Tables tab in the Quick Analysis tool's option palette to display its Table and Pivot Table buttons. When you highlight the Table button on the Tables tab, Excel's Live Preview shows you how the selected data will appear formatted as a table. (See the following figure.) To apply this previewed formatting and format the selected cell range as a table, you have only to click the Table button.</p>\n<div class=\"imageBlock\" style=\"width:533px;\"><img src=\"https://www.dummies.com/wp-content/uploads/497453.image0.jpg\" height=\"400\" alt=\"Previewing the selected data formatted as a table with the Quick Analysis tool.\" width=\"533\"/><div class=\"imageCaption\">Previewing the selected data formatted as a table with the Quick Analysis tool.</div></div>\n<p>As soon as you click the Table button, the Quick Analysis options palette disappears and the Design contextual table appears on the Ribbon. You can then use its Table Styles drop-down gallery to select a different formatting style for your table. (The Tables button on the Quick Analysis tool's Tables tab offers only the one blue medium style shown in the Live Preview.)</p>","description":"<p>You can use Excel 2016's handy Quick Analysis tool to quickly format your data as a new table. Simply select all the cells in the table, including the cells in the first row with the column headings. As soon as you do, the Quick Analysis tool appears in the lower-right corner of the cell selection (the outlined button with the lightning bolt striking the selected data icon).</p>\n<p>When you click this tool, the Quick Analysis options palette appears with five tabs (Formatting, Charts, Totals, Tables, and Sparklines).</p>\n<p>Click the Tables tab in the Quick Analysis tool's option palette to display its Table and Pivot Table buttons. When you highlight the Table button on the Tables tab, Excel's Live Preview shows you how the selected data will appear formatted as a table. (See the following figure.) To apply this previewed formatting and format the selected cell range as a table, you have only to click the Table button.</p>\n<div class=\"imageBlock\" style=\"width:533px;\"><img src=\"https://www.dummies.com/wp-content/uploads/497453.image0.jpg\" height=\"400\" alt=\"Previewing the selected data formatted as a table with the Quick Analysis tool.\" width=\"533\"/><div class=\"imageCaption\">Previewing the selected data formatted as a table with the Quick Analysis tool.</div></div>\n<p>As soon as you click the Table button, the Quick Analysis options palette disappears and the Design contextual table appears on the Ribbon. You can then use its Table Styles drop-down gallery to select a different formatting style for your table. (The Tables button on the Quick Analysis tool's Tables tab offers only the one blue medium style shown in the Live Preview.)</p>","blurb":"","authors":[{"authorId":9027,"name":"Greg Harvey","slug":"greg-harvey","description":" <b>Greg Harvey</b> has authored tons of computer books, the most recent being <i>Excel 2007 For Dummies, Windows Vista For Dummies Quick Reference,</i> and <i>Excel Workbook For Dummies.</i> He started out training business users on how to use IBM personal computers and their attendant computer software in the rough-and-tumble days of DOS, WordStar, and Lotus 1-2-3 in the mid-80s of the last century. After working for a number of independent training firms, he went on to teaching semester-long courses in spreadsheet and database management software at Golden Gate University in San Francisco.<br /> His love of teaching has translated into an equal love of writing. <i>For Dummies</i> books are, of course, his all-time favorites to write because they enable him to write to his favorite audience, the beginner. They also enable him to use humor (a key element to success in the training room) and, most delightful of all, to express an opinion or two about the subject matter at hand.","hasArticle":false,"_links":{"self":"https://dummies-api.dummies.com/v2/authors/9027"}}],"primaryCategoryTaxonomy":{"categoryId":33644,"title":"Excel","slug":"excel","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33644"}},"secondaryCategoryTaxonomy":{"categoryId":0,"title":null,"slug":null,"_links":null},"tertiaryCategoryTaxonomy":{"categoryId":0,"title":null,"slug":null,"_links":null},"trendingArticles":null,"inThisArticle":[],"relatedArticles":{"fromBook":[{"articleId":140206,"title":"Sharing Excel 2016 Workbooks Saved on Your OneDrive","slug":"sharing-excel-2016-workbooks-saved-on-your-onedrive","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/140206"}},{"articleId":140205,"title":"Sorting on Multiple Fields in an Excel 2016 Data List","slug":"sorting-on-multiple-fields-in-an-excel-2016-data-list","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/140205"}},{"articleId":140185,"title":"Adding a Description to a User-Defined Function in Excel 2016","slug":"adding-a-description-to-a-user-defined-function-in-excel-2016","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/140185"}},{"articleId":140162,"title":"Inserting Online Images into Your Excel 2016 Worksheets","slug":"inserting-online-images-into-your-excel-2016-worksheets","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/140162"}},{"articleId":139543,"title":"How to Add Sparkline Graphics to a Worksheet in Excel 2016","slug":"how-to-add-sparkline-graphics-to-a-worksheet-in-excel-2016","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/139543"}}],"fromCategory":[{"articleId":288828,"title":"Excel 2021 All-in-One For Dummies Cheat Sheet","slug":"excel-2021-all-in-one-for-dummies-cheat-sheet","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/288828"}},{"articleId":265521,"title":"How to Use the XLOOKUP Function in Excel 2016","slug":"how-to-use-the-xlookup-function-in-excel-2016","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/265521"}},{"articleId":263475,"title":"Notes and File Sharing features in Excel 2016 Update","slug":"notes-and-coauthoring-features-in-excel-2016-update","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/263475"}},{"articleId":263466,"title":"New Chart & Graphics features on Excel 2016 update","slug":"new-chart-graphics-features-on-excel-2016-update","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/263466"}},{"articleId":263453,"title":"New Formulas and Functions in Excel 2016","slug":"how-to-use-new-formula-and-functions-in-excel-2016-update","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/263453"}}]},"hasRelatedBookFromSearch":false,"relatedBook":{"bookId":281706,"slug":"excel-2016-all-in-one-for-dummies","isbn":"9781119077152","categoryList":["technology","software","microsoft-products","excel"],"amazon":{"default":"https://www.amazon.com/gp/product/111907715X/ref=as_li_tl?ie=UTF8&tag=wiley01-20","ca":"https://www.amazon.ca/gp/product/111907715X/ref=as_li_tl?ie=UTF8&tag=wiley01-20","indigo_ca":"http://www.tkqlhce.com/click-9208661-13710633?url=https://www.chapters.indigo.ca/en-ca/books/product/111907715X-item.html&cjsku=978111945484","gb":"https://www.amazon.co.uk/gp/product/111907715X/ref=as_li_tl?ie=UTF8&tag=wiley01-20","de":"https://www.amazon.de/gp/product/111907715X/ref=as_li_tl?ie=UTF8&tag=wiley01-20"},"image":{"src":"https://www.dummies.com/wp-content/uploads/excel-2016-all-in-one-for-dummies-cover-9781119077152-203x255.jpg","width":203,"height":255},"title":"Excel 2016 All-in-One For Dummies","testBankPinActivationLink":"","bookOutOfPrint":false,"authorsInfo":"<p><b data-author-id=\"9027\">Greg Harvey, PhD,</b> is the president of Mind Over Media, LLC., and a bestselling author of books on Excel, including all editions of <i>Excel For Dummies</i> and <i>Excel Workbook For Dummies</i>. He began teaching business users about computers back in the 1980s, and has been a dedicated educator ever since. </p>","authors":[{"authorId":9027,"name":"Greg Harvey","slug":"greg-harvey","description":" <b>Greg Harvey</b> has authored tons of computer books, the most recent being <i>Excel 2007 For Dummies, Windows Vista For Dummies Quick Reference,</i> and <i>Excel Workbook For Dummies.</i> He started out training business users on how to use IBM personal computers and their attendant computer software in the rough-and-tumble days of DOS, WordStar, and Lotus 1-2-3 in the mid-80s of the last century. After working for a number of independent training firms, he went on to teaching semester-long courses in spreadsheet and database management software at Golden Gate University in San Francisco.<br /> His love of teaching has translated into an equal love of writing. <i>For Dummies</i> books are, of course, his all-time favorites to write because they enable him to write to his favorite audience, the beginner. They also enable him to use humor (a key element to success in the training room) and, most delightful of all, to express an opinion or two about the subject matter at hand.","hasArticle":false,"_links":{"self":"https://dummies-api.dummies.com/v2/authors/9027"}}],"_links":{"self":"https://dummies-api.dummies.com/v2/books/"}},"collections":[],"articleAds":{"footerAd":"<div class=\"du-ad-region row\" id=\"article_page_adhesion_ad\"><div class=\"du-ad-unit col-md-12\" data-slot-id=\"article_page_adhesion_ad\" data-refreshed=\"false\" \r\n data-target = \"[{"key":"cat","values":["technology","software","microsoft-products","excel"]},{"key":"isbn","values":["9781119077152"]}]\" id=\"du-slot-632213e8498b6\"></div></div>","rightAd":"<div class=\"du-ad-region row\" id=\"article_page_right_ad\"><div class=\"du-ad-unit col-md-12\" data-slot-id=\"article_page_right_ad\" data-refreshed=\"false\" \r\n data-target = \"[{"key":"cat","values":["technology","software","microsoft-products","excel"]},{"key":"isbn","values":["9781119077152"]}]\" id=\"du-slot-632213e849e8d\"></div></div>"},"articleType":{"articleType":"Articles","articleList":null,"content":null,"videoInfo":{"videoId":null,"name":null,"accountId":null,"playerId":null,"thumbnailUrl":null,"description":null,"uploadDate":null}},"sponsorship":{"sponsorshipPage":false,"backgroundImage":{"src":null,"width":0,"height":0},"brandingLine":"","brandingLink":"","brandingLogo":{"src":null,"width":0,"height":0},"sponsorAd":"","sponsorEbookTitle":"","sponsorEbookLink":"","sponsorEbookImage":{"src":null,"width":0,"height":0}},"primaryLearningPath":"Advance","lifeExpectancy":null,"lifeExpectancySetFrom":null,"dummiesForKids":"no","sponsoredContent":"no","adInfo":"","adPairKey":[]},"status":"publish","visibility":"public","articleId":139549},"articleLoadedStatus":"success"},"listState":{"list":{},"objectTitle":"","status":"initial","pageType":null,"objectId":null,"page":1,"sortField":"time","sortOrder":1,"categoriesIds":[],"articleTypes":[],"filterData":{},"filterDataLoadedStatus":"initial","pageSize":10},"adsState":{"pageScripts":{"headers":{"timestamp":"2024-03-04T05:50:01+00:00"},"adsId":0,"data":{"scripts":[{"pages":["all"],"location":"header","script":"\r\n<script src=\"https://cdn.optimizely.com/js/10563184655.js\"></script>","enabled":false},{"pages":["all"],"location":"header","script":"\r\n<script>var _comscore = _comscore || [];_comscore.push({ c1: \"2\", c2: \"15097263\" });(function() {var s = document.createElement(\"script\"), el = document.getElementsByTagName(\"script\")[0]; s.async = true;s.src = (document.location.protocol == \"https:\" ? \"https://sb\" : \"http://b\") + \".scorecardresearch.com/beacon.js\";el.parentNode.insertBefore(s, el);})();</script><noscript><img src=\"https://sb.scorecardresearch.com/p?c1=2&c2=15097263&cv=2.0&cj=1\" /></noscript>\r\n","enabled":true},{"pages":["all"],"location":"footer","script":"\r\n<script type='text/javascript'>\r\n(function(){var g=function(e,h,f,g){\r\nthis.get=function(a){for(var a=a+\"=\",c=document.cookie.split(\";\"),b=0,e=c.length;b<e;b++){for(var d=c[b];\" \"==d.charAt(0);)d=d.substring(1,d.length);if(0==d.indexOf(a))return d.substring(a.length,d.length)}return null};\r\nthis.set=function(a,c){var b=\"\",b=new Date;b.setTime(b.getTime()+6048E5);b=\"; expires=\"+b.toGMTString();document.cookie=a+\"=\"+c+b+\"; path=/; \"};\r\nthis.check=function(){var a=this.get(f);if(a)a=a.split(\":\");else if(100!=e)\"v\"==h&&(e=Math.random()>=e/100?0:100),a=[h,e,0],this.set(f,a.join(\":\"));else return!0;var c=a[1];if(100==c)return!0;switch(a[0]){case \"v\":return!1;case \"r\":return c=a[2]%Math.floor(100/c),a[2]++,this.set(f,a.join(\":\")),!c}return!0};\r\nthis.go=function(){if(this.check()){var a=document.createElement(\"script\");a.type=\"text/javascript\";a.src=g;document.body&&document.body.appendChild(a)}};\r\nthis.start=function(){var t=this;\"complete\"!==document.readyState?window.addEventListener?window.addEventListener(\"load\",function(){t.go()},!1):window.attachEvent&&window.attachEvent(\"onload\",function(){t.go()}):t.go()};};\r\ntry{(new g(100,\"r\",\"QSI_S_ZN_5o5yqpvMVjgDOuN\",\"https://zn5o5yqpvmvjgdoun-wiley.siteintercept.qualtrics.com/SIE/?Q_ZID=ZN_5o5yqpvMVjgDOuN\")).start()}catch(i){}})();\r\n</script><div id='ZN_5o5yqpvMVjgDOuN'></div>\r\n","enabled":false},{"pages":["all"],"location":"header","script":"\r\n<script>\r\n (function(h,o,t,j,a,r){\r\n h.hj=h.hj||function(){(h.hj.q=h.hj.q||[]).push(arguments)};\r\n h._hjSettings={hjid:257151,hjsv:6};\r\n a=o.getElementsByTagName('head')[0];\r\n r=o.createElement('script');r.async=1;\r\n r.src=t+h._hjSettings.hjid+j+h._hjSettings.hjsv;\r\n a.appendChild(r);\r\n })(window,document,'https://static.hotjar.com/c/hotjar-','.js?sv=');\r\n</script>","enabled":false},{"pages":["article"],"location":"header","script":" <script src=\"//get.s-onetag.com/bffe21a1-6bb8-4928-9449-7beadb468dae/tag.min.js\" async defer></script>","enabled":true},{"pages":["homepage"],"location":"header","script":"<meta name=\"facebook-domain-verification\" content=\"irk8y0irxf718trg3uwwuexg6xpva0\" />","enabled":true},{"pages":["homepage","article","category","search"],"location":"footer","script":"\r\n<noscript>\r\n<img height=\"1\" width=\"1\" src=\"https://www.facebook.com/tr?id=256338321977984&ev=PageView&noscript=1\"/>\r\n</noscript>\r\n","enabled":true}]}},"pageScriptsLoadedStatus":"success"},"navigationState":{"navigationCollections":[{"collectionId":287568,"title":"BYOB (Be Your Own Boss)","hasSubCategories":false,"url":"/collection/for-the-entry-level-entrepreneur-287568"},{"collectionId":293237,"title":"Be a Rad Dad","hasSubCategories":false,"url":"/collection/be-the-best-dad-293237"},{"collectionId":295890,"title":"Career Shifting","hasSubCategories":false,"url":"/collection/career-shifting-295890"},{"collectionId":294090,"title":"Contemplating the Cosmos","hasSubCategories":false,"url":"/collection/theres-something-about-space-294090"},{"collectionId":287563,"title":"For Those Seeking Peace of Mind","hasSubCategories":false,"url":"/collection/for-those-seeking-peace-of-mind-287563"},{"collectionId":287570,"title":"For the Aspiring Aficionado","hasSubCategories":false,"url":"/collection/for-the-bougielicious-287570"},{"collectionId":291903,"title":"For the Budding Cannabis Enthusiast","hasSubCategories":false,"url":"/collection/for-the-budding-cannabis-enthusiast-291903"},{"collectionId":299891,"title":"For the College Bound","hasSubCategories":false,"url":"/collection/for-the-college-bound-299891"},{"collectionId":291934,"title":"For the Exam-Season Crammer","hasSubCategories":false,"url":"/collection/for-the-exam-season-crammer-291934"},{"collectionId":301547,"title":"For the Game Day Prepper","hasSubCategories":false,"url":"/collection/big-game-day-prep-made-easy-301547"}],"navigationCollectionsLoadedStatus":"success","navigationCategories":{"books":{"0":{"data":[{"categoryId":33512,"title":"Technology","hasSubCategories":true,"url":"/category/books/technology-33512"},{"categoryId":33662,"title":"Academics & The Arts","hasSubCategories":true,"url":"/category/books/academics-the-arts-33662"},{"categoryId":33809,"title":"Home, Auto, & Hobbies","hasSubCategories":true,"url":"/category/books/home-auto-hobbies-33809"},{"categoryId":34038,"title":"Body, Mind, & Spirit","hasSubCategories":true,"url":"/category/books/body-mind-spirit-34038"},{"categoryId":34224,"title":"Business, Careers, & Money","hasSubCategories":true,"url":"/category/books/business-careers-money-34224"}],"breadcrumbs":[],"categoryTitle":"Level 0 Category","mainCategoryUrl":"/category/books/level-0-category-0"}},"articles":{"0":{"data":[{"categoryId":33512,"title":"Technology","hasSubCategories":true,"url":"/category/articles/technology-33512"},{"categoryId":33662,"title":"Academics & The Arts","hasSubCategories":true,"url":"/category/articles/academics-the-arts-33662"},{"categoryId":33809,"title":"Home, Auto, & Hobbies","hasSubCategories":true,"url":"/category/articles/home-auto-hobbies-33809"},{"categoryId":34038,"title":"Body, Mind, & Spirit","hasSubCategories":true,"url":"/category/articles/body-mind-spirit-34038"},{"categoryId":34224,"title":"Business, Careers, & Money","hasSubCategories":true,"url":"/category/articles/business-careers-money-34224"}],"breadcrumbs":[],"categoryTitle":"Level 0 Category","mainCategoryUrl":"/category/articles/level-0-category-0"}}},"navigationCategoriesLoadedStatus":"success"},"searchState":{"searchList":[],"searchStatus":"initial","relatedArticlesList":[],"relatedArticlesStatus":"initial"},"routeState":{"name":"Article4","path":"/article/technology/software/microsoft-products/excel/how-to-format-tables-with-the-quick-analysis-tool-in-excel-2016-139549/","hash":"","query":{},"params":{"category1":"technology","category2":"software","category3":"microsoft-products","category4":"excel","article":"how-to-format-tables-with-the-quick-analysis-tool-in-excel-2016-139549"},"fullPath":"/article/technology/software/microsoft-products/excel/how-to-format-tables-with-the-quick-analysis-tool-in-excel-2016-139549/","meta":{"routeType":"article","breadcrumbInfo":{"suffix":"Articles","baseRoute":"/category/articles"},"prerenderWithAsyncData":true},"from":{"name":null,"path":"/","hash":"","query":{},"params":{},"fullPath":"/","meta":{}}},"dropsState":{"submitEmailResponse":false,"status":"initial"},"profileState":{"auth":{},"userOptions":{},"status":"success"}}

How to Format Tables with the Quick Analysis Tool in Excel 2016

By: Greg Harvey and

Updated: 03-26-2016

From The Book: Excel 2016 All-in-One For Dummies

Excel 2016 All-in-One For Dummies

Book image

Explore Book Buy On Amazon

You can use Excel 2016's handy Quick Analysis tool to quickly format your data as a new table. Simply select all the cells in the table, including the cells in the first row with the column headings. As soon as you do, the Quick Analysis tool appears in the lower-right corner of the cell selection (the outlined button with the lightning bolt striking the selected data icon).

When you click this tool, the Quick Analysis options palette appears with five tabs (Formatting, Charts, Totals, Tables, and Sparklines).

Click the Tables tab in the Quick Analysis tool's option palette to display its Table and Pivot Table buttons. When you highlight the Table button on the Tables tab, Excel's Live Preview shows you how the selected data will appear formatted as a table. (See the following figure.) To apply this previewed formatting and format the selected cell range as a table, you have only to click the Table button.

Previewing the selected data formatted as a table with the Quick Analysis tool.

Previewing the selected data formatted as a table with the Quick Analysis tool.

As soon as you click the Table button, the Quick Analysis options palette disappears and the Design contextual table appears on the Ribbon. You can then use its Table Styles drop-down gallery to select a different formatting style for your table. (The Tables button on the Quick Analysis tool's Tables tab offers only the one blue medium style shown in the Live Preview.)

About This Article

This article is from the book:

Excel 2016 All-in-One For Dummies ,

About the book author:

Greg Harvey, PhD, is the president of Mind Over Media, LLC., and a bestselling author of books on Excel, including all editions of Excel For Dummies and Excel Workbook For Dummies. He began teaching business users about computers back in the 1980s, and has been a dedicated educator ever since.

This article can be found in the category:

Excel ,