+3 votes
227 views
How to delete data from several selected cells in Excel 2019

in Office by (552k points)
reopened | 227 views

1 Answer

+4 votes
Best answer

Microsoft Office is one of the most used office suites around the world for its versatility, functionality and data management options; both numerical and text. There we have one of the best applications to manage both small and large amounts of data and it is Excel , currently in its 2019 trial version..

To learn more about how to install Office 2019 we can visit the following TechnoWikis link:

As we have mentioned, Excel is one of the most chosen options among users to organize accounting and financial data in their tables; that allow you to organize in your cells ordered data in rows or columns with simple or complex formulas and in a simple way.

When managing Microsoft Excel 2019 , we must normally handle numerical data for the creation of formulas and functions that give us the expected results. But at specific times it will be necessary for some of the data housed in those cells to be deleted to enter new data or to update the information; and although this is a task that sounds simple, we may encounter certain difficulties when deleting data from specific cells..

To solve this problem TechnoWikis will explain how we can erase data from various previously selected cells in Excel 2019.

image

Step 1

By default, the normal way to delete the contents of a cell is by right clicking on it and selecting the "Delete" option or by selecting the rows of the cells and pressing the "Delete" button on our keyboard:

image

Step 2

But when we are going to delete content from selected cells, not from a whole row or column, this method is not feasible since when selecting the "Delete" option we will have the following options:

image

Step 3

As we can see, this action completely eliminates either the row or the column, which would affect data that we do not want to delete.
To delete the content only from selected cells, we will right click on the selection and use the option "Delete content":

image

Step 4

When using this alternative, the content of the selected cells will be deleted without affecting the other cells in the environment:

image

Note
Alternatively, we can select the cells where their content is to be deleted and press the "Delete" key on our keyboard and this content will be deleted.

It's that simple to delete the content of selected cells in Excel 2019..


by (3.5m points)
edited

Related questions

+3 votes
1 answer
asked Sep 21, 2019 in Office by backtothefuture (552k points) | 224 views
+4 votes
1 answer
asked Oct 8, 2019 in Office by backtothefuture (552k points) | 253 views
+3 votes
1 answer
asked Sep 19, 2019 in Office by backtothefuture (552k points) | 237 views
+4 votes
1 answer
asked Sep 17, 2019 in Office by backtothefuture (552k points) | 239 views
+5 votes
1 answer
asked May 17, 2019 in Office by backtothefuture (552k points) | 600 views
Sponsored articles cost $40 per post. You can contact us via Feedback

Most popular questions within the last 30 days

10,659 questions
10,791 answers
510 comments
3 users