XlAutoFillType 枚举 (Excel)XlAutoFillType enumeration (Excel)

根据源区域的内容,指定目标区域的填充方式。Specifies how the target range is to be filled, based on the contents of the source range.

名称Name Value 说明Description
xlFillCopyxlFillCopy 11 将源区域的值和格式复制到目标区域,如有必要可重复执行。Copy the values and formats from the source range to the target range, repeating if necessary.
xlFillDaysxlFillDays 55 将星期中每天的名称从源区域扩展到目标区域中。Extend the names of the days of the week in the source range into the target range. 格式从源区域复制到目标区域,如有必要可重复执行。Formats are copied from the source range to the target range, repeating if necessary.
xlFillDefaultxlFillDefault 00 Excel 确定用于填充目标区域的值和格式。Excel determines the values and formats used to fill the target range.
xlFillFormatsxlFillFormats 第三章3 只将源区域的格式复制到目标区域,如有必要可重复执行。Copy only the formats from the source range to the target range, repeating if necessary.
xlFillMonthsxlFillMonths 7 将月名称从源区域扩展到目标区域中。Extend the names of the months in the source range into the target range. 格式从源区域复制到目标区域,如有必要可重复执行。Formats are copied from the source range to the target range, repeating if necessary.
xlFillSeriesxlFillSeries 双面2 将源区域中的值扩展到目标区域中,形式为系列(如,“1, 2”扩展为“3, 4, 5”)。Extend the values in the source range into the target range as a series (for example, '1, 2' is extended as '3, 4, 5'). 格式从源区域复制到目标区域,如有必要可重复执行。Formats are copied from the source range to the target range, repeating if necessary.
xlFillValuesxlFillValues 44 只将源区域的值复制到目标区域,如有必要可重复执行。Copy only the values from the source range to the target range, repeating if necessary.
xlFillWeekdaysxlFillWeekdays 6 将工作周每天的名称从源区域扩展到目标区域中。Extend the names of the days of the workweek in the source range into the target range. 格式从源区域复制到目标区域,如有必要可重复执行。Formats are copied from the source range to the target range, repeating if necessary.
xlFillYearsxlFillYears utf-88 将年从源区域扩展到目标区域中。Extend the years in the source range into the target range. 格式从源区域复制到目标区域,如有必要可重复执行。Formats are copied from the source range to the target range, repeating if necessary.
xlGrowthTrendxlGrowthTrend 1010 将数值从源区域扩展到目标区域中,假定源区域的数字之间是乘法关系(如,“1, 2,”扩展为“4, 8, 16”,假定每个数字都是前一个数字乘以某个值的结果)。Extend the numeric values from the source range into the target range, assuming that the relationships between the numbers in the source range are multiplicative (for example, '1, 2,' is extended as '4, 8, 16', assuming that each number is a result of multiplying the previous number by some value). 格式从源区域复制到目标区域,如有必要可重复执行。Formats are copied from the source range to the target range, repeating if necessary.
xlLinearTrendxlLinearTrend 9 将数值从源区域扩展到目标区域中,假定数字之间是加法关系(如,“1, 2,”扩展为“3, 4, 5”,假定每个数字都是前一个数字加上某个值的结果)。Extend the numeric values from the source range into the target range, assuming that the relationships between the numbers is additive (for example, '1, 2,' is extended as '3, 4, 5', assuming that each number is a result of adding some value to the previous number). 格式从源区域复制到目标区域,如有必要可重复执行。Formats are copied from the source range to the target range, repeating if necessary.
xlFlashFillxlFlashFill 11x1711 根据之前用户操作的检测模式, 将源区域中的值扩展到目标区域, 如有必要, 请重复执行。Extend the values from the source range into the target range based on the detected pattern of previous user actions, repeating if necessary.

支持和反馈Support and feedback

有关于 Office VBA 或本文档的疑问或反馈?Have questions or feedback about Office VBA or this documentation? 请参阅 Office VBA 支持和反馈,获取有关如何接收支持和提供反馈的指南。Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.