• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

Support Your Tech

Instructions and tutorials to help you get the most from your applications and devices

  • Android
  • Excel
  • Word
  • iPhone
  • Mac
  • Docs
  • Slides
  • Sheets
  • Streaming
You are here: Home / Excel / How to Add Cell Borders in Excel for Office 365

How to Add Cell Borders in Excel for Office 365

July 12, 2019 By Matt Jacobs

When you create a new, blank spreadsheet in Microsoft Excel, and you are using the default settings, you see gridlines that indicate the size of your individual cells. These are effective when you are looking at that sheet on your computer screen, and when you haven’t made any formatting changes.

But as more and more actions are taken on that spreadsheet, you may find that you need some additional indication of the separation of your cells. Fortunately you can achieve this by adding borders to a cell. You can do this the same way for individual cells, or even for the entire spreadsheet.

How to Add Borders to Cells in Excel

The steps in this article were performed in the Excel for Office 365 version of the application, but will also work in other Excel versions after the 2007 version.

Note that borders and gridlines are different things. If you are trying to add borders to your cells when you print, then consider changing the gridline setting on the Page Layout tab instead by checking the box to the left of Print under Gridlines.

Step 1: Open your spreadsheet in Excel.

Step 2: Select the cell(s) to which you wish to apply a border. Note that you can select the entire sheet by clicking the gray button above the row 1 heading and to the left of the column A heading.

select the cells for the borders

Step 3: Click the Home tab at the top of the window, then click the arrow to the right of the Borders button in the Font section of the ribbon.

expand the borders dropdown menu in excel

Step 4: Select the type of border that you wish to apply to the selected cells. If you want to add borders to all sides of your cell, for example, click the All Borders option.

How to add cell borders in Microsoft Excel for Office 365

If you wish to make changes to the style of the borders, you can select the More Borders option from the bottom of the menu in step 4.

open the More Borders menu in Excel

Do some of your cells have row shading that you don’t want, or is no longer useful? Find out how to remove all row shading from a spreadsheet in Excel.

Matt Jacobs

Matt Jacobs has been working as an IT consultant for small businesses since receiving his Master’s degree in 2003. While he still does some consulting work, his primary focus now is on creating technology support content for SupportYourTech.com.

His work can be found on many websites and focuses on topics such as Microsoft Office, Apple devices, Android devices, Photoshop and more.

Share this:

  • Click to share on Twitter (Opens in new window)
  • Click to share on Facebook (Opens in new window)

Related

Primary Sidebar

Recent Posts

  • How to Show Contact Photos in Messages on an iPhone 11
  • How to Sign Out of Spotify on an iPhone
  • How to Flip a Picture in a Microsoft Word Document
  • How to Announce Messages with Siri on an iPhone 11
  • How to Clear Spotify Cache on an iPhone

Featured Posts

How to Delete a City from the Weather App on an iPhone 11

How to Remove Columns in Google Docs

how to delete Spotify podcast download on iPhone

How to Delete Downloaded Podcasts in the Spotify iPhone App

how to strikethrough text in Google Docs

How to Strikethrough Text in Google Docs [Guide]

How to Add a Word Background Image

excel 2013 how to remove formula bar

How to Hide the Formula Bar in Excel 2013

Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy
  • Privacy Policy
  • Affiliate Disclaimer
  • Contact Us
  • About Us

SupportYourTech.com is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.com.

Copyright © 2021 SupportYourTech.com