AUTO-FORMATS IN EXCEL

Lesson 33 - Excel AutoFormats. Auto Formatting in Excel. Level 1 Free Training

EXCEL AUTO-FORMATTING

Another very handy feature of Excel is it’s ability to use its built-in AutoFormats on your data, and the flexibility that you have in changing these to suit your personal taste. There are many AutoFormats available to you and they are found under the Home menu bar. Lets have a look at how this would work with our previous Workbook Data Sorting.

You should note that if you select more than one cell before going to format cells, Excel will assume you only want to format the selected cells and not any surrounding data.

The options available to you through this button will be Font, Alignment, Number.

Note however, that by default all options are selected, which means that all current formatting in your selected table or range will be overridden by the AutoFormats. By deselecting certain options, you will have the ability to go back into your range or table and manually apply the format attributes you have unchecked in the Formats to Apply box. However, we suggest only doing this if really necessary.

Apply Excel Styles

Select the cells.

Select Home>Styles and select a style.

Changing Font

Changing Alignment within the cells

Changing the formatting of numbers

Microsoft ® and Microsoft Excel ® are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft