Microsoft Excel XP Tutorial

Using AutoFormats

The AutoFormat feature lets you quickly format a range of cells using one of a variety of built-in formatting combinations. When you add columns or rows to a range that’s been AutoFormatted, the new cells automatically assume the AutoFormat’s properties.

To apply an AutoFormat:

  1. Sub ShowMe() If isIE=”3.0x” Then L_IE3NotSupported_ErrorMessage=”This Help feature is not supported by the 3.0x version of your browser. To use this feature, you need to install a later version of the browser.” L_ShowMe_DialogTitle=”Microsoft Office Help” MsgBox L_IE3NotSupported_ErrorMessage,64,L_ShowMe_DialogTitle Exit Sub Else Call InitConstants() End If On Error Resume Next oua.WndClass=”XLMain” If Err0 Then Msgbox sSecurityMSG,48, L_App_DialogTitle : Exit Sub oua.DelayFactor=0.5 oua.AppActivate() retVal=oua.ShowDialog(786) If retVal0 Then DisplayError(retVal) End Sub Select the cells you want to format.

  1. From the Format menu, select AutoFormat.

The AutoFormat dialog opens.

  1. Scroll through the list to view the available formatting com
    binations. Select a format by clicking on it.
  1. You can choose to use only some of the properties of the selected format by clicking the Options button.

  1. Uncheck any of the properties you don’t want to use.
  2. Click OK.

The formatting is applied to the selected cells.

To remove an AutoFormat, simply select the cells, open the AutoFormat dialog, and select None, located at the end of the list.

Section Review

In this section, you learned:

  • Formatting worksheets
  • Using styles
  • Modifying styles
  • Creating a new style
  • Copying styles from other workbooks
  • Using autoformats


You have completed our free Microsoft Excel XP Foundation tutorial. We hope you enjoyed learning about Microsoft Excel. We offer other free software tutorials you may be interested in. Thanks for learning with us!

One Comment

Leave a Reply

Your email address will not be published. Required fields are marked *