Haddii shaqadaadu kaaga baahan tahay inaad si dhab ah ugu noolaato xaashida Excel , waxaa laga yaabaa inaad raadinayso siyaabo aad uga dhigto hawlaha soo noqnoqda. Tusaale ahaan, mar kasta oo aad la shaqeyso xogta u baahan in si joogto ah loo cusboonaysiiyo, waxaad u baahan doontaa in aad ku darto safaf badan. 

Hagahan, waxaan kuugu sheegi doonaa sida loo geli karo safaf badan gudaha Excel dhowr tillaabo oo degdeg ah oo fudud. Dooro mid adiga kugu habboon

Sida Loo Geliyo Safaf Badan Adoo^{(Insert Multiple Rows)} Jiidaya Xulashada Xuduudka^(Border)

Tani waa habka ugu dhakhsiyaha badan ee loo geli karo safaf badan oo maran xaashidaada Excel . Way fududahay oo uma baahna isticmaalka furaha kiiboodhka^{(keyboard shortcuts)} midkoodna. 

1. Dooro safka hoose ama ka sarreeya oo aad rabto inaad geliso safaf maran. 
2. Ku dul rog tilmaantaada^(Hover) dhinaca xulashada xadka. 
3. Riix Shift oo waxaad arki doontaa tilmaamayaasha oo isu beddelaya bar leh fallaadho kor iyo hoos. Hoos u jiid xulashada tirada saf ee aad rabto inaad ku darto.

Sida Loo Geliyo Safaf Badan Adoo Isticmaala Hab-gaabyada Keyboard-ka ee Excel^{(Insert Multiple Rows Using Excel Keyboard Shortcuts)}

Haddii aadan jeclayn fikradda dhowr jeer oo midig-gujis ah^{(multiple right-clicks)} markaad ka shaqaynayso xaashida Excel , waxaa jira laba kiibood oo gaaban oo aad isticmaali karto.

Marka hore, dooro tirada safafka oo le'eg tirada safafka maran ee aad rabto inaad gasho. Isticmaal Shift + Space si aad u dooratid dhammaan tiirarka safafka la doortay ama dooro safafka adigoo isticmaalaya nambarada safafka ee bidixda. 

Ka dib isticmaal mid ka mid ah labada gaaban:

1. Alt + I and Alt + R : Riix Alt + I, sii wad furaha Alt , oo tabo R.
2. Ctrl + Plus : Waxaad u baahan tahay inaad isticmaasho calaamadda lagu daray ee suufka nambarada. Haddii aad rabto inaad isticmaasho calaamadda lagu daray furaha furaha, isticmaal Ctrl + Shift + Plus .

Habka gaaban ayaa sidoo kale la miisaami karaa. Ku dhajinta F4 xaashida ^(F4)Excel waxay soo celisaa falkii hore. Waxaad isticmaali kartaa mid ka mid ah hababka gaagaaban ee kore si aad ugu darto, tusaale ahaan, 10 saf oo dabadeed riix F4 10 jeer si aad ugu darto 100 saf maran.

Sida Loo Geliyo Safyo Badan Oo La Koobiyeeyay Iyagoo Isticmaalaya Jidadka Gaaban ee Kiiboodhka^{(Insert Multiple Copied Rows Using Keyboard Shortcuts)}

Haddii aad rabto inaad nuqul ka sameyso ama jarto safaf badan halkii aad ku dari lahayd safaf banaan, isticmaal Alt + I + E gaaban.

1. Ku bilow inaad koobiyayso ama jarto safafka.
2. Dooro safka kore^(above) oo aad rabto inaad ku dhejiso safafka adigoo riixaya lambarka safka ee bidixda.
3. Taabo Alt + I + E oo dooro Shift cells hoos^{(Shift cells down)} .

Waxa kale oo aad isticmaali kartaa furayaasha soo socda halkii aad ka isticmaali lahayd Alt + I + E (habku waa isku mid iyadoon loo eegin nooca gaaban ee aad isticmaasho):

