how to apply thick outside borders in excel

Adding Thick Outside Borders in Excel: A Step-by-Step Guide.

By Ashley Allen
AD

Ever found yourself wanting to highlight a specific range in Excel, only to have your thick borders disappear into thin air when printing? Frustrating, isn't it? Excel's default settings may not always cater to your aesthetic or functional needs. But worry not! We're here to guide you through the process of applying thick outside borders in Excel that persist even after printing. Let's dive right in.

Did you know that Excel's border width can be adjusted to a line thickness of up to 50pt? In this article, we'll explore the Hidden features of Excel's border options, helping you to create powerful border effects that can enhance your data visualisation or simply make your spreadsheets look more polished.

Understanding Excel Border Options

Before we dive into creating thick borders, it's crucial to understand Excel's border options. Excel offers a range of border styles and colors, from thin lines to double lines, from solid colors to gradient fills. However, thick borders are not explicitly listed in the drop-down menu. So, how do we achieve this?

AD
Apply or Remove a Table Border in Excel
Apply or Remove a Table Border in Excel
How to Add Thick Box Border in Excel (3 Quick Ways) - ExcelDemy
How to Add Thick Box Border in Excel (3 Quick Ways) - ExcelDemy
How to Add or Remove Dotted Border in Excel - ExcelDemy
How to Add or Remove Dotted Border in Excel - ExcelDemy

Once you select a cell and move your cursor to the border icon in the Home tab, you'll see that the border width option is grayed out. This is because Excel only allows adjusting the border width through specific keyboard shortcuts or custom formatting. Let's explore these hidden features.

Method 1: Using Keyboard Shortcuts

Excel offers keyboard shortcuts for adjusting border widths. Here's how it works:

Add Automatic Borders in Excel with Just ONE Trick | You’ll Be Shocked How Easy It Is #excel #border
Add Automatic Borders in Excel with Just ONE Trick | You’ll Be Shocked How Easy It Is #excel #border
How to Add Border in Excel
How to Add Border in Excel
  • Select the cells you want to format.

  • Press 'Ctrl + 1' (Windows) or 'Cmd + 1' (Mac) to open the Format Cells dialog box.

  • Under the 'Border' tab, select the style and color you want.

  • To adjust the border width, hold down the 'Ctrl' (Windows) or 'Cmd' (Mac) key, and press the number keys from 1 to 5 simultaneously. Each key corresponds to a specific border width:

    • 1: Hairline (0.5pt)

    • 2: Thin (1pt)

    • 3: Medium (1.5pt)

    • 4: Thick (2pt)

    • 5: Very Thick (2.25pt)

  • Press Enter, and you'll see the border applied to your selected cells.

You can also press the 'Apply' button to see the effect of adjustment without closing the dialog box.

Method 2: Custom Border Formatting

Using custom border formatting gives you more control over the border width. Here's how to do it:

AD
  1. Select the cells you want to format.

  2. Click the border icon in the Home tab, then click 'More Borders'.

  3. Under 'Line Style', click 'None'.

  4. Under 'Color', click the color you want. Click 'OK'.

  5. Now, your border is visible, but its width is still too thin. To adjust the width, hold down the 'Shift' key and use the arrow keys on your keyboard to select all four sides of your selected cell.

  6. Right-click the selected border and choose 'Format Cells' from the context menu.

  7. In the 'Format Cells' dialog box, click the 'Line Style' tab.

  8. Next to 'Width', you'll see that the border width is now shown as 'Custom'. Click the up and down arrows to adjust the width to your desired thickness. Click 'OK'.

  9. Your thick border is now applied to your selected cells.

You can apply this formatting to as many cells as you like, including entire columns or rows, or even your entire worksheet.

Adjusting Border Width for Print

By default, Excel adjusts border width when printing. This is particularly useful when you want your thick borders to stand out in your printed documents. Here's how you can control this feature:

Method 1: Changing the Printer Scaling

You can change the printer scaling to make the borders thicker in the printed output. Here's how:

AD
  • Before printing, click 'File' > 'Print' > 'Page Setup'.

  • Under 'Scaling', choose 'Fit to', and then enter a percentage that increases the size of your worksheet. For instance, 110% will increase the size by 10%.

  • Click 'Print Preview' to see how this affects your printout. Adjust the scaling percentage as needed.

  • Once you're satisfied, click 'Print'.

This method will ensure that your thick borders are more prominent in your prints. However, it may also make other elements on your worksheet appear larger than intended.

Method 2: Setting Print Options

Alternatively, you can set print options to preserve border width. Here's how:

  1. Before printing, click 'File' > 'Print' > 'Page Setup'.

  2. Under 'Print options', check the box for 'Fit to', and then enter a specific page width (e.g., 8.5 inches for Letter paper).

  3. Under 'Scaling', make sure 'Automatic' is selected. This ensures that your worksheet is not resized to fit the paper size.

  4. Click 'Print' to print your worksheet with preserved border width.

This method ensures that your thick borders maintain their width in the printed output without affecting the size of other elements on your worksheet.

AD

Mastering Excel's border options and printer settings allows you to add a level of professionalism to your spreadsheets while ensuring that your data remains easily readable, both on screen and in print. Experiment with different border styles, colors, and widths to enhance your data visualisation and make your worksheets truly stand out. Happy formatting!

AD