USING MICROSOFT EXCEL
ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Select the cells
|
|
|
Click Conditional Formatting
|
|
|
Sort the Cells
|
|
|
Press the Spacebar
|
Detailed explanation-1: -Click on the cell that has the conditional formatting you want to copy. Click Home > Format Painter. To paste the conditional formatting, drag the paintbrush across the cells or ranges of cells you want to format.
Detailed explanation-2: -They are grouped into three categories: Data Bars are horizontal bars added to each cell, much like a bar graph. Color Scales change the color of each cell based on its value. Each color scale uses a two-or three-color gradient.
Detailed explanation-3: -On the Home tab, click Conditional Formatting > New Rule. In the Style box, click Classic. Under the Classic box, click to select Format only top or bottom ranked values, and change it to Use a formula to determine which cells to format.