FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -Press Ctrl + 1 to open the Format Cells dialog box. Or right-click the selected cells, and then click Format Cells in the popup menu. Switch to the Border tab and do the following: From the Line box, choose the desired style for the border line.

Detailed explanation-2: -Click Format. On the Border tab, under Line, in the Style box, click the line style that you want to use for the border. In the Color box, select the color that you want to use. Under Border, click the border buttons to create the border that you want to use.

Detailed explanation-3: -Excel’s predefined conditional formatting, such as Data Bars, Color Scales and Icon Sets, are mainly purposed to format cells based on their own values. If you want to apply conditional formatting based on another cell or format an entire row based on a single cell’s value, then you will need to use formulas.

Detailed explanation-4: -To add a border: Select the cell(s) you want to modify. On the Home tab, click the drop-down arrow next to the Borders command, then select the border style you want to use.