I use this at the top of the columns just under the heading of each. I learned this trick from Bill Jelen the excel expert. How do I type an underline The quickest way to underline text is to press Ctrl+U and start typing. And for totals, select your cell (s) and click the down arrow next to the underline button on the ribbon, Youll find a choice there for double underline. I used it to trick the eye to see the columns as separate columns. In Excel this is called Accounting Underline. If you have access to excel you can try it. I want it to go almost the length of the cell. To apply a single underline, click Underline. That allows the double underline only under the text or number. 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 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. For example, if a cell is formatted for Accounting, clicking on the Underline button produces the single accounting underlinestretching from the dollar sign to the number, as shown below. 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 apply a single underline, click Underline. Excel treats a number in a cell differently depending on its underlying formatting, and you’re probably not aware the cell is formatted. To underline all text or numbers in a cell or range of cells, select that cell or range of cells.
0 kommentar(er)
