How to clear multiple cells in Excel

{"appState":{"pageLoadApiCallsStatus":true},"articleState":{"article":{"headers":{"creationTime":"2016-03-26T21:16:30+00:00","modifiedTime":"2016-03-26T21:16:30+00:00","timestamp":"2022-06-22T19:28:00+00:00"},"data":{"breadcrumbs":[{"name":"Technology","_links":{"self":"//dummies-api.dummies.com/v2/categories/33512"},"slug":"technology","categoryId":33512},{"name":"Software","_links":{"self":"//dummies-api.dummies.com/v2/categories/33618"},"slug":"software","categoryId":33618},{"name":"Microsoft Products","_links":{"self":"//dummies-api.dummies.com/v2/categories/33642"},"slug":"microsoft-products","categoryId":33642},{"name":"Excel","_links":{"self":"//dummies-api.dummies.com/v2/categories/33644"},"slug":"excel","categoryId":33644}],"title":"How to Delete Cells and Data in Excel 2010","strippedTitle":"how to delete cells and data in excel 2010","slug":"how-to-delete-cells-and-data-in-excel-2010","canonicalUrl":"","seo":{"metaDescription":"In Excel 2010, when you need to delete data, remove formatting in a cell selection, or remove entire cells, rows, or columns, you have many options. Excel can p","noIndex":0,"noFollow":0},"content":"<p>In Excel 2010, when you need to delete data, remove formatting in a cell selection, or remove entire cells, rows, or columns, you have many options. Excel can perform two kinds of cell deletions in a worksheet: clearing cell data and deleting the cell.</p>\n<h2 id=\"tab1\" >Clearing cell contents</h2>\n<p>Clearing cells just deletes or empties the cell's contents without removing the cell from the worksheet, which would alter the layout of surrounding cells. To get rid of just the contents of a cell selection, select the range of cells to be cleared and press the Delete key.</p>\n<p>If you want to get rid of more than just the contents of a cell selection, like cell formatting or cell comments, follow these steps:</p>\n<ol class=\"level-one\">\n <li><p class=\"first-para\">Select the cells containing the content you want to clear.</p>\n </li>\n <li><p class=\"first-para\">Click the Clear button (the one with the eraser) in the Editing group on the Home tab.</p>\n </li>\n <li><p class=\"first-para\">Click one of the following options on the Clear drop-down menu:</p>\n <ul class=\"level-two\">\n <li><p class=\"first-para\"><b>Clear All</b> gets rid of all formatting, comments, and entries in the cell selection.</p>\n </li>\n <li><p class=\"first-para\"><b>Clear Formats</b> deletes only the formatting from the cell selection without touching anything else.</p>\n </li>\n <li><p class=\"first-para\"><b>Clear Contents</b> deletes only the cell entries; just like pressing the Delete key.</p>\n </li>\n <li><p class=\"first-para\"><b>Clear Comments</b> removes the comments in the cell selection but leaves everything else intact.</p>\n </li>\n <li><p class=\"first-para\"><b>Clear Hyperlinks</b> removes the active hyperlinks in the cell selection but leaves their descriptive text.</p>\n<div class=\"imageBlock\" style=\"width:535px;\"><img src=\"//sg.cdnki.com/how-to-clear-multiple-cells-in-excel---aHR0cHM6Ly93d3cuZHVtbWllcy5jb20vd3AtY29udGVudC91cGxvYWRzLzIwODk5Ny5pbWFnZTAuanBn.webp\" width=\"535\" height=\"400\" alt=\"Excel 2010 gives you options for clearing information from a cell.\"/><div class=\"imageCaption\">Excel 2010 gives you options for clearing information from a cell.</div></div>\n </li>\n </ul>\n </li>\n</ol>\n<h2 id=\"tab2\" >Deleting cells, rows, or columns</h2>\n<p>Deleting cells gets rid of the whole kit and caboodle — cell structure along with all its contents and formatting. When you delete a cell (or an entire row or column), Excel has to shuffle the position of entries in the surrounding cells to plug up any gaps caused by the deletion.</p>\n<p>To delete the actual cell selection rather than just clear the cell contents, follow these steps:</p>\n<ol class=\"level-one\">\n <li><p class=\"first-para\">Select the cells, rows, or columns you want to delete.</p>\n </li>\n <li><p class=\"first-para\">Click the drop-down button attached to the Delete button in the Cells group of the Home tab.</p>\n </li>\n <li><p class=\"first-para\">Click Delete Cells on the drop-down menu.</p>\n<p class=\"child-para\">The Delete dialog box opens, showing these options for filling in the gaps:</p>\n <ul class=\"level-two\">\n <li><p class=\"first-para\"><b>Shift Cells Left</b> moves entries from neighboring columns on the right to the left to fill in gaps created when you delete the cell selection. This is the default option.</p>\n </li>\n <li><p class=\"first-para\"><b>Shift Cells Up</b> moves entries up from neighboring rows below.</p>\n </li>\n <li><p class=\"first-para\"><b>Entire Row</b> removes all the rows in the current cell selection.</p>\n </li>\n <li><p class=\"first-para\"><b>Entire Column</b> deletes all the columns in the current cell selection.</p>\n<div class=\"imageBlock\" style=\"width:535px;\"><img src=\"//sg.cdnki.com/how-to-clear-multiple-cells-in-excel---aHR0cHM6Ly93d3cuZHVtbWllcy5jb20vd3AtY29udGVudC91cGxvYWRzLzIwODk5OC5pbWFnZTEuanBn.webp\" width=\"535\" height=\"400\" alt=\"Use Excel's Delete commands to completely eliminate cells and their contents.\"/><div class=\"imageCaption\">Use Excel's Delete commands to completely eliminate cells and their contents.</div></div>\n </li>\n </ul>\n </li>\n</ol>\n<p class=\"Tip\">To quickly delete an entire column or row from the worksheet, you can right-click the column or row label and select Delete from the shortcut menu (or choose Delete Sheet Rows or Delete Sheet Columns from the Delete button’s menu).</p>\n<p class=\"Warning\">Deleting entire columns and rows from a worksheet is risky business unless you're sure that the columns and rows in question contain nothing of value.</p>","description":"<p>In Excel 2010, when you need to delete data, remove formatting in a cell selection, or remove entire cells, rows, or columns, you have many options. Excel can perform two kinds of cell deletions in a worksheet: clearing cell data and deleting the cell.</p>\n<h2 id=\"tab1\" >Clearing cell contents</h2>\n<p>Clearing cells just deletes or empties the cell's contents without removing the cell from the worksheet, which would alter the layout of surrounding cells. To get rid of just the contents of a cell selection, select the range of cells to be cleared and press the Delete key.</p>\n<p>If you want to get rid of more than just the contents of a cell selection, like cell formatting or cell comments, follow these steps:</p>\n<ol class=\"level-one\">\n <li><p class=\"first-para\">Select the cells containing the content you want to clear.</p>\n </li>\n <li><p class=\"first-para\">Click the Clear button (the one with the eraser) in the Editing group on the Home tab.</p>\n </li>\n <li><p class=\"first-para\">Click one of the following options on the Clear drop-down menu:</p>\n <ul class=\"level-two\">\n <li><p class=\"first-para\"><b>Clear All</b> gets rid of all formatting, comments, and entries in the cell selection.</p>\n </li>\n <li><p class=\"first-para\"><b>Clear Formats</b> deletes only the formatting from the cell selection without touching anything else.</p>\n </li>\n <li><p class=\"first-para\"><b>Clear Contents</b> deletes only the cell entries; just like pressing the Delete key.</p>\n </li>\n <li><p class=\"first-para\"><b>Clear Comments</b> removes the comments in the cell selection but leaves everything else intact.</p>\n </li>\n <li><p class=\"first-para\"><b>Clear Hyperlinks</b> removes the active hyperlinks in the cell selection but leaves their descriptive text.</p>\n<div class=\"imageBlock\" style=\"width:535px;\"><img src=\"//www.dummies.com/wp-content/uploads/208997.image0.jpg\" width=\"535\" height=\"400\" alt=\"Excel 2010 gives you options for clearing information from a cell.\"/><div class=\"imageCaption\">Excel 2010 gives you options for clearing information from a cell.</div></div>\n </li>\n </ul>\n </li>\n</ol>\n<h2 id=\"tab2\" >Deleting cells, rows, or columns</h2>\n<p>Deleting cells gets rid of the whole kit and caboodle — cell structure along with all its contents and formatting. When you delete a cell (or an entire row or column), Excel has to shuffle the position of entries in the surrounding cells to plug up any gaps caused by the deletion.</p>\n<p>To delete the actual cell selection rather than just clear the cell contents, follow these steps:</p>\n<ol class=\"level-one\">\n <li><p class=\"first-para\">Select the cells, rows, or columns you want to delete.</p>\n </li>\n <li><p class=\"first-para\">Click the drop-down button attached to the Delete button in the Cells group of the Home tab.</p>\n </li>\n <li><p class=\"first-para\">Click Delete Cells on the drop-down menu.</p>\n<p class=\"child-para\">The Delete dialog box opens, showing these options for filling in the gaps:</p>\n <ul class=\"level-two\">\n <li><p class=\"first-para\"><b>Shift Cells Left</b> moves entries from neighboring columns on the right to the left to fill in gaps created when you delete the cell selection. This is the default option.</p>\n </li>\n <li><p class=\"first-para\"><b>Shift Cells Up</b> moves entries up from neighboring rows below.</p>\n </li>\n <li><p class=\"first-para\"><b>Entire Row</b> removes all the rows in the current cell selection.</p>\n </li>\n <li><p class=\"first-para\"><b>Entire Column</b> deletes all the columns in the current cell selection.</p>\n<div class=\"imageBlock\" style=\"width:535px;\"><img src=\"//www.dummies.com/wp-content/uploads/208998.image1.jpg\" width=\"535\" height=\"400\" alt=\"Use Excel's Delete commands to completely eliminate cells and their contents.\"/><div class=\"imageCaption\">Use Excel's Delete commands to completely eliminate cells and their contents.</div></div>\n </li>\n </ul>\n </li>\n</ol>\n<p class=\"Tip\">To quickly delete an entire column or row from the worksheet, you can right-click the column or row label and select Delete from the shortcut menu (or choose Delete Sheet Rows or Delete Sheet Columns from the Delete button’s menu).</p>\n<p class=\"Warning\">Deleting entire columns and rows from a worksheet is risky business unless you're sure that the columns and rows in question contain nothing of value.</p>","blurb":"","authors":[{"authorId":9027,"name":"Greg Harvey","slug":"greg-harvey","description":" Greg Harvey is a language scholar who has traced the roots of Tolkien&#146;s work in European folklore and pre-Christian religious beliefs. He has studied 12 languages, including Elvish, Latin, and Anglo-Saxon. ","_links":{"self":"//dummies-api.dummies.com/v2/authors/9027"}}],"primaryCategoryTaxonomy":{"categoryId":33644,"title":"Excel","slug":"excel","_links":{"self":"//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":[{"label":"Clearing cell contents","target":"#tab1"},{"label":"Deleting cells, rows, or columns","target":"#tab2"}],"relatedArticles":{"fromBook":[{"articleId":209119,"title":"Excel 2010 For Dummies Cheat Sheet","slug":"excel-2010-for-dummies-cheat-sheet","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"//dummies-api.dummies.com/v2/articles/209119"}},{"articleId":206078,"title":"How to Save an Excel 2010 Workbook as a PDF or XPS File","slug":"how-to-save-an-excel-2010-workbook-as-a-pdf-or-xps-file","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"//dummies-api.dummies.com/v2/articles/206078"}},{"articleId":206070,"title":"How to Rename an Excel 2010 Worksheet","slug":"how-to-rename-an-excel-2010-worksheet","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"//dummies-api.dummies.com/v2/articles/206070"}},{"articleId":206064,"title":"How to Drag and Drop Data in Excel 2010","slug":"how-to-drag-and-drop-data-in-excel-2010","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"//dummies-api.dummies.com/v2/articles/206064"}},{"articleId":206061,"title":"Automatically Fix Typos and Add Text with AutoCorrect in Excel 2010","slug":"automatically-fix-typos-and-add-text-with-autocorrect-in-excel-2010","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"//dummies-api.dummies.com/v2/articles/206061"}}],"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":"//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":"//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":"//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":"//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":"//dummies-api.dummies.com/v2/articles/263453"}}]},"hasRelatedBookFromSearch":false,"relatedBook":{"bookId":281702,"slug":"excel-2010-for-dummies","isbn":"9780470489536","categoryList":["technology","software","microsoft-products","excel"],"amazon":{"default":"//www.amazon.com/gp/product/0470489537/ref=as_li_tl?ie=UTF8&tag=wiley01-20","ca":"//www.amazon.ca/gp/product/0470489537/ref=as_li_tl?ie=UTF8&tag=wiley01-20","indigo_ca":"//www.tkqlhce.com/click-9208661-13710633?url=//www.chapters.indigo.ca/en-ca/books/product/0470489537-item.html&cjsku=978111945484","gb":"//www.amazon.co.uk/gp/product/0470489537/ref=as_li_tl?ie=UTF8&tag=wiley01-20","de":"//www.amazon.de/gp/product/0470489537/ref=as_li_tl?ie=UTF8&tag=wiley01-20"},"image":{"src":"//www.dummies.com/wp-content/uploads/excel-2010-for-dummies-cover-9780470489536-203x255.jpg","width":203,"height":255},"title":"Excel 2010 For Dummies","testBankPinActivationLink":"","bookOutOfPrint":false,"authorsInfo":"<p><b data-author-id=\"9027\">Greg Harvey, PhD,</b> is president of Mind Over Media, Inc. He is the author of all editions of <i>Excel For Dummies, Excel All-in-One For Dummies, Excel Workbook For Dummies</i>, and <i>Windows For Dummies Quick Reference</i>. He's also an experienced educator. </p>","authors":[{"authorId":9027,"name":"Greg Harvey","slug":"greg-harvey","description":" Greg Harvey is a language scholar who has traced the roots of Tolkien&#146;s work in European folklore and pre-Christian religious beliefs. He has studied 12 languages, including Elvish, Latin, and Anglo-Saxon. ","_links":{"self":"//dummies-api.dummies.com/v2/authors/9027"}}],"_links":{"self":"//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 = \"[{&quot;key&quot;:&quot;cat&quot;,&quot;values&quot;:[&quot;technology&quot;,&quot;software&quot;,&quot;microsoft-products&quot;,&quot;excel&quot;]},{&quot;key&quot;:&quot;isbn&quot;,&quot;values&quot;:[&quot;9780470489536&quot;]}]\" id=\"du-slot-62b36d4093bfc\"></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 = \"[{&quot;key&quot;:&quot;cat&quot;,&quot;values&quot;:[&quot;technology&quot;,&quot;software&quot;,&quot;microsoft-products&quot;,&quot;excel&quot;]},{&quot;key&quot;:&quot;isbn&quot;,&quot;values&quot;:[&quot;9780470489536&quot;]}]\" id=\"du-slot-62b36d40944db\"></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":null,"sponsorEbookTitle":null,"sponsorEbookLink":null,"sponsorEbookImage":null},"primaryLearningPath":"Advance","lifeExpectancy":null,"lifeExpectancySetFrom":null,"dummiesForKids":"no","sponsoredContent":"no","adInfo":"","adPairKey":[]},"status":"publish","visibility":"public","articleId":191901},"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":"2022-08-03T12:59:06+00:00"},"adsId":0,"data":{"scripts":[{"pages":["all"],"location":"header","script":"<!--Optimizely Script-->\r\n<script src=\"//cdn.optimizely.com/js/10563184655.js\"></script>","enabled":false},{"pages":["all"],"location":"header","script":"<!-- comScore Tag -->\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 == \"\" ? \"//sb\" : \"//b\") + \".scorecardresearch.com/beacon.js\";el.parentNode.insertBefore(s, el);})();</script><noscript><img src=\"//sb.scorecardresearch.com/p?c1=2&c2=15097263&cv=2.0&cj=1\" /></noscript>\r\n<!-- / comScore Tag -->","enabled":true},{"pages":["all"],"location":"footer","script":"<!--BEGIN QUALTRICS WEBSITE FEEDBACK SNIPPET-->\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\",\"//zn5o5yqpvmvjgdoun-wiley.siteintercept.qualtrics.com/SIE/?Q_ZID=ZN_5o5yqpvMVjgDOuN\")).start()}catch(i){}})();\r\n</script><div id='ZN_5o5yqpvMVjgDOuN'><!--DO NOT REMOVE-CONTENTS PLACED HERE--></div>\r\n<!--END WEBSITE FEEDBACK SNIPPET-->","enabled":false},{"pages":["all"],"location":"header","script":"<!-- Hotjar Tracking Code for //www.dummies.com -->\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,'//static.hotjar.com/c/hotjar-','.js?sv=');\r\n</script>","enabled":false},{"pages":["article"],"location":"header","script":"<!-- //Connect Container: dummies --> <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":"<!-- Facebook Pixel Code -->\r\n<noscript>\r\n<img height=\"1\" width=\"1\" src=\"//www.facebook.com/tr?id=256338321977984&ev=PageView&noscript=1\"/>\r\n</noscript>\r\n<!-- End Facebook Pixel Code -->","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":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":291934,"title":"For the Exam-Season Crammer","hasSubCategories":false,"url":"/collection/for-the-exam-season-crammer-291934"},{"collectionId":287569,"title":"For the Hopeless Romantic","hasSubCategories":false,"url":"/collection/for-the-hopeless-romantic-287569"},{"collectionId":287567,"title":"For the Unabashed Hippie","hasSubCategories":false,"url":"/collection/for-the-unabashed-hippie-287567"},{"collectionId":292186,"title":"Just DIY It","hasSubCategories":false,"url":"/collection/just-diy-it-292186"}],"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-delete-cells-and-data-in-excel-2010-191901/","hash":"","query":{},"params":{"category1":"technology","category2":"software","category3":"microsoft-products","category4":"excel","article":"how-to-delete-cells-and-data-in-excel-2010-191901"},"fullPath":"/article/technology/software/microsoft-products/excel/how-to-delete-cells-and-data-in-excel-2010-191901/","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"},"sfmcState":{"status":"initial"},"profileState":{"auth":{},"userOptions":{},"status":"initial"}}