MS Excel is used to work with spreadsheets. This multifunctional tool is suitable not only for data entry, but also to solve complex tasks using formulas - mathematical, statistical and logical. In some of these, the presence of empty lines is unacceptable, they can affect the result of calculations. Delete a string, empty and not only, can be in several ways.
1
Run MS Excel. To do this, open an existing document. Or create a new one, through the context menu, right-click "Create" - "Microsoft Excel Sheet".
2
In the desktop, go to the desired row and click on the line number, the entire string will become dedicated. To highlight multiple lines, you need to press the Ctrl key. Next, go to "Delete" and click "Delete Rows from Leaf".
3
You can also delete lines through the context menu. On the selected lines, press PCM and click "Delete". This and previous ways are suitable for removing both empty lines and rows with information. The result will be one - the strings are removed from the sheet. You can cancel this action in the toolbar or the Ctrl + Z keys combination.
4
If you need to remove empty strings from the table, but not only empty, but with a specific criterion, use the command on the main panel - "sorting and filter". Either if this item is not on the main panel, then look for "data". Mark the interval for which the filter will be applied. Next, click "Sort and Filter" - "Filter".
5
A filter will be added to the table, it can be understood by the list of the list near the headers. Click on the first header, in the drop-down list, scroll down and remove the checkbox from the "empty" item. Now the lines in which there are no values \u200b\u200bwill be hidden, you can see double horizontal strips in their place.
6
But hide - does not mean remove. Repeat the filter manipulation, press the header of the first column, the list will appear, remove the checkbox from the item (allocate everything) and set the mark (empty). With this action you hide the string with values, and only empty will remain. On the left of the number of empty lines will be written in different color.
7
Now in front of you table with headlines and empty rows. Highlight empty, click on it right-click, in the menu that appears, click "Delete a string". Blank lines will be deleted. This technique can be used not only for empty rows, but for rows with values, identical data or names.
8
If the table on the current sheet is too big, then to quickly allocate the entire table, click on the crossing of columns and lines. After executing the operation, turn off the autofilter by repeatedly pressing the "Sort and Filter" button - "Filter".
The procedure for preliminary preparation and removal of strings takes no more than 30 seconds. This time may change depending on the workload of the central processor or the number of lines. It is worth remembering that if there is nothing visually in the cell, this does not mean that there, for example, there can be no formula. Therefore, when you choose a specific column as a criterion of empty strings, be careful to accidentally not delete the necessary information. Successes!
0
847
