Despite the fact that office alternatives are increasingly wide, this office suite is still the main choice for most users when creating documents. The Office documents serve us in a number of occasions to be able to make different files according to our needs. With the new updates, we have been able to observe how, for example, new functions were incorporated in Word, just as new tools appeared in Excel. In addition to using its keyboard shortcuts when creating documents, it makes it a really useful work tool.
For example, Google Docs has a function which allows us to convert application documents to the Office format. Generally these types of documents are compatible with any application that needs to open them and this is very beneficial for the user.
Excel is one of the most used applications, but also the most complex in the package. It allows us to create tables with data in a simple way, but the thing is complicated when our intention is to do something more complex and we intend for example to create different graphics or create dynamic tables.
One of the most common questions that users have ever asked themselves during their use is how we can erase all those blank rows that do not interest us in a certain document. Generally, the first thing we usually do in these cases is to select the entire column and with the right button open the drop-down menu and then select “delete”.
Not always all the data that we put inside our Excel sheets ends up being helpful since multiple changes are made during the process. We know that we can perform various tasks with our data in the order we want. We can use white cell resources either in rows or columns to be able to separate different sections, but perhaps at the end we need to put them together. To do this, removing it without neglecting everything is necessary and here is the process for Excel 2016.
In this tutorial we will explain a faster way to do this while simple. In this way you will not have to select the columns or rows you wish to delete one by one, and your time will be more productive. We also leave you the video tutorial with the necessary steps to delete empty rows and columns in Excel 2016 and also valid for Excel 2019.
Step 1
The first thing we have to do is select the entire area in which the columns we want to delete are located. We have to make sure we include everything.
Step 2
Now that we have it selected, we have to press the F5 key on our keyboard, to open the “go to” pop-up window. We have to select “special”
Step 3
The next thing we have to do is select in the pop-up window that will appear on our screen, the option of “Blank”.
Step 4
In this way all the blank columns of our sheet will be marked as we can see in the following image.
Step 5
Next we must go in the top menu in the "General" tab to the section that says "delete" and display it. Once here, we have to click on the option “delete sheet rows” or “delete sheet columns” according to preference.
Step 6
Once we select it, our empty columns will have disappeared and we will only stay with those that really interested us.
In this way we can eliminate cells or columns that do not contain data automatically and thus prevent us from neglecting everything we have done in our spreadsheet. A simple task but that improves the result when we work with data.
Remember that maintaining the security of our documents is very important to protect our privacy. It is interesting therefore that you know how to put password to Word and Excel documents.
Articles