

The selected style will be applied to the text.In our example, we'll make the selected cells bold. Click the Bold ( B), Italic ( I), or Underline ( U) command on the Home tab.Selecting more colors To use the Bold, Italic, and Underline commands: Select More Colors at the bottom of the menu to access additional color options. The text will change to the selected font color.A live preview of the new font color will appear as you hover the mouse over different options. Click the drop-down arrow next to the Font Color command on the Home tab.Modifying the font size To change the font color: You can also use the Increase Font Size and Decrease Font Size commands or enter a custom font size using your keyboard. The text will change to the selected font size.In our example, we will choose 16 to make the text larger. A live preview of the new font size will appear as you hover the mouse over different options. The Font Size drop-down menu will appear. Click the drop-down arrow next to the Font Size command on the Home tab.Along with Calibri, standard reading fonts include Cambria, Times New Roman, and Arial. When creating a workbook in the workplace, you'll want to select a font that is easy to read. The text will change to the selected font.A live preview of the new font will appear as you hover the mouse over different options. Click the drop-down arrow next to the Font command on the Home tab.In the example below, we'll format our title cell to help distinguish it from the rest of the worksheet. However, Excel provides many other fonts you can use to customize your cell text. To change the font:īy default, the font of each new workbook is set to Calibri.
#How to apply the single accounting underline in excel 2013 download#
Optional: Download our practice workbook. You can also apply number formatting to tell Excel exactly what type of data you're using in the workbook, such as percentages (%), currency ($), and so on Basic formatting can customize the look and feel of your workbook, allowing you to draw attention to specific sections and making your content easier to view and understand. 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./en/excel2013/modifying-columns-rows-and-cells/content/ IntroductionĪll cell content uses the same formatting by default, which can make it difficult to read a workbook with a lot of information. 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.
