Written by Allen Wyatt (last updated November 11, 2021)
This tip applies to Excel 97, 2000, 2002, and 2003
Excel allows you to add all sorts of borders to cells in a worksheet. You can place borders on the left, right, top, and bottom of a cell. If you select a range of cells, you can add borders to the left, right, top, bottom, and in between, meaning that the borders could be between cells within the selected range.
Many people don't realize that you can also place diagonal borders. This means that a border can appear from the top-left to the lower-right corners of a cell, or from the top-right to the lower-left. To take advantage of diagonal borders, follow these steps:
Figure 1. The Border tab of the Format Cells dialog box.
Diagonal borders can only be applied to cells, not to rectangular areas you select onscreen. For instance, if you choose cells A5:C12, the diagonal border won't go from the top-left corner of cell A5 to the bottom-right corner of cell C12. Instead, it is applied to the individual cells within the selected range.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (3317) applies to Microsoft Excel 97, 2000, 2002, and 2003. You can find a version of this tip for the ribbon interface of Excel (Excel 2007 and later) here: Adding Diagonal Borders.
Solve Real Business Problems Master business modeling and analysis techniques with Excel and transform data into bottom-line results. This hands-on, scenario-focused guide shows you how to use the latest Excel tools to integrate data from multiple tables. Check out Microsoft Excel 2013 Data Analysis and Business Modeling today!
Excel makes it easy to add all sorts of lines around a cell or range of cells. How easy? This tip demonstrates how to add ...
Discover MoreNeed to get rid of the borders around a cell? The shortcut in this tip can make quick work of this formatting task.
Discover MoreWant a quick way to replace background colors in cells? It's easy to do using Find and Replace, or you can simply use the ...
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
There are currently no comments for this tip. (Be the first to leave your comment—just use the simple form above!)
Got a version of Excel that uses the menu interface (Excel 97, Excel 2000, Excel 2002, or Excel 2003)? This site is for you! If you use a later version of Excel, visit our ExcelTips site focusing on the ribbon interface.
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2025 Sharon Parq Associates, Inc.
Comments