The easiest way to make Excel data more readable is to convert the data into a Table object ( Figure A).įigure A An Excel Table applies formatting to improve readability.
#DOUBLE UNDERLINE IN EXCEL NOT BORDER HOW TO#
SEE: Software Installation Policy (TechRepublic Premium) How to convert Excel data into a Table object Excel for the web will display the conditional format, but you can’t apply a formatting rule yet. For your convenience, you can download the demonstration. I’m using Microsoft 365 on a Windows 10 64-bit system, but you can use earlier versions through 2007. I’ll show you how to use a conditional formatting rule in Excel to apply a brightly colored border line to divide groups. Table objects automatically apply alternating colors from one row to the next, which is great for keeping your eye on a specific record, but if you’re working with grouped Excel data, the alternating lines aren’t particularly helpful. For more info, visit our Terms of Use page.Ī large set of Microsoft Excel data without good formatting is difficult to read. This may influence how and where their products appear on our site, but vendors cannot pay to influence the content of our reviews. We may be compensated by vendors who appear on this page through methods such as affiliate links or sponsored partnerships. Learn how to make your Excel tables easier to read. If your data is grouped in Microsoft Excel, try displaying a border between groups. How to use a border to discern groups more easily in Microsoft Excel
0 kommentar(er)
