Internet and network paths with hyperlinks : Replaces typed URLs, network paths, and email addresses with hyperlinks. On the AutoFormat As You Type tab, check the boxes for the auto formatting you want to use. In the Excel Options box, click Proofing > AutoCorrect Options. If you want to review and change automatic formatting options all at once, you can do that in the AutoCorrect dialog box.
Set all automatic formatting options at once For example, if Excel automatically created a hyperlink and you want to prevent Excel from doing that for the rest of the worksheet, click Stop Automatically Creating Hyperlinks. To tell Excel to stop applying this particular type of formatting to your workbook, click Stop.
For example, if Excel automatically created a hyperlink and you want to remove it, click Undo Hyperlink. 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.
0 kommentar(er)