• Ctrl + Shift + =
• Control + Plus (calaamad lagu daray waa inay ka timaadaa furaha lambarka)

Sida Loo Geliyo Safaf Badan Adoo^{(Insert Multiple Rows)} Isticmaalaya Xulashada Gelida^{(Insert Option)}

Si aad u isticmaasho habkan, waxa kaliya ee aad u baahan tahay inaad sameyso waa inaad doorataa tirada saf ee aad rabto inaad ku darto, midig-guji xulashada, oo dooro Gelida^(Insert) .

Haddii aad xogtaada ku hayso tiirar badan, taabo Shift + Space si aad u doorato dhammaan tiirarka safafka la doortay, ama dooro safafka adiga oo isticmaalaya nambarada safafka ee bidix ee xaashida shaqada.

Markaad doorato Gelida^(Insert) , Excel wuxuu gelin doonaa safafka ka sarreeya safka koowaad ee aad dooratay.

Haddii aad rabto inaad geliso tiro ka badan oo saf maran ah, waxaad dooran kartaa qayb ka dibna isticmaal ikhtiyaarka Gelida . ^(Insert)Tusaale ahaan, waxaad sheegtaa inaad rabto inaad gasho 500 saf.

1. Dooro kala duwan oo qaabka 'bilawga safka: safka ugu dambeeya'. Haddii aad u malaynayso inaad rabto inaad gasho 500 saf ka dib safka 5, dooro kala duwanaanshaha 5:504 adiga oo gelaya xadkan sanduuqa magaca gacanta.

1. Midig ku dhufo oo dooro Geli^(Insert) .

Sida Loo Geliyo Safaf Badan Adoo^{(Insert Multiple Rows)} Adeegsanaya Macro Excel^{(Excel Macro)}

Haddii aad ku shaqaynayso xog-ururin weyn oo xaashida shaqada ah oo aad filayso inaad si joogto ah u isticmaasho, waxaad si otomaatig ah uga dhigi kartaa gelista safka adoo isticmaalaya Macros . Uma baahnid inaad khabiir noqoto, inkastoo ogaanshaha aasaaska VBA^{(basics of VBA)} ay ku siin karto awood badan inta aad isticmaaleyso Excel .

Kahor intaadan bilaabin habka, hubi haddii xargaha sare ee Excel uu leeyahay tab la yiraahdo ^(Excel)Developer . Haddii aysan taasi dhicin, tag Files > Options > Customize Ribbon oo hubi badhanka raadiyaha ee ag yaal horumariyaha^(Developer) .

1. U gudub tab horumariyaha^(Developer) oo dooro Visual Basic .

1. Raadi liiska Gelida^(Insert) marka uu furmo Visual Basic Editor oo dooro Module .

1. Geli summada^(Enter) soo socota tafatiraha:

Sub InsertRowsAtCursor()
Answer = InputBox(^(Rows) "Immisa saf ayaa la geliyaa? ( ugu badnaan 100 saf)") NumLines^(Rows)
= Int(Val(Jawaab))

    Haddii NumLines> 100 ka dibna
NumLines = 100
Dhammaad Haddii

    Haddi NumLines = 0 dabadeed
GoTo EndInsertLines dhammaato
haddi

    Samee
Xulashada
_
_

_
_

1. Ka bax tifaftiraha koodka.
2. Laga soo bilaabo ribbon sare, dooro Developer > Macros ama si fudud u riix Alt + F8 . Dooro macro-ga aad hadda abuurtay oo dooro Ikhtiyaarada^(Options) . U deji furaha gaaban ee makro, laakiin hubi inaysan ahayn isku darka furaha ee jira ee aad si joogto ah u isticmaasho, sida Ctrl + C . Xaaladdan oo kale, waxaan isticmaalnay Ctrl + Shift + T . Markaad dhammayso, dooro OK si aad u kaydiso isbedelada oo aad uga baxdo.

