How to use the Auto Fill Options button in Excel

When you fill in data based on adjacent cells by dragging the fill handle in Microsoft Excel, theAuto Fill Optionsbutton is displayed just below and to the right of your filled selection. ?? ?? ????? ????Auto Fill Optionsbutton, 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.TheAuto Fill Optionsbutton is also displayed after you select theAutoFill??? ??????????????????? ????? ?? ??????? ?? ??? ?? .. ?????? ?? ???????????????? ????? ???, ???? ?? ?? ????? ????? ????????????, ???? ?? ?? Excel ?? ??????? ?? ??? ??????? ??? ??? ???:

• Microsoft Office Excel 2007 ?? Excel 2010, ????? ????????? ???????? ????? ????, ?? ???? ??????????????????????
• Microsoft Office Excel ??? ?? Excel ?? ????? ????????? ???, ????? ???? ?? ??????????? ??????????????, ?? ???? ???????????.

?????? ?????? (??? ?? ????????) ?????? ??? ??????? ?? ?????? ?? ???? ?? ?????? ?? ?????? ???? ???? ?? ????? ?? ???? ???????????????? ?? ??? ????????? ????????? ?? ???? ?????? ???

????? ??? ?????? ?? ???? ?? ????????? ???? ?? ??? ????? ????????: ??? ????????? ??? The list of options varies according to the type of data: text and formulas, numbers, months, days of the week, and dates. The full list of options that may be available is as follows:The same eight options are also included on the shortcut menu that appears when you right-click and drag the fill handle to adjacent cells. TheAuto Fill Optionsbutton is not displayed when you use this method.

??????? ??? ?? ??????? ???????? ?? ????? ???? ???? ?? ???? ??? ???? ??????? ?? ??? Microsoft ???????? ??? ???? ????? ?? ??? ????? ???? ?????? ?? ????? ????: