Format Cells<\/strong> dialog box<\/a> using any of the following ways:<\/li>\n<\/ol>\n\n\n\nPress Ctrl + 1<\/strong>.<\/p>\n\n\n\nOr<\/strong><\/p>\n\n\n\nClick Home >> Font >> Borders > More Borders<\/strong>.<\/p>\n\n\n\n <\/figure>\n\n\n\nOr<\/strong><\/p>\n\n\n\nRight-click the selected table and select Format Cells<\/strong> on the shortcut menu that appears.<\/p>\n\n\n\n <\/figure>\n\n\n\n\nIn the Border<\/strong> tab of the Format Cells<\/strong> dialog box, select a line style of the border in the Line Style<\/strong> box, select a color of the border in the Color<\/strong> drop-down list, select Outline<\/strong> under Presets<\/strong>, and click OK<\/strong>.<\/li>\n<\/ol>\n\n\n\n <\/figure>\n\n\n\nAn outline border is applied to the table as shown below:<\/p>\n\n\n\n <\/figure>\n\n\n\nMethod 4: Manually Draw the Outline Border<\/h3>\n\n\n\n We have the following table showing some products and their prices.<\/p>\n\n\n\n <\/figure>\n\n\n\nWe want to manually draw a thick outline border around the table.<\/p>\n\n\n\n
We use the steps below:<\/p>\n\n\n\n
\nClick Home >> Font >> Borders >> Draw Border<\/strong>.<\/li>\n<\/ol>\n\n\n\n <\/figure>\n\n\n\nNote:<\/strong> In the worksheet, the mouse pointer changes to a pencil icon as shown below:<\/p>\n\n\n\n <\/figure>\n\n\n\n\nOpen the Borders<\/strong> drop-down list in the Font<\/strong> group of the Home<\/strong> tab and on the Line Color<\/strong> flyout menu, choose a color from Theme Colors<\/strong>, Standard Colors<\/strong>, or More Colors<\/strong>.<\/li>\n<\/ol>\n\n\n\n <\/figure>\n\n\n\n\nOpen the Borders<\/strong> drop-down list in the Font<\/strong> group on the Home<\/strong> tab and select a line style from the Line Style<\/strong> flyout menu.<\/li>\n<\/ol>\n\n\n\n <\/figure>\n\n\n\n\nDrag the pencil icon down diagonally from the top left corner to the bottom right corner of the dataset, to draw a thick border around the table<\/li>\n<\/ol>\n\n\n\n <\/figure>\n\n\n\nNote:<\/strong> Press the Escape key to come out of the drawing mode. The pencil icon changes to the normal cross icon.<\/p>\n\n\n\nHow to Remove a Table Border in Excel<\/h2>\n\n\n\n You can remove the table border if you no longer need it or you want to change it.<\/p>\n\n\n\n
We use the following steps to remove a table border:<\/p>\n\n\n\n
\nSelect the table with a border.<\/li>\n<\/ol>\n\n\n\n <\/figure>\n\n\n\n\nRemove the border using any of the following ways:<\/li>\n<\/ol>\n\n\n\nClick Home >> Font >> Borders >> No Border<\/strong>.<\/p>\n\n\n\n <\/figure>\n\n\n\nOr<\/strong><\/p>\n\n\n\nRight-click the selected table, open the Borders<\/strong> drop-down list on the Mini toolbar and select No Border<\/strong>.<\/p>\n\n\n\n <\/figure>\n\n\n\nOr<\/strong><\/p>\n\n\n\nPress Ctrl + 1<\/strong> to open the Format Cells<\/strong> dialog box. In the Border<\/strong> tab, select None <\/strong>under Presets<\/strong> and click OK<\/strong>.<\/p>\n\n\n\n <\/figure>\n\n\n\nThe border is removed from the table as shown below:<\/p>\n\n\n\n <\/figure>\n\n\n\nConclusion<\/h2>\n\n\n\n Borders make a table stand out and appealing. This tutorial has looked at various techniques for applying or removing a table border in Excel.<\/p>\n","protected":false},"excerpt":{"rendered":"
Excel tables make it easier to analyze and manage data. Borders can make them stand out, appealing, and more readable. In this tutorial,…<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[21],"tags":[170,190],"yoast_head":"\n
Apply or Remove a Table Border in Excel<\/title>\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n\t \n\t \n\t \n