Excel 2016 Introduction

Excel 2016

Lesson – Working with Ranges

The default Auto Fill option is the Fill Series option. Other options include: Copy Cells , which copies the first cell into the selected range instead of filling it; Fill Formatting Only , which copies the formatting only from the first cell without the contents; and Fill Without Formatting , which excludes the formatting of the first cell when filling the range. Other options may appear depending upon the entry in the first cell.

Use Auto Fill options

NOTE If Excel does not recognize the entry in the first cell as part of a standard series, the cell contents are copied into the range instead. The Auto Fill Options button automatically disappears when you perform another action, such as entering data into another cell or saving the workbook.

OFFICEPRO, Inc.

Page 93