AutoFormat


show more AutoFormat provides you with in-depth training on Business. Taught by Lorna Daly as part of the Excel 2007 Essential Training show less
please wait ...

AutoFormat

In order to learn about auto formatting, I've opened up a brand-new Excel worksheet, and I'd like you to do the same. Once you have it open, go up to the Office button in the top left and click once. And then select your Excel Options. The screen we're going to look for here is your Proofing options, so click on that once you get the Excel Options dialog box open. And the first thing we're going to look at is the AutoCorrect Options. Under AutoCorrect Options, we're going to concentrate on the first two tabs, AutoCorrect and AutoFormat As You Type.

In AutoCorrect, it will automatically correct any spelling errors that you make. For example, it will correct two initial capitals, it'll automatically capitalize the first letter of sentences, it'll correct the accidental use of Caps Lock key. So these are great things that in older versions of the Excel spreadsheets, you have to go back and fix all your formatting, if you ever ran into any of these issues. As well,...

AutoFormat
Video duration: 3m 36s 5h 13m Beginner

Viewers:

AutoFormat provides you with in-depth training on Business. Taught by Lorna Daly as part of the Excel 2007 Essential Training

Subject:
Business
Software:
Excel
Author:
please wait ...