USING MICROSOFT EXCEL
ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Backspace
|
|
|
Format Painter
|
|
|
Clear
|
|
|
Delete
|
Detailed explanation-1: -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-2: -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-3: -There are a few different ways that you can clear formatting in Excel. The easiest way is to simply select the cells that you want to clear, and then press the “Clear Formatting” button on the Home tab of the Excel ribbon. You can also use the keyboard shortcut “Ctrl+Shift+F” to clear formatting.