DATABASE FUNDAMENTALS
USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Use Conditional Formatting > Manage rules
|
|
|
Manually format the cells to override any conditional formatting
|
|
|
Use Conditional Formatting > Clear Rules > Clear Rules from Entire sheet
|
|
|
Use Conditional Formatting > Clear Rules > Clear Rules from Selected Cells
|
Detailed explanation-1: -To remove conditional formatting from specific cells, select the cells, click the Quick Analysis button, and click Clear Format. To remove all conditional formatting from the entire worksheet, click the Conditional Formatting button on the HOME tab, point to Clear Rules, and click Clear Rules from Entire Sheet.
Detailed explanation-2: -In case you want to get rid of all the conditional formatting in the worksheet, you can choose the “Clear Rules from Entire Sheet” option. In the clear rules option, you would also see two additional options – “Clear Rules from This Table” and “Clear Rules from This Pivot Table”.
Detailed explanation-3: -Clear conditional formatting from a selection On the Home tab, click Conditional Formatting. Point to Clear Rules, and then click the option that you want. Tip: To remove all conditional formats and all other cell formats for selected cells, on the Edit menu, point to Clear, and then click Formats.
Detailed explanation-4: -Clear Formatting Highlight the portion of the spreadsheet from which you want to remove formatting. Click the Home tab. Select Clear from the Editing portion of the Home tab. From the drop down menu of the Clear button, select Clear Formats.
Detailed explanation-5: -Point your mouse to the condition that needs to be deleted and click the “Remove” icon. Conditional formatting will be cleared. If you don’t remember the exact cell range you formatted, or if you want to get rid of formats as quickly as possible, then select the cell range and go to the Format menu-Clear formatting.