ایکسل میں خالی سیل یا روع کو ختم یا ڈ یلٹ کرنا کیسے ممکن
ہیں
how it is posibel to hide or delete empty row
thanks
ایکسل میں خالی سیل یا روع کو ختم یا ڈ یلٹ کرنا کیسے ممکن
ہیں
how it is posibel to hide or delete empty row
thanks
See The Beauty Of Dubai
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.
regardsCode: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
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
salam::
format karne se keya murad ha? agar aap column"B" ki empty rows ko delete karna ha tu
try with modified code
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
کل انشا اللہ دوبارہ کوشش کروں گا شکریہ
Bookmarks