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.
Condense empty rows/columns from selected range
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:
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:
3. cliceáil Baile > Scrios > Scrios Sraitheanna Bileog. Féach an pictiúr:
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.
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.
Condense empty rows from selected range or active/selected/all sheets
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:
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:
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
Condense empty rows/columns from selected range or active/selected/all sheets
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).
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.
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
Demo: condense empty rows /columns in Excel
Earraí gaolmhara:
Uirlisí Táirgiúlachta Oifige is Fearr
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 ...
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á!