How to Outline Cells with Borders in Microsoft Excel

Outlining cells with a border in Microsoft Excel is a simple design technique that can take a basic spreadsheet to the next level. There are a few different ways you can add a border and several style considerations that can change the look of the border you choose. Some borders are predefined, but you can also customize them to meet the goals of your spreadsheet.

How to outline cells with borders

  1. Select the cells you want to outline.

    Screenshot of cells with green border in Microsoft Excel.

  2. Select the border menu from the Home tab on the ribbon toolbar.

    Alternatively, you can right click the cell(s) you want to outline, select Format Cells, and navigate to the border tab.Screenshot of border menu in Microsoft Excel.

  3. Select the border option you want to use to outline the cells.

    Options include right, left, top, bottom, all outside, and all side borders. You can also select the Draw Border or Draw Border Grid tools to freehand your border placement by selecting the cells around which you want to create a border.Screenshot of border options in Microsoft Excel.

  4. Adjust the formatting options to change the appearance of the border.

    From the border menu, select More Borders… and select the line style, color, and placement you want. A preview of the border will appear in the preview box. Click OK to apply the new border settings.Screenshot of border settings window in Microsoft Excel.

  5. Deselect the cells to review the appearance of the border.

    Screenshot of cells with green border in Microsoft Excel.

Why you should use borders in Excel

There are many reasons why you might want to use a border in Excel. Borders can separate sections of data to group similar items. You can also use borders to emphasize specific cells so the reader’s eye is automatically drawn to the most important information as quickly as possible. 

In general, borders are an effective way to add your brand identity to a spreadsheet. You can add a custom color hex code to the color selection tool in Excel, which means you can make the border around specific cells match the colors in your company’s logo or brand guidelines.

Border outline keyboard shortcuts for Excel

You can use the keyboard shortcuts for Windows and macOS in the table below to outline selected cells with a border:

ActionWindows ShortcutmacOS Shortcut
Add border on all sidesCtrl+Shift+& (ampersand)Command+Option+0
Add or remove border leftAlt+LCommand+Option+left arrow
Add or remove border rightAlt+RCommand+Option+right arrow
Add or remove border topAlt+TCommand+Option+up arrow
Add or remove border bottomAlt+BCommand+Option+down arrow
Remove border on all sidesCtrl+Shift+_ (underscore)Command+Option+_ (underscore)
Kaiti Norton
Kaiti Norton is a Nashville-based Content Writer for TechnologyAdvice, a full-service B2B media company. She is passionate about helping brands build genuine connections with their customers through relatable, research-based content. When she's not writing about technology, she's sharing her musings about fashion, cats, books, and skincare on her blog.

Top Articles

The Complete List of 1500+ Common Text Abbreviations & Acronyms

From A3 to ZZZ we list 1,559 SMS, online chat, and text abbreviations to help you translate and understand today's texting lingo. Includes Top...

Windows Operating System History & Versions

The Windows operating system (Windows OS) refers to a family of operating systems developed by Microsoft Corporation. We look at the history of Windows...

How to Create a Website Shortcut on Your Desktop

Website Shortcut on Your Desktop reviewed by Web Webster   This Webopedia guide will show you how to create a website shortcut on your desktop using...

Generations of Computers (1st to 5th)

Reviewed by Web Webster Learn about each of the 5 generations of computers and major technology developments that have led to the computing devices that...

How Does Cryptocurrency Work?

Cryptocurrency is a next-generation financial instrument that uses decentralized networks and...

How to Use the...

The Clone Stamp is a tool in Adobe Photoshop that allows...

How to Overclock Your...

Overclocking means to run a PC’s microprocessor faster than the clock...