Hold down the Ctrl key while pressing "b" (Ctrl-b). Click again on the Underline icon if you wish to remove the underline.Īlternate Method: Adding Bold, Underline, and Italic by Using IconsĪlternate Method: Adding Bold by Using Shortcut Keys. Click on the Underline icon, which is on the Formatting toolbar. 
Click again on the Italic icon if you wish to remove the italics.Īlternate Method: Adding Underline by Using the Icon. Click on the Italic icon, which is on the Formatting toolbar. Click again on the Bold icon if you wish to remove the bolding.Īlternate Method: Adding Italic by Using the Icon. Click on the Bold icon, which is on the Formatting toolbar. Then click on None.Īlternate Method: Adding Bold by Using the Icon Click to open the drop-down menu associated with the Underline field. Click on Regular in the Font style box. Removing Bolding and Italics by Using the Menu The words "All three" are now bolded, italicized, and underlined. Click on Bold Italic in the Font Style box. The cell entry now has a double accounting underline.Īdding Bold, Underline, and Italic by Using the Menu The cell entry now has a single accounting underline. The cell entry now has a double underline. 
Click on the check mark located on the Formula bar. The cell entry now has a single underline. Click to open the drop-down menu associated with the Underline box. The exercise that follows illustrates some of them. Microsoft Excel provides several types on underlines. Clicking on the check mark is similar to pressing Enter. You will learn to bold, italicize, and underline by using the menu, the icons, and the shortcut keys. In the exercises that follow, you will learn three different methods for bolding, italicizing, or underlining text in Microsoft Excel. You can also combine these features - in other words, you can bold, underline, and italicize a single piece of text. You can bold, underline, or italicize text in Microsoft Excel. The red circle designates the Align Left icon. Click on the Align Left icon, which is located on the Formatting toolbar. You can left-align the name "Cathy" by following these steps: The red circle designates the Align Right icon. Click on the Align Right icon, which is located on the Formatting toolbar. You can right-align the name "Cathy" by following these steps: The red circle designates the Align Center icon. Click on the Center icon, which is located on the Formatting toolbar. To center the name "Cathy," follow these steps: You can use the Formatting toolbar to change alignment. Using the Formatting toolbar, you can quickly perform tasks. The name "Cathy" is left-aligned.Īlternate Method: Alignment by Using the Formatting Toolbar After the drop-down box is opened, click on Left (Indent). Click to open the drop-down box associated with the Horizontal field. To left-align the name "Cathy," follow these steps: After the drop-down box is opened, click on Right (Indent). 
To right-align the name "Cathy," follow these steps: After the drop-down box is opened, click on Center. To center the name Cathy, follow these steps: The name "Cathy" is aligned with the left side of the cell.
The width of every cell on the worksheet should now be set to 25.
Type 25 in the Standard Column Width field. Choose Format > Column > Standard Width from the menu. You need to change the standard column width to complete your exercises. This width is called the standard column width. When you open Microsoft Excel, the width of each cell is set to a default width. If there is no check mark in the Normal Font box, click to place a check mark there. To set your font to Arial, Regular, and Size 10: For the exercises in this lesson, you want your font to be set to Arial, Regular, and Size 10. The default font is the style of typeface that Excel will use unless you specify a different style. Microsoft Excel enables you to choose a default font. To start, open a blank Microsoft Excel workbook. #UNDERLINE IN EXCEL HOW TO#
In this lesson, you are going to learn how to format text and perform basic mathematical calculations. Lesson 2: Formatting Text and Performing Mathematical Calculations
0 kommentar(er)
