Dhibaato ka haysataa inaadan arkin batoonka Buuxinta otomaatiga^{(Auto Fill)} ah markaad hoos u jiidayso gacanta buuxinta? Waxaan ku tusineynaa sida loo sahlo buuxinta otomaatiga^{(Auto Fill)} ah ee Microsoft Excel .

Ikhtiyaarada buuxinta otomaatiga^{(Auto Fill)} ah ee aan ka muuqan Excel

Auto Buuxinta^{(Auto Fill)} waa sifo ku jirta Excel oo ka buuxisa unugyo xog raacaysa isku xigxig oo abuura tirooyin tirooyin, taariikho, iyo maalmo si loo habeeyo hal unug ilaa unugyada ku xiga. Badhanka Auto Buuxinta^{(Auto Fill)} ayaa leh doorashooyin sida:

• Nuqul ka mid ah Unugyada^{(Copy Cells)} : Doorashadani waxay koobiyaysaa xogtii hore ee tiirka ama safka marka la jiid jiido ama la gooyo.
• Buuxinta Taxanaha^{(Fill Series)} : Doorashadani waxay u oggolaanaysaa xogta inay raacdo isku xigxig marka la jiid jiido ama la jarayo.
• Buuxi Qaabaynta Kaliya^{(Fill Formatting Only)} : marka la doorto, Doorashadani waxay ka baxaysaa qaabaynta sida ay tahay.
• Buuxi Aan Qaab La'aan^{(Fill Without  Formatting)} : Marka Buuxi La'aanta Qaabaynta^{(Fill Without Formatting)} la doorto, waxay ilaalin doontaa qiimaha laakiin ma samaynayso; tusaale ahaan, haddii qiimuhu buluug yahay, buuxinta la'aanta qaabaynta^{(Fill Without Formatting)} doorashada ma ilaalin doonto.
• Buuxinta Maalmo^{(Fill Days)} : Marka xulashada Maalmo^{(Fill Days)} Buuxineed la doorto, waxay ogolaataa isku xigxiga maalmaha.
• Buuxi maalmaha shaqada^{(Fill Weekdays)} : Marka qaabka maalinta shaqada^{(Fill Weekday)} la doorto, waxa ay ogolanaysaa isku xigxiga maalmaha shaqada.
• Buuxinta Flash^{(Flash Fill)} : Marka Flash Fill la doorto, waxay si toos ah u buuxinaysaa xogtaada marka ay dareemeyso qaab.

Sida loo suurtageliyo Auto Buuxinta Excel

Guji File .

On the Backstage View , guji Options .

Sanduuqa wada hadalka Options Excel^{(Excel Options)} ayaa soo muuqan doona.

Gudaha sanduuqa wada hadalka Options Excel^{(Excel Options)} ee dhinaca bidix, dooro Advanced .

Bogga sare^(Advanced) ee qaybta Cut Copy and Paste , dhagsii sanduuqa calaamadaynta badhanka Muuji paste Options marka nuxurka la dhejiyo^{(the Show paste Options button when content is pasted)} .

Kadib dhagsii OK .

Ogeysiis^(Notice) , xaashidaada shaqada ee Excel, waxaad arki doontaa badhanka Buuxinta^{(Auto Fill)} Automatic marka aad hoos u jiiddo gacanta buuxinta.

Waxaan rajeyneynaa in casharkan uu kaa caawinayo inaad fahamto sida loo hagaajiyo ikhtiyaarka Auto Buuxinta maqan ee ^{(Auto Fill)}Excel ; haddii aad wax su'aalo ah ka qabto casharrada, noogu soo sheeg faallooyinka.

Akhri soo socda^{(Read next)} : Sida loo xisaabiyo celceliska dhaqdhaqaaqa Excel^{(calculate Moving Averages in Excel)} .

Auto Fill options not showing in Excel; How to enable it?

Having trouble not seeing the Auto Fill button when dragging the fill handle down? We show you how to enable Auto Fill in Microsoft Excel.

Auto Fill options not showing in Excel

Auto Fill is a feature in Excel that fills cells with data that follows a sequence and creates a string of numbers, dates, and days to apply formatting from one cell to adjacent cells. The Auto Fill button has options such as:

• Copy Cells: This option copies the previous data within the column or row when dragging down or across.
• Fill Series: This option allows data to follow a sequence when dragging down or across.
• Fill Formatting Only: when selected, This option leaves the formatting as it is.
• Fill Without  Formatting: When Fill Without Formatting is selected, it will keep the value but no formatting; for instance, if the value is blue, the Fill Without Formatting option will not preserve it.
• Fill Days:  When the Fill Days option is selected, it allows the sequence of days.
• Fill Weekdays: When the Fill Weekday feature is selected, it allows the sequence of weekdays.
• Flash Fill: When Flash Fill is selected, it automatically fills your data when it senses a pattern.

How to enable Auto Fill in Excel

Click File.

On The Backstage View, click Options.

An Excel Options dialog box will appear.

Inside the Excel Options dialog box on the left pane, select Advanced.

On the Advanced page in the Cut Copy and Paste section, click the check box for the Show paste Options button when content is pasted.

Then click OK.

Notice, on your excel worksheet, you will see the Auto Fill button when you drag the fill handle down.

We hope this tutorial helps you understand how to fix the missing Auto Fill option in Excel; if you have questions about the tutorial, let us know in the comments.

Read next: How to calculate Moving Averages in Excel.

Related posts

• Sida loo isticmaalo Flash Fill ee Excel

• Sida loo isticmaalo Percentile.Exc function gudaha Excel

• Sida loo isticmaalo shaqada NETWORKDAYS gudaha Excel

• Sida loo tiriyo lambarka Haa ama Maya ee Excel

• Excel, Word ama PowerPoint ma bilaabi karaan markii ugu dambeysay

• Sida loo geliyo shaxda firfircoon ee xaashida Excel

• Microsoft Excel waxay isku dayaysaa inay soo ceshato macluumaadkaaga

• Microsoft Excel waxay sababtaa isticmaalka CPU sare marka uu socdo Windows 10

• Sida loogu isticmaalo DEC2Bin gudaha Excel si loogu beddelo nambarka jajab tobanle ee binary

• Sida loo isticmaalo shaqada DGET gudaha Excel

• Sida loo isticmaalo INT iyo Functions LCM gudaha Excel

• Khaladka Run-time 1004, Ma socodsiin karo Macro gudaha Excel

• Sida loo qoro, loo dhiso, loona isticmaalo shaqada VLOOKUP gudaha Excel

• Sida loo beddelo qaabka faylka caadiga ah ee lagu kaydiyo Word, Excel, PowerPoint

• Sida loo isticmaalo shaqada DISC gudaha Excel

• Sida looga soo saaro magacyada domain URL-yada Microsoft Excel

• Sida loo isticmaalo shaqada COOSE ee Excel

• Sida loo joojiyo ama loo damiyo Wadaagista Buuga Shaqada ee Excel

• Xisaabi leexashada caadiga ah iyo khaladka caadiga ah ee macnaha Excel

• Sida loo beddelo midabka warqadda shaqada ee Excel