Skip to main content

Conas sraitheanna / colúin fholamh a chomhdhlúthú in Excel?

For example you created/received a large workbook, and now you want to condense this workbook by deleting empty rows/columns, any idea? In this article, we describe several easy methods to get it done easily.

Condense empty rows/columns from selected range

Condense empty rows from selected range or active/selected/all sheets

Condense empty rows/columns from selected range or active/selected/all sheets

Quickly delete unused blank rows or columns from selected range/active sheet/all sheets

Le Kutools le haghaidh Excel Scrios Sraitheanna & Colúin Hidden (Infheicthe) utility, Excel users can quickly delete all unused rows or columns from specified selected range, active sheets, multiple selected sheets, or all sheets with ease in Excel.

ad delete blank rows columns 1


This method will guide you to select all blank cells by Téigh go Speisialta feature, and then delete empty rows or columns by Scrios Sraitheanna Bileog gné nó Scrios Colúin Bileog gné in Excel. Déan mar a leanas le do thoil:

1. Select the range where you want to condense all empty rows/columns/cells, and click Baile > Faigh & Roghnaigh > Téigh go Speisialta. Féach an pictiúr:

doc condense empty rows columns cells 2

2. In the opening Go To Special dialog box, please check the Blancanna rogha, agus cliceáil ar an OK cnaipe. Féach an pictiúr thuas:

Now only blank rows are selected in the specified range. See screenshot:

doc condense empty rows columns cells 3

3. cliceáil Baile > Scrios > Scrios Sraitheanna Bileog. Féach an pictiúr:

Delete Sheet Rows feature
All blank rows have been deleted

So far all blank rows are removed and condensed from the specified range. See above screenshot:

For condensing and removing all empty columns, please click Baile > Scrios > Scrios Colúin Bileog after selecting all blank cells.

Delete all blank columns in the specified range

nótaí: Make sure there are only blank rows or blank columns in your selected range before applying the Scrios Sraitheanna Bileog nó an Scrios Colúin Bileog feature, if the range is mixed with blank rows and columns, some contents will be deleted at the same time.


Kutools for Excel supports the Scrios Sraitheanna Bána utility to help Excel users to quickly delete all blank rows from a selected range, or delete all blank rows from active/selected/all worksheets in Excel.

Kutools le haghaidh Excel - Pacáilte le breis agus 300 uirlis riachtanach le haghaidh Excel. Bain sult as triail iomlán 30-lá SAOR IN AISCE gan aon chárta creidmheasa ag teastáil! Íoslódáil anois!

1. cliceáil Kutools > Scrios > Scrios Sraitheanna Bána, and then specify the deleting scope from the submenu. See screenshot:

Excel addin: one click to delete all blank rows

nótaí: For deleting all blank rows from the specified range, please select the specified range before clicking Kutools > Scrios > Scrios Sraitheanna Bána > Sa Raon Roghnaithe.

2. And then a dialog box pops out and shows how many blank rows were deleted successfully. Just click the OK cnaipe chun é a dhúnadh.

Now all blank rows have been deleted and condensed from the specified scope, such as active sheet, all sheets, etc. See screenshot:

all blank rows have been deleted

Kutools le haghaidh Excel - Supercharge Excel le níos mó ná 300 uirlisí riachtanacha. Bain sult as triail iomlán 30-lá SAOR IN AISCE gan aon chárta creidmheasa ag teastáil! Get sé anois


Soláthraíonn Kutools for Excel ceann eile Scrios Sraitheanna & Colúin Hidden (Infheicthe) utility to delete all empty rows or columns from the selected range, or from active/selected/all worksheets in Excel easily.

Kutools le haghaidh Excel - Pacáilte le breis agus 300 uirlis riachtanach le haghaidh Excel. Bain sult as triail iomlán 30-lá SAOR IN AISCE gan aon chárta creidmheasa ag teastáil! Íoslódáil anois!

1. cliceáil Kutools > Scrios > Scrios Sraitheanna & Colúin Hidden (Infheicthe).

Nóta: For deleting all empty rows or columns from the specified range, please select the specified range before clicking Kutools > Scrios > Scrios Sraitheanna & Colúin Hidden (Infheicthe).

Excel addin: Delete all hidden/blank/visible rows and columns
configurate to delete all blank columns

2. In the opening Delete Hidden (Visible) Rows & Columns dialog box, please do as follows:

(1) Specify the deleting scope from the Feach isteach drop down list. In our case, we selected the I ngach Bileog;

(2) Seiceáil an Rónna rogha nó Colúin option which you will delete in the Delete Type section;

