Excel has several AutoFormat features that make formatting decisions based on what you have typed. Excel gives you control over which automatic formatting tools are enabled. Follow these tips to learn which AutoFormat features you would like to utilize in Excel.

Tips, Tricks, and Answers

The following articles are available for the 'AutoFormat' topic. Click the article''s title (shown in bold) to see the associated article.

   Turning Off Hyperlink Activation
Does it bother you when you enter a URL and it becomes "active" as soon as you press Enter? Here's how you can turn off this activation so that your URLs remain as regular text.

This Site

Got a version of Excel that uses the ribbon interface (Excel 2007 or later)? This site is for you! If you use an earlier version of Excel, visit our ExcelTips site focusing on the menu interface.

Newest Tips

FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."

(Your e-mail address is not shared with anyone, ever.)

View the most recent newsletter.