{"id":208,"date":"2017-02-24T11:00:35","date_gmt":"2017-02-24T17:00:35","guid":{"rendered":"http:\/\/www.iqaccountingsolutions.com\/blog\/?p=208"},"modified":"2017-03-10T16:25:28","modified_gmt":"2017-03-10T22:25:28","slug":"using-underline-for-headings-and-totals-instead-of-cell-borders","status":"publish","type":"post","link":"https:\/\/www.iqaccountingsolutions.com\/blog\/using-underline-for-headings-and-totals-instead-of-cell-borders\/","title":{"rendered":"Using Underline for Headings and Totals instead of Cell Borders"},"content":{"rendered":"

Today\u2019s Excel tip is very simple, but it can save a lot of time when formatting a spreadsheet.\u00a0 Most people that I\u2019ve shown this to are just as surprised as I was when someone first showed me.\u00a0 Putting a bottom border on a row of cells can be a good choice for column headings on a spreadsheet.\u00a0 But for totals or subtotals, many people don’t like the continuous line that it creates; they would prefer a separate underline in each column. A common solution is to have very narrow empty columns between the columns of data.\u00a0 But that is tedious to set up and interferes with using the ctrl+arrow<\/em>\u00a0 or End+arrow<\/em> keyboard shortcuts.\u00a0 You could format the text in the headings to be underlined, but then the line will only be as wide as the text or numbers in the cell.\u00a0 Or will it?\u00a0 If you first format cells with either the comma<\/em> format or the accounting<\/em> format and then format the text as underlined, the underline will extend almost the entire width of the column. (If you underline first, it won\u2019t work.) In Excel this is called Accounting Underline.\u00a0 And for totals, select your cell(s) and click the down arrow next to the underline button on the ribbon, You’ll find a choice there for double underline.<\/p>\n