1. Ku soo celi xaashida shaqada oo dooro unug hoose oo aad rabto inaad gasho safafka.
2. Isticmaal jidka gaaban ee aad u dejisay makro (kiiskan, Ctrl + Shift + T ). Waxaad ku arki doontaa xaashida shaqada ee soo booda ee ku weydiinaysa inaad geliso tirada safafka aad rabto inaad ku darto. Tusaale ahaan, aynu nidhaahno waxaad doonaysaa inaad gasho shan saf. Geli 5^{(Enter 5)} oo tabo Gelida^(Enter) .

1. Tani waxay ku dari doontaa 5 saf oo ka hooseeya^(below) unugga aad dooratay.

Mar kasta oo aad rabto in aad geliso safaf badan gudaha Excel , kaliya isticmaal jidka gaaban, geli tirada safafka, waadna dhammaysay.

Gelida Safka Badan ee Excel

Haddii aad si joogto ah u isticmaasho Excel^{(frequently use Excel)} , waxaa habboon in aad wax ka barato sida aad wakhtiga u badbaadin karto soo noqnoqda, hawlaha farsamada sida gelida safafka. Maadaama ay jiraan dhowr siyaabood oo loo geli karo safaf badan gudaha Excel , waa arrin ku saabsan habka aad ku qanacsan tahay. Haddii aad ku dartay khadadka maran badan gudaha xogta, waxaa jira dhowr siyaabood oo lagu tirtiro safafka maran^{(ways to delete blank rows)} , sidoo kale.

How to Quickly Insert Multiple Rows in Excel

If your work requirеs you to practicаlly livе in Excel sheets, yоu may be looking fоr ways to make repetitive tasks ѕimpler. For instanсe, whenever you work with data that needs to be updated regularly, you’ll frequеntly need to add multiple rows. 

In this guide, we’ll tell you how to insert multiple rows in Excel in a few quick and easy steps. Choose one that works best for you.

How to Insert Multiple Rows by Dragging Border Selection

This is the quickest way to insert multiple blank rows into your Excel sheet. It’s easy and doesn’t require using any keyboard shortcuts either. 

1. Select the row below or above which you want to enter blank rows. 
2. Hover your pointer over the border selection. 
3. Press Shift and you’ll see the pointer change into a point with an upward and downward arrow. Drag the selection down for the number of rows you want to add.

How to Insert Multiple Rows Using Excel Keyboard Shortcuts

If you don’t like the idea of multiple right-clicks while you work on your Excel sheet, there are two keyboard shortcuts you can use.

First, select the number of rows equal to the number of blank rows you want to enter. Use Shift + Space to select all columns for the selected rows or select rows using row numbers on the left. 

Then use either of the two shortcuts:

1. Alt + I and Alt + R: Press Alt + I, keep holding the Alt key, and press R.
2. Ctrl + Plus: You need to use the plus sign on the numeric pad. If you want to use the plus sign on the main keypad, use Ctrl + Shift + Plus.

The shortcut method is scalable too. Pressing F4 on an Excel sheet repeats the previous action. You could use one of the above shortcuts to add, for instance, 10 rows and subsequently press F4 10 times to add 100 blank rows.

How to Insert Multiple Copied Rows Using Keyboard Shortcuts

If you want to copy or cut multiple rows instead of adding blank rows, use the Alt + I + E shortcut.

1. Start by copying or cutting the rows.
2. Select the row above which you want to paste the rows by pressing the row number at the left.
3. Press Alt + I + E and choose Shift cells down.

You could also use the following shortcuts instead of Alt + I + E (the process is the same regardless of which shortcut you use):

• Ctrl + Shift + =
• Control + Plus (plus sign must be from the numeric keypad)

How to Insert Multiple Rows Using the Insert Option

To use this method, all you need to do is select the number of rows you want to add, right-click on the selection, and select Insert.

If you have a lot of columns in your data, press Shift + Space to select all columns for the selected rows, or select the rows using the row numbers at the left of the worksheet.

When you select Insert, Excel will insert rows above the first row that you selected.

If you want to enter a relatively larger number of blank rows, you could select a range and then use the Insert option. For instance, say you want to enter 500 rows.

