#DOUBLE UNDERLINE IN EXCEL FOR MAC HOW TO#

'Is Payroll giving you a headache? I am here to take the confusion out of payroll and make it simple for you.' -Heayther Cooper 'Have questions about your account or statement? My focus is customer service and helping clients execute investment transactions.' -Bethany LeViere 'Does your CPA speak your language? I enjoy solving accounting problems and helping my clients understand the processes they need to minimize such problems.' Reference: Journal of accountancy JANUARY 2013 BY J. While these steps may also be tiresome, this approach eliminates blank columns, making it easier to navigate using the End+Arrow Keys combinations, and to eliminates the possibility of entering numbers in columns that canвЂ™t be seen. These steps will produce the desired format in adjacent columns, as pictured below. Note:В This step may sound strange, but you must format the header text using the accounting format in order for the size of the underlines below the headers to match the underlines in the numeric data. To correct this problem, highlight the header row, right-click anywhere on the highlighted range, select Format Cells, and on the NumberВ tab, select the AccountingВ format from the CategoryВ list box. Control text underlines.В Notice in the image at the bottom of the previous column that the header underlines are larger than the numeric underlines. Remove unwanted dollar signs (optional).В Highlight the numerical data where you want to suppress the dollar signs, right-click anywhere on the highlighted range, select Format CellsВ from the pop-up menu, and then on the NumberВ tab, select NoneВ from the SymbolВ box and click OK.ДҐ. ( Note:В After applying the accounting format, not only do commas and dollar signs appear, but the single and double accounting underlines will also resize to match.)Д¤. Next, on the NumberВ tab, select AccountingВ from the CategoryВ list box, set the Decimal placesВ spinner to 0, select the dollar symbol ( $) in the SymbolВ dropdown box, and click OK. Format the numerical data.В Highlight the numerical data, right-click anywhere on the highlighted range, and select Format CellsВ from the pop-up menu. Next, on the FontВ tab, select Single AccountingВ from the UnderlineВ dropdown box, then click OK.ДЈ. Add single underlines.В Highlight both the header row and the row above the total row (hold the Ctrl key down to select multiple ranges), right-click anywhere on the highlighted range, and then select Format CellsВ from the pop-up menu. Add double underlines.В Highlight the total row, right -click on the row, select Format Cells from the pop-up menu, and then on the FontВ tab, select Double AccountingВ from the Underline dropdown box, then click OK.Дў. Below are the five steps needed to apply this formatting:ДЎ. ExcelвЂ™s Accounting FormatВ was designed for accountants, and it allows you to insert nontouching single and double underlines in adjacent columns.

In excel there is a way to format cells with single and double underlines that donвЂ™t extend all the way to the edges of the cell, but extend past the text, eliminating the need to insert thin columns to create the space.

#DOUBLE UNDERLINE IN EXCEL FOR MAC HOW TO#

Carlton Collins, CPA, discusses how to underline entries on an excel worksheet that donвЂ™t extend all the way to the edges of the cell. To apply a different style of underline, such as a double underline or a single or double accounting underline (an underline that fills the width of a cell), click the Dialog Box Launcher next to Font and then, in the Underline box, click the style that you want to use.I found a great article in the January 2013 edition of the Journal of Accountancy that introduced a really useful feature to me. To apply a single underline, click Underline. On the Home tab, in the Font group, do one of the following: You can also press F2 to edit the active cell, use the arrow keys to place the insertion point, and then use SHIFT+arrow keys to select the contents. If editing in a cell is turned off, you can click the cell and then select the text or numbers that you want to underline in the formula bar. If editing in a cell is turned on, you can select the cell contents by double-clicking the cell. To underline just a portion of the contents in a cell, double-click that cell, and then select the text or numbers that you want to underline. To underline all text or numbers in a cell or range of cells, select that cell or range of cells.

Double underline in excel for mac