Use keyboard shortcuts and ribbon options to add borders in Excel

  1. Emphasize important data with borders
  2. About borders in Excel tables
  3. Add borders with hotkey
  4. Add Borders in Excel with Ribbon Options
  5. Choose different border options
  6. Draw border lines quickly with the border draw feature
  7. Draw with border grid
  8. Stop drawing boundaries
  9. erase the border

Emphasize important data with borders

In Excel, borders are lines that are added to the borders of a cell or group of cells. Line styles that can be used for borders include single, double, and polylines. The thickness of the lines can vary, as well as the color.

The information in this article applies to Excel 2019, 2016, 2013, 2010, and Excel for Mac.

About borders in Excel tables

Borders are formatting features used to improve the look of your worksheet. Borders make it easier to find and read specific data. Boundaries also draw attention to important data, such as the results of formulas.

Add borders with hotkey

If you prefer to use the keyboard, use the keyboard shortcut to add a border to the outer edges of one or more selected cells. This shortcut uses the default line color and weight. Shortcut to add a border:

  Ctrl  +  Shift  +  &  

To add a border to a range of cells in an Excel worksheet:

  1. Select the desired range of cells on the sheet.

  2. Press and hold keys ctrl And Shift

  3. Press key without letting go of the keys ctrl And Shift to surround the selected cell with a black border.

Add Borders in Excel with Ribbon Options

The Borders option is found on the Home tab and can be used to add custom borders to cells in a worksheet.

To add a custom border:

  1. Select the desired range of cells on the sheet.

  2. Select Home

  3. Select borders arrow down to open the border options drop-down list.

  4. Select frame style † The selected border appears around the selected cells.

Choose different border options

When you’re ready to add and format lines and borders to an Excel sheet, you have several options:

  • Add borders to one or all sides of a cell or cell block.

  • Select the line width.

  • Choose from several line styles.

  • Apply color to the edge.

  • Draw borders around irregularly shaped data blocks with the border drawing feature in Excel.

Draw border lines quickly with the border draw feature

Border drawing feature: at the bottom of the “Borders” drop-down menu. One of the advantages of using edge drawing is that you don’t have to select the cells first. Instead, when the Draw Border option is selected, borders can be added directly to the sheet.

Draw Border also includes options to change the line color and line style. This makes it easy to change the appearance of the borders used to mark important blocks of data. The line style options allow you to create borders with:

  • Lines of different thickness

  • Dotted and Dotted Lines

  • double lines

To draw boundary lines using the Draw Border tool:

  1. Select At home

  2. Click the arrow next to borders to open the drop-down list. From this list, you can choose a different line color, change the line weight, and draw boundary lines around cells.

  3. Select Line color and choose the color you want to use for the border.

  4. Select line style and select the lineweight you want to apply to the border.

  5. Select draw the line † The mouse pointer changes to a pencil.

  6. Select the side of the individual cells where you want to add a single border.

  7. Drag the pointer to add an outer border to a cell or group of cells.

Draw with border grid

Another option in the list of borders is to draw a border grid. Draw Border Grid allows you to add outer and inner borders to one or more cells at the same time. Select At home borders Draw Boundary Grid and drag the mouse pointer to create borders around the desired cells.

Stop drawing boundaries

To stop drawing borders, select borders † Excel remembers the last used border type, so choose again borders turn this mode back on.

erase the border

The Clear Border option, as the name suggests, makes it easy to remove borders from worksheet cells. Erase Border allows you to delete the borders individually by selecting them. You can remove multiple borders by dragging these cells.

Leave a Reply

Your email address will not be published. Required fields are marked *