We wanted negative numbers to appear with the minus (-) sign before them. We wanted to use the American dollar symbol. We wanted two numbers to appear after the decimal point. We chose Currency from the Category column. In the dialogue box above, you can choose the type of number formatting that you want from the Category column.В An explanation of how the formatting is used appears at the bottom of the dialogue box when you click on a specific type of number formatting. You will then see the Format Cells dialogue box.В Click on the Number tab. You can also to the Home tab, go to the Number group, then click on the arrow in the bottom right corner. You can apply a number format to a cell by selecting the cell(s) that you want to format, right clicking, and selecting Format Cells and select the Number tab. Yet, if we click on a cell in the Formula Bar, the number is displayed as a general number.

Interested in learning more? Why not take an online Excel 2021 course? You can change the appearance of numbers in MS Excel 2016 without changing the value behind those numbers.В The actual value is always displayed in the Formula Bar.ДЇor example, we can have a numbers formatted as currency in the worksheet: Go to the Alignment group under the Home tab, then click Merge and Center.ДЄpply Number Formats and Create Custo m Number Formats To merge cells, first select the cells to be merged. Note: It's important to remember that the cells you merge must be adjacent.В In addition, the cells that you merge cannot be active or the Merge and Center feature will not work. When you merge cells, the information in the upper left cell is centered in the merged cell.В If the content you want in the merged cells is not in the upper left cell, then you must copy and paste the data into the upper left cell. Merging cells simply means that you merge a group of cells into one cell.В It is not the same as combining cells because when you combine cells, the data in those cells is also combined. By default, your text in Excel 2016 appears in a black font.В If you want to change the font color, look for the uppercase A with a colored bar under it in the Font group under the Home tab. You can also choose to add a line color or a line style for the border you draw.В We're going to choose Line Color from the dropdown menu, and choose the color red.В Once again, you can click the border of a cell to add a border.В You can also drag your mouse over cells to add a border.Д¬hanging the font color is as easy to do as changing the font. We are going to drag our mouse over column C. When you draw a border, your mouse cursor turns into a pencil.В You can click the border of a cell to add a border.В You can also drag your mouse over cells to add a border. Select Draw Border from the dropdown menu. Let's do something a little different now.В Instead of applying a border, we're going to go to the Draw Borders section of the dropdown menu.В We're going to draw borders. Since we selected a range of cells, the border is applied to the entire range, not the individual cells. Next, we go to the Ribbon and click the Borders button. We want to apply borders to the cells in column A.ДЄs you can see below, we've selected the cells. You can also change the line color of the border and the border style (such as dashed or solid lines) by going to the Draw Borders section of the dropdown menu. Simply select where you want to border to appear and what kind of border you want.В Keep in mind that the border you choose will be applied to a single selected cell or to a range of selected cells. When you click on the Border button, you will see this dropdown menu: You can also add borders to cells or a range of cells by selecting the cell(s) you want to add border to, then by clicking Border button in the Font group under the Home tab. Once you select the font, the selected data will be changed to the new font. Go to the Font group, and you'll see the type of font that you're currently using.В It appears in a box with a downward arrow beside it on the left hand side of the toolbar.В In our example, and on our toolbar, it's Calibri.Д¬lick on the downward arrow to the right font type and select a new font. Next, select the data in the worksheet for which you want to change the font.В We've selected column A in the snapshot below. To change the font type and size, go to Font group under the Home tab. However, we can change that to another font and another size. In the snapshot below, we've used Calibri, size 11 font. Font is defined as the style of your type.В Times New Roman, Courier, and Arial are probably three of the most popular fonts, but there are literally hundreds.В When you create a worksheet, you can decide what type of font you want to use.В You can also decide the size of the font.

Shadow underline in excel