How To Draw Borders In Excel

If you want a jail cell edge in your sail that's outside of the predefined options, you can easily describe borders in Excel whatsoever style y'all like.

Microsoft Excel provides a proficient selection of premade cell borders. You lot can pick from the top, bottom, left, correct, thick, double, and more. But recently, Microsoft gave Excel users the ability to depict their ain borders too.

With the Draw Border tools, you can choose a line way and colour, use a border grid to a cake of cells, and erase individual lines with ease.

If you want to create a cell border that's outside of the predefined options, here'southward how to draw borders in Microsoft Excel.

How to Draw a Prison cell Border in Excel

Start by selecting the cell where you want to add a border. Then, go to the Home tab, click the Borders driblet-downwards list, and view the Draw Borders department at the bottom.

Before you use the drawing tool, y'all can select a style and color for your border if you similar.

Choose a Line Color and Style

Hover over Line Color then select a nice shade from the palette in the pop-out menu. Alternatively, you can choose More Colors to use a custom colour.

Go to Line Style to use a sparse, thick, dotted, or dashed line from the popular-out carte du jour.

Draw a Border or Edge Grid

When you lot're ready to create your border, select either Draw Edge to apply 1 line at a time or Depict Border Grid to add all sides to a group of cells.

To use Depict Border, click each line to create a border for a single cell. This lets you add whichever parts of the border you desire or mix and friction match colors and styles.

To use Draw Border Grid, click the start cell in the group and then drag through the rest. This places a full iv-sided border on each cell in the range.

Erase a Line or Border

In the list of Draw Borders tools, you'll also see an Erase Border pick. You lot can use this to erase single lines for a cell past clicking each line you want to remove.

For a edge grid, you lot can practise the aforementioned by clicking to erase one line at a time or drag through sections of the grid to remove multiple lines.

Using Predefined Borders Afterwards Drawing

Subsequently you use customizations like line color and manner to draw a edge, yous can certainly get back to using the premade borders at the top of the Borders drop-down menu whatsoever time.

Ane thing to keep in mind, however, is that when you lot do this, the line colour and style you selected will remain equally the choices for those predefined borders. While this may be exactly what you want, it likewise may not exist.

To revert to the default edge styles, select Line Color and cull Automated so select Line Manner and choose the thin line at the tiptop of the list (below None).

Create Cell Borders Your Manner in Excel

The Draw Border feature is a great addition to Excel. With information technology, y'all pop a line here or there or create a border grid with less work and fewer clicks than before. What do you think of this feature?

To do more than with Microsoft Excel, take a look at how to merge and unmerge cells or how to find and replace formatting.

Source: https://www.groovypost.com/howto/draw-cell-borders-in-microsoft-excel/

Posted by: parentdights.blogspot.com

Share this post