The tutorial shows how to border cells in Excel by using the predefined options and how to create your custom cell border style. Show
Sometimes Excel worksheets can be difficult to read because of dense information and complex structure. Adding border around cells can help you distinguish different sections, emphasize certain data, such as column headings or total rows, and make your worksheets better presentable and more attractive. What are cell borders in Excel?Border is a line around a cell or a block of cells in Excel. Generally, cell borders are used to accent a specific section of a spreadsheet to make it stand out. For example, you can insert a border to draw attention of viewers to totals or other important data on the sheet. Please do not confuse cell borders with worksheet gridlines. Borders are ticker and more prominent. Unlike gridlines, cell borders do not appear in a worksheet by default, you need to apply them manually. When printing out a document, the borders will appear on printed pages regardless of whether you print gridlines or not. Microsoft Excel offers a few different ways to add a border around a single cell or a ranges of cells. How to create border in ExcelThe fastest way to make a border in Excel is to apply one of the inbuilt options directly from the ribbon. Here's how:
For example, this is how you can apply an outside border around cells in Excel: More examples of Excel cell borders can be found here. Tips:
How to insert border in Excel with Format Cells dialogThe Format Cells dialog is the most effective method of adding borders in Excel. It gives you easy access to all the settings including the line color and thickness as well as a nice diagram preview. To insert a border via the Format Cells dialog, this is what you need to do:
Excel border shortcutsTo quickly insert and remove cell borders, Excel provides a couple of keyboard shortcuts. Add outside borderTo add an outline border around the current selection, press the following keys at the same time. Windows shortcut: Ctrl + Shift + & Mac shortcut: Command + Option + 0 Remove all bordersTo remove all borders within the current selection, use the following key combinations. Windows shortcut: Ctrl + Shift + _ Mac shortcut: Command + Option + _ Note. Excel border shortcut does not give you control over the line color and thickness. To create borders professionally, it is recommended to use the Format Cells dialog that provides full access to all the settings. Shortcuts for Format cells dialogOn the Borders tab of the Format Cells dialog, you can also use the following shortcuts toggle borders on and off:
Tip. In case you are adding multiple borders, it is sufficient to press Alt just once, and then you can hit only the letter keys. For example, to place the top and bottom borders, press Alt + T, and then B. How to draw borders in ExcelInstead of selecting cells first, and then choosing from a set of built-in options, you can draw borders directly on the worksheet. Here's how:
Tip. To delete the entire border or any of its elements, use the Erase border feature as describe in Erasing borders. How to create a custom border style in ExcelIn none of the predefined cell borders meet your needs, you can create your own border style. Here are the steps to perform:
To apply your custom border style, just do the following:
Your custom style will be applied to the selected cells at once: How to change the color and width of cell bordersWhen you add a cell border in Excel, a black (automatic) line color and a thin line style is used by default. To change the color and width of cell borders, please follow these steps:
Examples of cell border in ExcelBelow you will have a few examples of how your Excel borders may look like. Outside borderTo apply an outline border around cells, use either Outside Borders or Think Outside Borders option: Top and bottom borderTo apply top and bottom border in Excel with
a single command, use this option: Top and thick bottom borderTo apply top and thick bottom border, use this one: Bottom double borderTo place a bottom double border in Excel, use the below command. This option comes especially handy for separating a total row: Inside and outside bordersTo place both inside and outside borders at a time, use the All Borders command: To put only inside borders or use different colors and line styles for inside and outside borders, use either the
Draw Borders feature the Format Cells dialog. The below image shows one of many possible results: Creating borders in Excel - useful tipsThe following tips will give you some insight into Excel cell borders that may help you use them more efficiently.
How to remove a cell border in ExcelDepending on whether you want to delete all or specific borders, use one of the following techniques. Remove all bordersTo delete all borders within a range, this is what you need to do:
Alternatively, you can use the remove borders shortcut: Ctrl + Shift + _ If you choose to remove all formatting in Excel, this will also remove cell borders. Erase individual bordersTo remove borders one at a time, use the Erase Border feature:
That's how to create and change borders in Excel. I thank you for reading and hope to see you on our blog next week! You may also be interested inWhat is the format cells dialog box in Excel?The Format Cells dialog box is where you set the formatting options for your report objects. You can format the number, font, alignment, border, and pattern for a row or column header and the values.
Which tab is selected in the format cells dialog box to select the format of data or time?Alignment Tab. You can position text and numbers, change the orientation and specify text control in cells by using the Alignment tab in the Format Cells dialog box.
Which page of the cell format is dialog box?By default, all worksheet cells in the SpreadsheetControl are formatted with the General number format. End-users can invoke the Format Cells dialog with the Number tab open by clicking the dialog box launcher located in the bottom-right corner of the Number group in the Home tab of the Ribbon UI.
Which command is used to launch format cells dialog box?Keyboard shortcuts for formatting cells. |