MS Excel 2016: Draw A Border Around A Cell - TechOnTheNet

1. Home
2. MS Excel
3. Cells

MS Excel 2016: Draw a border around a cell

This Excel tutorial explains how to draw a border around a cell in Excel 2016 (with screenshots and step-by-step instructions).

See solution in other versions of Excel:

• Excel 2013
• Excel 2011 for Mac
• Excel 2010
• Excel 2007
• Excel 2003

Question: How do I draw a border around a cell in Microsoft Excel 2016?

Answer: Select the cells that you wish to draw the border around. In this example, we've selected cell B4.

Right-click and then select "Format Cells" from the popup menu.

When the Format Cells window appears, select the Border tab. Next select your line style and the borders that you wish to draw. In this example, we've chosen a thick black line on all 4 sides.

Now when you return to your spreadsheet, you should see the border, as follows:

NEXT: Wrap Text Share on:

Databases

• SQL
• Oracle / PLSQL
• SQL Server
• MySQL
• MariaDB
• PostgreSQL
• SQLite

MS Office

• Excel
• Access
• Word

Web Development

• HTML
• CSS
• JavaScript
• Color Picker

Programming

• C Language

More

• ASCII
• Unicode
• Linux
• UNIX
• Techie Humor

Excel 2016 Basics

• Font
• Font Color
• Font Size
• Background Color
• Format Text
• Border
• Wrap Text
• Align Top
• Center Across
• Merge Cells
• Merge Wrap
• Strikethrough
• Subscript
• Superscript
• Rotate Text
• Format Painter
• Comment Indicator
• Hide Formulas
• Protect Cell
• Validate Max Length
• Validate Numbers
• Validate Exact Length
• Insert Row
• Delete Row
• Row Height
• Hide Row
• Unhide Row
• Unhide Row 1
• Insert Column
• Delete Column
• Column Width
• Hide Column
• Unhide Column
• Unhide Column A
• Unhide Right Columns
• Insert Sheet
• Delete Sheet
• Rename Sheet
• Hide Sheet
• Unhide Sheet
• Create Hyperlink
• Delete Hyperlink
• Copy Range
• Move Range
• Add Named Range

Excel 2016 Pivot Tables

• Create Pivot Table
• Change Data Source
• Refresh Pivot Table
• Remove Col Grand Totals
• Remove Row Grand Totals
• Show Top 10
• Show Bottom 10
• Handle Errors
• Handle Empty Cells
• Hide Value
• Unhide Value
• Hide Blanks
• Change Name

Excel 2016 VBA Environ.

• Introduction
• Open VBA
• Project Explorer
• Properties Window
• Code Window
• Immediate Window
• Watch Window

Excel 2016 VBA Debugging

• Introduction
• Set Breakpoint
• Clear Breakpoint
• Clear All Breakpoints
• Debug Mode
• Check Values
• Immediate Window
• Add Watch
• Move through Code
• Step Into
• Step Over
• Continue
• Halt

Excel 2016 Charts

• Bar Chart
• Column Chart
• Line Chart
• Pie Chart

Home | About Us | Contact Us | Testimonials | Donate

While using this site, you agree to have read and accepted our Terms of Service and Privacy Policy.

Copyright © 2003-2025 TechOnTheNet.com. All rights reserved.