Select column. Go to Home tab. Under Styles section choose Conditional Formatting.

To remove paragraph marks go to Home tab. Under paragraph section click on show/hide paragraph marks icon.
First select the cells or just one cell depending on whether there’s a specific area you wish to clear from rules or you wish for the whole sheet to be free from formatting rules. Next go under Home tab into Styles section and click on the first button from the row called “Conditional Formatting”. From the down-appearing menu click on “Clear Rules” and “Clear Rules from Selected Cells” or “Clear Rules from Entire Sheet” depending on your preference.
Continue readingFirst make sure you have selected the appropriate slide from the Slides menu on the left. Go under Home tab into Slides section and click on “Reset”. It turns the position, size and formatting of the placeholders into their default settings.
Continue readingYou should copy and special paste only the values of the range and afterwards simply delete the cells you just copied into another location. The reason for using copy instead of cut is because Paste Special is not applicable in case of cutting.
Continue readingOn the ribbon under Home tab in Font section there’s a button at the top right corner called “Clear Formatting”. Select your text and click it to clear all formatting and have a Normal plain text.
Continue readingClick the File tab and Click Options. Click on Proofing. Under AutoCorrect Options, click AutoCorrect Options. Choose the AutoFormat As You Type tab. Clear the check boxes for the options that you want to disable.
Continue reading