Auto Fill formats in Microsoft Excel: In Excel you can have lists of data. Make sure your list has no blank rows. The goal is to add a format in the top cell of the list and copy this format to the rest of your list. Go to the top row of your list and place your cursor in the top cell. Add the formats you want to use in this cell. Select the bottom right of this cell, and use autofill (double click to fill to the bottom of the list). Then select the smartflag "Auto Fill Options" - choose Fill Fo