Normally we can easily add all/top/bottom/left/right borders for selected cells in Excel. However, if we want to custom the border thickness, width, color, or add diagonals, it seems a little complex. Here I will show you how to design custom border style with customizing thickness, width, color, or diagonal in Excel, and save custom border style in Excel as well.
Design custom border style with customizing thickness, width, color, and diagonal
This section is talking about how to add custom border for selected cells with special border thickness, width, color, or even add diagonal in Excel easily.
Step 1: Select the cells you want to add custom borders.
Step 2: Click the arrow besides Border button > More Borders on the Home tab.
Step 3: In the opening Format Cells dialog box, please do as follows.
(1) Go to the Border tab;
(2) In the Style box, click to select one line style. If you want to custom the border thickness, select the line style with proper thickness;
(3) Custom the border color with clicking the Color box and then specify a proper color from drop down list;
(4) In the Border section, select borders you will add. In our example, we will add Diagonal down border and Diagonal up border, so we click to highlight both buttons as above screen shot shown.
(5) Click the OK button.
Then you will see the custom border is added to selected range as following screen shot shown:
Save custom border style
If you want to save the custom border for applying it to other cells in future easily, you can save the custom border as a custom cell style. And you can do as follows:
Step 1: Keep selecting the cells with custom border, then go to the Styles group on the Home tab, and click the arrow button
Step 2: In the opening Style dialog box, type a name for this custom cell style in the Style name box, and uncheck all options except the Border option in the Style Includes (By Example) section.
Step 3: Click the OK button.
The custom cell style is saved in the Styles group under Home tab in Excel.
Note: Actually, in the Style dialog box you can also click the Format button to open the Format Cells dialog box, and then customize a border style on the Border tab. See below screen shot:
No ratings yet. Be the first to rate!
{"appState":{"pageLoadApiCallsStatus":true},"articleState":{"article":{"headers":{"creationTime":"2016-03-26T21:04:49+00:00","modifiedTime":"2016-03-26T21:04:49+00:00","timestamp":"2022-06-22T19:27:46+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 Add Cell Borders in Excel 2010","strippedTitle":"how to add cell borders in excel 2010","slug":"how-to-add-cell-borders-in-excel-2010","canonicalUrl":"","seo":{"metaDescription":"In Excel 2010, you can add borders to individual cells to emphasize or define sections of a worksheet or table. Use the Borders button in the Font group on the ","noIndex":0,"noFollow":0},"content":"<p>In Excel 2010, you can add borders to individual cells to emphasize or define sections of a worksheet or table. Use the Borders button in the Font group on the Home tab to add borders of varying styles and colors to any or all sides of the cell selection.</p>\n<p class=\"Remember\">Don't confuse the <i>borders</i> that you add to accent a particular cell selection with the <i>gridlines</i> normally used to define cell borders in the worksheet — borders that you add are printed whether or not you print the worksheet gridlines. You can remove the display of gridlines by clearing the View check box in the Gridlines section of the Page Layout tab.</p>\n<p>Follow these steps to add cell borders:</p>\n<ol class=\"level-one\">\n <li><p class=\"first-para\">Select the cells you want to format.</p>\n </li>\n <li><p class=\"first-para\">Click the down arrow beside the Borders button in the Font group on the Home tab.</p>\n<p class=\"child-para\">A drop-down menu appears, with all the border options you can apply to the cell selection.</p>\n<div class=\"imageBlock\" style=\"width:535px;\"><img src=\"//sg.cdnki.com/how-to-add-a-thin-border-in-excel---aHR0cHM6Ly93d3cuZHVtbWllcy5jb20vd3AtY29udGVudC91cGxvYWRzLzIyMTM0My5pbWFnZTAuanBn.webp\" width=\"535\" height=\"400\" alt=\"Use the Borders button on the Home tab to choose borders for the selected cells.\"/><div class=\"imageCaption\">Use the Borders button on the Home tab to choose borders for the selected cells.</div></div>\n </li>\n <li><p class=\"first-para\">Click the type of line you want to apply to the selected cells.</p>\n<p class=\"child-para\">When selecting an option on the Borders drop-down menu, keep these things in mind:</p>\n <ul class=\"level-two\">\n <li><p class=\"first-para\">To have Excel draw borders only around the outside edges of the entire cell selection (in other words, following the path of the expanded cell cursor), click the Outside Borders or the Thick Box Border option.</p>\n </li>\n <li><p class=\"first-para\">If you want borderlines to appear around all four edges of <i>each</i> cell you've selected, select the All Borders option.</p>\n </li>\n </ul>\n </li>\n</ol>\n<p>To change the type of line or line thickness or color of the borders you apply to a cell selection, open the Format Cells dialog box and use the options on its Border tab (click More Borders at the bottom of the Borders button's drop-down menu or press Ctrl+1 and then click the Border tab).</p>\n<div class=\"imageBlock\" style=\"width:445px;\"><img src=\"//sg.cdnki.com/how-to-add-a-thin-border-in-excel---aHR0cHM6Ly93d3cuZHVtbWllcy5jb20vd3AtY29udGVudC91cGxvYWRzLzIyMTM0NC5pbWFnZTEuanBn.webp\" width=\"445\" height=\"400\" alt=\"You'll find more options for cell borders on the Border tab of the Format Cells dialog box.\"/><div class=\"imageCaption\">You'll find more options for cell borders on the Border tab of the Format Cells dialog box.</div></div>\n<p class=\"Tip\">To remove borders in a worksheet, select the cell or cells that presently contain them and then click the No Border option in the Borders button's drop-down menu.</p>","description":"<p>In Excel 2010, you can add borders to individual cells to emphasize or define sections of a worksheet or table. Use the Borders button in the Font group on the Home tab to add borders of varying styles and colors to any or all sides of the cell selection.</p>\n<p class=\"Remember\">Don't confuse the <i>borders</i> that you add to accent a particular cell selection with the <i>gridlines</i> normally used to define cell borders in the worksheet — borders that you add are printed whether or not you print the worksheet gridlines. You can remove the display of gridlines by clearing the View check box in the Gridlines section of the Page Layout tab.</p>\n<p>Follow these steps to add cell borders:</p>\n<ol class=\"level-one\">\n <li><p class=\"first-para\">Select the cells you want to format.</p>\n </li>\n <li><p class=\"first-para\">Click the down arrow beside the Borders button in the Font group on the Home tab.</p>\n<p class=\"child-para\">A drop-down menu appears, with all the border options you can apply to the cell selection.</p>\n<div class=\"imageBlock\" style=\"width:535px;\"><img src=\"//www.dummies.com/wp-content/uploads/221343.image0.jpg\" width=\"535\" height=\"400\" alt=\"Use the Borders button on the Home tab to choose borders for the selected cells.\"/><div class=\"imageCaption\">Use the Borders button on the Home tab to choose borders for the selected cells.</div></div>\n </li>\n <li><p class=\"first-para\">Click the type of line you want to apply to the selected cells.</p>\n<p class=\"child-para\">When selecting an option on the Borders drop-down menu, keep these things in mind:</p>\n <ul class=\"level-two\">\n <li><p class=\"first-para\">To have Excel draw borders only around the outside edges of the entire cell selection (in other words, following the path of the expanded cell cursor), click the Outside Borders or the Thick Box Border option.</p>\n </li>\n <li><p class=\"first-para\">If you want borderlines to appear around all four edges of <i>each</i> cell you've selected, select the All Borders option.</p>\n </li>\n </ul>\n </li>\n</ol>\n<p>To change the type of line or line thickness or color of the borders you apply to a cell selection, open the Format Cells dialog box and use the options on its Border tab (click More Borders at the bottom of the Borders button's drop-down menu or press Ctrl+1 and then click the Border tab).</p>\n<div class=\"imageBlock\" style=\"width:445px;\"><img src=\"//www.dummies.com/wp-content/uploads/221344.image1.jpg\" width=\"445\" height=\"400\" alt=\"You'll find more options for cell borders on the Border tab of the Format Cells dialog box.\"/><div class=\"imageCaption\">You'll find more options for cell borders on the Border tab of the Format Cells dialog box.</div></div>\n<p class=\"Tip\">To remove borders in a worksheet, select the cell or cells that presently contain them and then click the No Border option in the Borders button's drop-down menu.</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’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":[],"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’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 = \"[{"key":"cat","values":["technology","software","microsoft-products","excel"]},{"key":"isbn","values":["9780470489536"]}]\" id=\"du-slot-62b36d328b5be\"></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":["9780470489536"]}]\" id=\"du-slot-62b36d328bd01\"></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":190854},"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-add-cell-borders-in-excel-2010-190854/","hash":"","query":{},"params":{"category1":"technology","category2":"software","category3":"microsoft-products","category4":"excel","article":"how-to-add-cell-borders-in-excel-2010-190854"},"fullPath":"/article/technology/software/microsoft-products/excel/how-to-add-cell-borders-in-excel-2010-190854/","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"}}
In Excel 2010, you can add borders to individual cells to emphasize or define sections of a worksheet or table. Use the Borders button in the Font group on the Home tab to add borders of varying styles and colors to any or all sides of the cell selection. Don't confuse the borders that you add to accent a particular cell selection with the gridlines normally used to define cell borders in the worksheet — borders that you add are printed whether or not you print the worksheet gridlines. You can remove the display of gridlines by clearing the View check box in the Gridlines section of the Page Layout tab. Follow these steps to add cell borders: Select the cells you want to format. Click the down arrow beside the Borders button in the Font group on the Home tab. A drop-down menu appears, with all the border options you can apply to the cell selection.
Use the Borders button on the Home tab to choose borders for the selected cells.
Click the type of line you want to apply to the selected cells.
When selecting an option on the Borders drop-down menu, keep these things in mind:
To have Excel draw borders only around the outside edges of the entire cell selection (in other words, following the path of the expanded cell cursor), click the Outside Borders or the Thick Box Border option.
If you want borderlines to appear around all four edges of each cell you've selected, select the All Borders option.
To change the type of line or line thickness or color of the borders you apply to a cell selection, open the Format Cells dialog box and use the options on its Border tab (click More Borders at the bottom of the Borders button's drop-down menu or press Ctrl+1 and then click the Border tab).
You'll find more options for cell borders on the Border tab of the Format Cells dialog box.
To remove borders in a worksheet, select the cell or cells that presently contain them and then click the No Border option in the Borders button's drop-down menu.