(3) Seiceáil an Colúin bhána (nó Sraitheanna folmha) option in the Cineál mionsonraithe alt;

(4) Cliceáil ar an Ok cnaipe.

3. And then a dialog box pops out and shows how many blank columns (or rows) have been deleted. Just click the OK cnaipe chun é a dhúnadh.

dialog: show the total number of deleted columns

So far all empty rows/columns have been deleted from the specified range or active/selected/all sheets based on specified deleting scope.

Kutools le haghaidh Excel - Supercharge Excel le níos mó ná 300 uirlisí riachtanacha. Bain sult as triail iomlán 30-lá SAOR IN AISCE gan aon chárta creidmheasa ag teastáil! Get sé anois


Kutools le haghaidh Excel: Breis is 300 uirlis láimhe ar do mhéar! Cuir tús le do thriail saor in aisce 30-lá gan aon srianta gné inniu. Íosluchtaigh Anois!

Uirlisí Táirgiúlachta Oifige is Fearr

🤖 Kutools AI Aide: anailís sonraí a réabhlóidiú bunaithe ar: Forghníomhú Chliste   |  Gin Cód  |  Cruthaigh Foirmlí Saincheaptha  |  Anailís a dhéanamh ar Sonraí agus Cairteacha a Ghin  |  Feidhmeanna Kutools a agairt...
Gnéithe Coitianta: Faigh, Aibhsigh nó Aithnigh Dúblaigh   |  Scrios Sraitheanna Bána   |  Comhcheangail Colúin nó Cealla gan Sonraí a Chailleadh   |   Babhta gan Foirmle ...
Cuardaigh Super: Ilchritéir VLookup    VLookup Illuachanna  |   VLookup Trasna Ilbhileoga   |   Amharc doiléir ....
Liosta anuas Casta: Go tapa Cruthaigh Liosta Anuas   |  Liosta anuas Cleithiúnach   |  Liosta Buail Isteach Ilroghnacha ....
Bainisteoir Colún: Cuir Líon Sonrach Colún leis  |  Colúin Bog  |  Scoránaigh Stádas Infheictheachta na gColún Ceilte  |  Déan comparáid idir Raonta & Colúin ...
Gnéithe Réadmhaoin: Fócas Eangaí   |  Amharc Dearaidh   |   Barra Mór na Foirmle    Leabhar Oibre & Bainisteoir Bileog   |  Leabharlann Acmhainní (Uaththéacs)   |  Piocálaí Dáta   |  Comhcheangail Bileoga Oibre   |  Criptigh/Díchriptigh Cealla    Seol Ríomhphost trí Liosta   |  Scagaire Super   |   Scagaire Speisialta (scagaire trom/iodálach/stailc tríd...) ...
Barr 15 Uirlisí12 Téacs uirlisí (Cuir Téacs, Bain Carachtair,...)   |   50 + Cairt cineálacha (Cairt Gantt,...)   |   40+ Praiticiúil Foirmlí (Ríomh aois bunaithe ar lá breithe,...)   |   19 Insertion uirlisí (Cuir isteach Cód QR, Ionsáigh Pictiúr ón gCosán,...)   |   12 Tiontú uirlisí (Uimhreacha le Focail, Comhshó Airgeadra,...)   |   7 Cumaisc & Scoilt uirlisí (Sraitheanna Comhcheangail Casta, Cealla Scoilt,...)   |   ... agus eile

Supercharge Do Scileanna Excel le Kutools le haghaidh Excel, agus Éifeachtúlacht Taithí Cosúil Ná Roimhe. Kutools le haghaidh Excel Tairiscintí Níos mó ná 300 Ardghnéithe chun Táirgiúlacht a Treisiú agus Sábháil Am.  Cliceáil anseo chun an ghné is mó a theastaíonn uait a fháil ...

Tuairisc


Tugann Tab Oifige comhéadan Tabbed chuig Office, agus Déan Do Obair i bhfad Níos Éasca

  • Cumasaigh eagarthóireacht agus léamh tabbed i Word, Excel, PowerPoint, Foilsitheoir, Rochtain, Visio agus Tionscadal.
  • Oscail agus cruthaigh cáipéisí iolracha i gcluaisíní nua den fhuinneog chéanna, seachas i bhfuinneoga nua.
  • Méadaíonn do tháirgiúlacht 50%, agus laghdaíonn sé na céadta cad a tharlaíonn nuair luch duit gach lá!
Comments (0)
No ratings yet. Be the first to rate!
There are no comments posted here yet
Please leave your comments in English
Posting as Guest
×
Rate this post:
0   Characters
Suggested Locations