How to

How To Add and Change Cell Borders In Excel

Excel spreadsheets can be tough to read at a look, thanks to dense information and the grid format. Investing a little time on your spreadsheet to make it much easier to check out is a strong plus, starting with the borders around different cells.

Here’s how to adjust the border around specific cells, and around several cells simultaneously.

To pick a single cell, just click it. To select numerous cells simultaneously, click on the first one and drag the cursor left or right. Or, you can click one in the top left cell you wish to pick, and then Shift-click the bottom right cell to pick an entire block.

You can also choose numerous cells in various columns or rows by holding down the Ctrl button while you click.

Now, on the “Home” tab on the Ribbon, you’ll see a “Font” area with controls for formatting text. You’ll likewise discover a border button that looks like a window (a grid of 4 small boxes). Click that button to open the border menu.

You’ll see more than a dozen common choices for borders. The choices in the “Borders” section of that menu cover most of the types of cell borders you’ll wish to utilize. For example, a row of title text might benefit from a thick bottom border with empty borders on the top and sides.

Toward the bottom of that menu, you’ll likewise see a “Draw Borders” area. The alternatives there let you click and drag to apply the selected border design, which can be useful if you’re attempting to rapidly put said verge on great deals of various cells in your spreadsheet.

The “Erase” border lets you do the very same thing, however for completely eliminating all borders. With the Erase tool active you can click private cells or multiple cells to take off all borders rapidly.

The “Line color” tool does not change the position or density of selected borders, but it does change the color applied to them.

The line design alternative lets you apply more exotic lines to your cells– like dots, dashes, and double lines.

At the very bottom of the menu, clicking the “More borders” choice opens up the “Format Cells” window to the “Border” tab. All of fast options you find on the menu are readily available in this screen, which might assist you if you’re attempting to apply several results to selected cells quickly.

It takes a little playing around to get the hang of applying borders, once you do, positioning good borders can truly make your spreadsheets simpler to deal with.

Leave a Reply

Need help with the Commons? Visit our
help page
Send us a message