This article was co-authored by How.com.vn staff writer, Rain Kengly. Rain Kengly is a How.com.vn Technology Writer. As a storytelling enthusiast with a penchant for technology, they hope to create long-lasting connections with readers from all around the globe. Rain graduated from San Francisco State University with a BA in Cinema.
This article has been fact-checked, ensuring the accuracy of any cited facts and confirming the authority of its sources.
This article has been viewed 41,358 times.
Learn more...
If you want to make your data easier to read in Excel, you can add borders around the cells. Borders can be applied around each cell or around a chart. This is different from gridlines, which are the light grey lines separating each cell. Here's how to insert borders in Excel using your Windows or Mac computer.
Steps
- Open a worksheet in Microsoft Excel. You can use an existing project or create a new spreadsheet.
- Borders are added manually and can be customized, unlike gridlines. If you have multiple pages of data that you need to print, consider using gridlines instead.
- Select the range of cells you want to add borders to. You will be able to add a border that surrounds the entire selected range, and/or around each individual cell in the range.[1]Advertisement
- Click the Home tab. It's at the top of Excel.
- Click the arrow next to the Borders icon. The Borders icon is a dotted grid on the "Font" panel at the top of Excel. A list of border styles will appear.
- Select a border style. If you want to add darker grid lines surrounding each selected cell, choose All Borders. Otherwise, choose any of the other options, such as Thick Outside Borders, which adds one solid border around the selected range.
- To remove cell borders, select the cells again. Click the arrow next to the Borders icon in the toolbar, and then choose No Border.
- Unlike gridlines, cell borders are always shown on printed sheets.
- Open a worksheet in Microsoft Excel. You can use an existing project or create a new spreadsheet.[2]
- Gridlines can't be customized in the same way borders can.
- Click View. This is the tab at the top.
- If you're using Excel for Mac, click Page Layout instead.
- Locate the "Show" section. This will be between the Workbook Views and Zoom sections.
- You should see a list of options, such as Ruler, Gridlines, Formula Bar, etc.
- Check the box next to "Gridlines". When this box is checked, you'll see the gridlines appear on your Excel worksheet.
- On Mac, check the View box underneath Gridlines. To print the gridlines, check the box for Print.
- Enable gridline printing. Gridlines do not print by default. If you want to print a spreadsheet with the gridlines on, do the following:
- Click the Page layout tab at the top.
- Find the Sheet Options section.
- Check the box next to Print underneath Gridlines.
Expert Q&A
Tips
How.com.vn Video: How to Insert Borders in Excel
References
About This Article
To insert borders in excel, open your excel document and select the cells where you would like to add a border. Click the down arrow next to the Borders button on the Home tab which is located next to the Fonts group button. Then, select the border type from the dropdown menu.
Is this article up to date?
⚠️ Disclaimer:
Content from Wiki How English language website. Text is available under the Creative Commons Attribution-Share Alike License; additional terms may apply.
Wiki How does not encourage the violation of any laws, and cannot be responsible for any violations of such laws, should you link to this domain, or use, reproduce, or republish the information contained herein.
- - A few of these subjects are frequently censored by educational, governmental, corporate, parental and other filtering schemes.
- - Some articles may contain names, images, artworks or descriptions of events that some cultures restrict access to
- - Please note: Wiki How does not give you opinion about the law, or advice about medical. If you need specific advice (for example, medical, legal, financial or risk management), please seek a professional who is licensed or knowledgeable in that area.
- - Readers should not judge the importance of topics based on their coverage on Wiki How, nor think a topic is important just because it is the subject of a Wiki article.