How to Bolden Lines in Microsoft Excel

If you want to learn how to bolden lines in Excel, we’ll show you how to add bold border lines, darken the gridlines, and increase the weight of a drawn line.

Make Borders Bold in Excel

When you add borders in Excel, you can change the border style to a thicker weight which allows you to bold the lines easily. You can also change the color and place the borders outside, inside, or on certain edges of a cell.

  1. Select the cells where you want to place the bold border lines or the existing cells where you already have a border.
  2. Go to the Home tab and open the Border drop-down menu in the Font section of the ribbon. Choose More Borders.
  1. In the Format Cells dialog box, confirm you’re on the Border tab.
  2. Pick a line Style on the top left. You’ll notice a couple of thicker lines on the right side of the style box.
  1. Optionally, change the line Color using that drop-down box beneath.
  2. On the right side, use the Presets at the top or choose the individual border buttons to apply them in the preview window. You can also click to choose the border positions right in the preview.
  1. When you have the borders set, select OK to save the change.

You’ll then see a bold border for your selected cells.

Make Gridlines Darker in Excel

Maybe it’s the gridlines in Excel that you want bolder and easier to see. While you can’t choose a different line weight for the gridlines, you can make them black rather than the default gray color which makes them appear bold. This is especially useful if you plan to print your Excel spreadsheet.

First, make sure that you can see the gridlines. Go to the Page Layout tab and check the box for View below Gridlines. You can also check the box for Print if you want to display the gridlines when you print the sheet.

To change the color of the gridlines, do one of the following to open the settings on Windows or Mac.

Gridlines in Excel on Windows

  1. Select File > Options. Choose Advanced on the left and move to the Display options for this worksheet section on the right.
  2. Make sure the Show gridlines box is checked and open the Gridline color menu.
  1. Pick Black on the top left or another darker color per your preference.
  1. Select OK to save your change and return to your spreadsheet.

Gridlines in Excel on Mac

  1. Select Microsoft Excel > Preferences in the menu bar. Choose View.
  1. Confirm that the Gridlines box is checked and open the drop-down box to the right.
  1. Pick Black on the top left or another color if you prefer.
  1. Close the View settings using the X on the top left and you’ll see your sheet update.

Make a Drawn Line Bold in Excel

If you draw a line in Excel using the Shapes feature, maybe that’s the line you want to bolden. You can do this in just a few steps.

  1. If you haven’t added your line yet, go to the Insert tab, open the Shapes drop-down box in the Illustrations section, and pick Line.
  1. Drag your cursor to draw your line and then select it.
  1. Go to the Shape Format tab that displays and open the Quick Styles box in the Shape Styles section.
  2. You’ll see Moderate Line and Intense Line weights for each color with the black options on the left.
  1. Pick one of these bold lines styles and you’ll see it apply to your drawn line.

Whether a cell border, worksheet gridlines, or a drawn line, you can bolden otherwise thin lines in an Excel sheet in just minutes.

For more, look at our tutorial for how to get rid of dotted lines in Microsoft Excel.



Source : How to Bolden Lines in Microsoft Excel

Comments

Post a Comment

Popular posts from this blog

How to Alternate Row and Column Colors in Microsoft Excel

Image
Alternating the colors of rows and columns in Excel , also known as banding, is one way to make the document easier to read. This practice is helpful when you have documents with lots of data , whether a school or work project. Microsoft Excel doesn’t have a dedicated button to alternate row and column colors, so you’ll have to be creative to achieve the result of banded rows. An Excel document offers several ways to alternate row and column colors. For example, you can select specific rows and columns and apply a color to each one of them. Although this might sound like a simple solution, manually applying row and column colors would be tedious if your Excel spreadsheet contains thousands of entries. Imagine having to do it to all the documents in a workbook. So, let’s see what you can do to alternate row and column colors in Microsoft Excel quickly. 1. Color Rows and Columns Using Table Style Banding Using the predefined table styles is a quick way to apply alternate colors to
Read more

How to Add or Remove a Secondary Axis in Microsoft Excel Charts

Image
When you have a chart with mixed data types or a dataset that varies broadly between series, consider using a secondary axis in Microsoft Excel. With it, you can display the data you need without overwhelming or confusing your viewers. When to Use a Secondary Axis As mentioned, if you have different data types or your series amounts widely vary, these are good times to use a secondary axis. For instance, you can see that the column chart below doesn’t accurately depict the visitors and sales in our dataset. There’s a large variance in the sales amounts, making it hard to get a decent picture of the number of visitors per month. Plus, the sales are in dollar amounts, whereas the visitors are basic number values . If your chart would benefit from a secondary axis like this one, here’s how to add one as well as remove a secondary axis later if you change your mind or your data. How to Add a Secondary Axis in Excel To add a secondary axis to your Excel chart, you’ll use the combo
Read more

How to Use and Customise the Status Bar in Microsoft Excel

Image
Excel’s status bar is one of the hidden gems (and an unsung hero) that makes it the default spreadsheet software you turn to. It quietly resides at the bottom of the Excel window, often overlooked but brimming with valuable information and customization options. In this article, we will look at it and show you how to take advantage of it. Excel Status Bar Default Options Even before you customize the Excel status bar, it’ll display some helpful information and give you access to some useful functionalities. The common Excel options you can find as default on the status bar are: Cell Mode Macro Recording Tool Accessibility Check Page Number Statistics/Mathematical Options Worksheet Views Zoom Options Let’s see what each of them does and how you can use them. Cell Mode At the leftmost side of the Excel status bar, you’ll find the cell mode indicator. It’ll inform you about the status of the currently selected cell. There are four different status modes: Ready . It
Read more