Auto Fill Options button, a list of options appears that allows you to choose to fill the cells with text or data, and whether or not to include the format of the initial selection or to copy only the format.
Series dialog box. To show the Series dialog box, use one of the following procedures, as appropriate for the version of Excel that you are running:
- In Microsoft Office Excel 2007 and Excel 2010, click the Home tab, and then click Fill in the Editing group.
- In Microsoft Office Excel 2003 and in earlier versions of Excel, point to Fill on the
Edit menu, and then click Series.
Fill Formatting Only
Fill Without Formatting