by Allen Wyatt
(last updated April 3, 2021)
Steve can use the Border tab on the Format Cells dialog box to set a border around some cells. He would like to make a heavier border than what the Border tab allows, however. In the past he has inserted extra columns and/or rows and filled them with black to make a heavy border. In this case, however, Steve can't add extra rows/columns without messing up some calculations. He's wondering if there is a way to add a very heavy border of which he's not aware.
The Border tab of the Format Cells dialog box offers three thicknesses for a solid border. If the thickest border on the tab is not thick enough for your needs, then the simplest option would be to add a rectangle shape to your worksheet and position it over the cell, as desired. You can add the shape by displaying the Insert tab of the ribbon and then, from the Shapes tool, choose the rectangle shape. You can then click and drag to "draw" the rectangle in the worksheet.
A handy way to get the rectangle the size you want is to hold down the Alt key as you click and drag. This snaps the rectangle to the corners of the cell (or range of cells) over which you drag. Once placed, you can click on the rectangle and format it. You'll want to make sure that the fill color is set to "None" and that the outline width is set as heavy as you desire.
Finally, it is a good idea to set the properties of the shape so that the "Move and Size with Cells" option is selected. This allows your hand-crafted border to adjust to most changes that may affect the location and size of the cell to which you've attached it.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (13843) applies to Microsoft Excel 2007, 2010, 2013, 2016, 2019, and Excel in Office 365.
Excel Smarts for Beginners! Featuring the friendly and trusted For Dummies style, this popular guide shows beginners how to get up and running with Excel while also helping more experienced users get comfortable with the newest features. Check out Excel 2013 For Dummies today!
Drawing objects can be layered over each other in almost any manner you desire. If you want to change the order in which ...Discover More
Not only can you place drawing objects in your worksheets, but you can organize those objects so some are in front and ...Discover More
Want to fill a drawing object with different types of effects? Excel provides several effects that can make your drawing ...Discover More
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Got a version of Excel that uses the ribbon interface (Excel 2007 or later)? This site is for you! If you use an earlier version of Excel, visit our ExcelTips site focusing on the menu interface.