excel main empty row delete or hide kerna

[paktha]

ایکسل میں خالی سیل یا روع کو ختم یا ڈ یلٹ کرنا کیسے ممکن
ہیں
how it is posibel to hide or delete empty row
thanks

[mohibb-e-wattan]

ایکسل میں خالی سیل یا روع کو ختم یا ڈ یلٹ کرنا کیسے ممکن
ہیں
how it is posibel to hide or delete empty row
thanks

Please Check This.
ager samaj na aaey to reply ker dana.

[syar]

Aik method tu aap ko mohibb-e-watan ne aap ko tafseel se bataya he. Agar manually aap ko oper deye gae tareeke se delete karna mushkil ho tu try the following Macro.
Screen shot m deye gae data ko base bana kar ye macro lekha ha agar it is not in your case then reply. An may be this is a fast then manually delete rows.

Also assume your data strats from Column "A"
Press ALT+F11
Insert Menu m ja kar module select karain aur new open hone wale window m ye code paste kar k macro run karain, aap k jitne bhe empty rows honge delete ho jae gi.

Sub Del_row()
Dim LR As Long
LR = Range("A" & Rows.Count).End(xlUp).Row
On Error Resume Next
Range("A1:A" & LR).SpecialCells(xlCellTypeBlanks).EntireRow.Delete
On Error GoTo 0
End Sub

regards

[syar]

Without using a macro:

Select your column

Press F5

Press the Special button, tick Blanks and click OK

Edit > Delete > Cells or rows jo aap chahte ho

regards

[paktha]

salam::

Aik method tu aap ko mohibb-e-watan ne aap ko tafseel se bataya he. Agar manually aap ko oper deye gae tareeke se delete karna mushkil ho tu try the following macro.
Screen shot m deye gae data ko base bana kar ye macro lekha ha agar it is not in your case then reply. An may be this is a fast then manually delete rows.

Also assume your data strats from column "a"
press alt+f11
insert menu m ja kar module select karain aur new open hone wale window m ye code paste kar k macro run karain, aap k jitne bhe empty rows honge delete ho jae gi.

sub del_row()
dim lr as long
lr = range("a" & rows.count).end(xlup).row
on error resume next
range("a1:a" & lr).specialcells(xlcelltypeblanks).entirerow.delete
on error goto 0
end sub

regards

اس تصویر میں موجود ڈیٹا کو فارمیٹ کرنا خالی رو کو

[syar]

salam::

format karne se keya murad ha? agar aap column"B" ki empty rows ko delete karna ha tu
try with modified code

Sub Del_row()
Dim LR As Long
LR = Range("B" & Rows.Count).End(xlUp).Row
On Error Resume Next
Range("B1:B" & LR).SpecialCells(xlCellTypeBlanks).EntireRow.Delete
On Error GoTo 0
End Sub

kia aap ne inpage se data as pic import ke ha tu phir mushkil ho ga. Lekan language istimal ke ha tu pleae reply.
If possible pls attached your dummy sheet here with your expected result.

regards

[paktha]

کل انشا اللہ دوبارہ کوشش کروں گا شکریہ

[sshzaidi]

Without using a macro:

Select your column

Press F5

Press the Special button, tick Blanks and click OK

Edit > Delete > Cells or rows jo aap chahte ho

regards

thanks yaar yeh short or acha hai