To remove the formatting for just the text you’ve selected, click Undo. This button is tiny, so look closely as you move the mouse pointer. Move your mouse pointer over the text that was just automatically formatted, and then click the AutoCorrect Options button that appears. In that case, you can turn off automatic formatting for one cell or your whole workbook. This can be really helpful, but there might be times when that’s not what you want. For example, if you type a web address, Excel will turn it into a hyperlink.
Sometimes when you’re entering information into a worksheet, Excel automatically formats it in a way you didn’t intend.
