Apply borders to cells
To apply borders for cells:
1. Select the cell(s). Click the Borders icon from the toolbar.
2. You can choose from a range of border types that are available . These are the types that you can choose from :
You can also choose from the various border line styles and colors from the same drop down.
Related Articles
Customize borders
To apply borders with customized colors and line styles: 1. Click on the border icon on the tool bar. 2. In the drop down displayed, select the desired color, line style and the required border option to be applied. The customization can also be ...Change the format of cells
To apply formatting that suits you: Choose Format > Format Cells. The Format Cells dialog box appears. Select the format in which you want the cells to be in. You can also create customized cell formats. Click OK to apply the format. Alternatively, ...Apply Filter
To apply filter: 1. Select the column or range of cells to be filtered. 2. Click Data> Filter or use the Filter icon from Toolbar or right click on the selected range and select Filter from the context menu. 3. Choose the required filtering ...Apply classic conditional formats
To apply single-color/classic conditional formatting, 1. Click on the Format menu. 2. Select the Conditional Formatting option. 3. Click on Classic from the drop down. 4. Once the Conditional Formatting window appears, select the range of cells you ...Apply array formulas
To apply array formulas: Select the cells in which you want the resultant array (the result of the output formula) to be present. Type the array formula you wish to apply over the array. Like other formulas, an array formula is preceded by an ...