1. Select a range in the format ‘starting row : final row’. Assuming you want to enter 500 rows after row 5, select the range 5:504 by entering this range in the cell name box.

1. Right-click and select Insert.

How to Insert Multiple Rows Using an Excel Macro

If you’re working with a large dataset on a worksheet that you expect to use regularly, you could automate row insertion using Macros. You don’t need to be an expert, though knowing the basics of VBA can give you a lot of power while you use Excel.

Before you start the process, check if the Excel ribbon at the top has a tab called Developer. If it doesn’t, go to Files > Options > Customize Ribbon and check the radio button beside Developer.

1. Navigate to the Developer tab and select Visual Basic.

1. Look for the Insert menu once the Visual Basic Editor opens and select Module.

1. Enter the following code in the editor:

Sub InsertRowsAtCursor()
Answer = InputBox(“How many Rows to insert? (100 Rows maximum)”)
NumLines = Int(Val(Answer))

    If NumLines > 100 Then
NumLines = 100
End If

    If NumLines = 0 Then
GoTo EndInsertLines
End If

    Do
Selection.EntireRow.Insert
Count = Count + 1
Loop While Count < NumLines

EndInsertLines:
End Sub

1. Exit the code editor.
2. From the top ribbon, select Developer > Macros or simply press Alt + F8. Select the macro you just created and select Options. Set a shortcut key for the macro, but ensure it’s not an existing key combination that you use frequently, such as Ctrl + C. In this case, we’ve used Ctrl + Shift + T.  When you’re done, select OK to save changes and exit.

1. Return to the worksheet and select a cell below which you want to enter the rows.
2. Use the shortcut you set for the macro (in this case, Ctrl + Shift + T). You’ll see a pop-up on the worksheet asking you to enter the number of rows you’d like to add. For instance, let’s say you want to enter five rows. Enter 5 and press Enter.

1. This will add 5 rows below the cell you had selected.

Every time you want to insert multiple rows in Excel, just use the shortcut, enter the number of rows, and you’re done.

Inserting Multiple Rows in Excel

If you frequently use Excel, it’s worth learning about how you can save time on repetitive, mechanical tasks such as inserting rows. Since there are several ways to insert multiple rows in Excel, it’s just a matter of what method you feel comfortable with. If you’ve added a lot of blank lines within the data set, there are several ways to delete blank rows, too.

Related posts

• Safka Kooxda iyo Tiirarka ku jira xaashida shaqada ee Excel

• Sida Loo Geliyo CSV ama TSV Xaashida Shaqada ee Excel

• Sida Loogu Mideeyo Xogta Faylal Badan oo Excel ah

• Sida Loo Sameeyo Liisaska Hoos-u-dhaca ee Isku Xirka Badan ee Excel

• Sida Looga Saaro Safka Kooban Ee Excel

• Sida loo sameeyo shaxda Pie ee Excel

• Ilaali Tixraaca Unugyada marka aad nuqul ka samaynayso foomamka gudaha Excel

• Sida loo qaado oo loo geliyo Screenshots addoo isticmaalaya OneNote

• Sida loo Isticmaalo Tilmaamaha Unugyada Hadalka ee Excel

• Sida Loo Raadiyo Excel

• Sida loo isticmaalo Excel's What-If Analysis

• 2 siyaabood oo loo Isticmaalo Shaqada Transpose ee Excel

• Hal-Column iyo Xog-urur badan oo Aasaaska ah oo ku kala soocida xaashida faafinta ee Excel

• Waa maxay sababta ay tahay inaad u isticmaasho safafka la magacaabay ee Excel

• Sida Loo Mideeyo Unugyada, Tiirarka & Safafka gudaha Excel

• Sida loo Geliyo Xaashida Shaqada ee Excel Word Doc

• Sida loo tirtiro khadadka banaan ee Excel

• Waa maxay VBA Array ee Excel iyo Sida loo Barnaamijyo Mid

• Sida Loo Wadaago Faylka Excel Si Fudud Layskula Shaqeeyo

• Si degdeg ah ugu qor nambarada Word iyo Excel