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.
=ROUND(A3,2) This Excel function rounds the value in A3 to the nearest hundredth, or to 2 decimal places. Excel looks at the number to the immediate right of the hundredths position (8) to determine whether to round up or round down. Excel will round up and display 7283.52 in the cell because 8 is greater than 5.