Add table borders to specified cells only. On the Home tab, in the Paragraph group, click Show/Hide. Select the cells that you want, including their end-of-cell marks. Under Table Tools, click the Design tab. In the Table Styles group, click Borders, and then click the border that you want to add.
ROUND: â This function is used for rounding a number to a specified number of digits. For Example:Cell A1 is contains the number 456.25. To round the number, follow below given steps:-. Write the formula in cell B1.
In the Category list, depending on the type of data you have, click Currency, Accounting, Percentage, or Scientific. In the Decimal places box, enter the number of decimal places that you want to display. By using a function in a formula : Round a number to the number of digits you want by using the ROUND function.This function has only two arguments (arguments are pieces of data the formula needs to run).The first argument is the number you want to round, which can be a cell reference or a number.y using a function in a formula : Round a number to the number of digits you want by using the ROUND function. This function has only two arguments (arguments are pieces of data the formula needs to run). The first argument is the number you want to round, which can be a cell reference or a number.