How To Quickly Clear The Contents Of An Entire Column (Or Multiple Columns) In Excel Explained
2.8 هزار بار بازدید -
پارسال
-
In this video we discuss
In this video we discuss 2 ways of how to quickly clear the contents of an entire column or multiple columns. We go through examples of each way step by step
Transcript/notes
There are 2 quick ways to clear the contents of an entire column in excel.
For the first way, go up to the letter of where you want to clear the contents of a column, in this example, I want to clear column C. You will see the cursor turn into a black arrow pointing down.
From here, left click once, and will see the entire column highlighted. Next, right click and you will see a pop up box appear. Next, go down the words clear contents, and left click on it, and the contents of the column has been cleared.
Be careful though, if you have any formulas in other cells that are dependent on the values in the cleared column, their values will change.
Now for the 2nd way. Make sure you are on the home tab at the top of the spreadsheet. Start by again left clicking on the letter box of the column you want to clear, so the column is highlighted. Next, in the editing section near the top of the spreadsheet there is an eraser icon and the word clear, left click on the down arrow next to clear, and a drop down box will appear. From here, left click on the first option, clear contents, and the column has been cleared.
One note, as I am showing on the screen, for the first way, if you highlight multiple columns, you can clear multiple columns. And for the second way, if you highlight multiple columns, you can also clear multiple columns.
Chapters/Timestamps
0:00 How to quickly clear the contents of a column
0:38 How to use the eraser icon to clear the contents of a column
1:06 How to clear multiple columns at the same time
Transcript/notes
There are 2 quick ways to clear the contents of an entire column in excel.
For the first way, go up to the letter of where you want to clear the contents of a column, in this example, I want to clear column C. You will see the cursor turn into a black arrow pointing down.
From here, left click once, and will see the entire column highlighted. Next, right click and you will see a pop up box appear. Next, go down the words clear contents, and left click on it, and the contents of the column has been cleared.
Be careful though, if you have any formulas in other cells that are dependent on the values in the cleared column, their values will change.
Now for the 2nd way. Make sure you are on the home tab at the top of the spreadsheet. Start by again left clicking on the letter box of the column you want to clear, so the column is highlighted. Next, in the editing section near the top of the spreadsheet there is an eraser icon and the word clear, left click on the down arrow next to clear, and a drop down box will appear. From here, left click on the first option, clear contents, and the column has been cleared.
One note, as I am showing on the screen, for the first way, if you highlight multiple columns, you can clear multiple columns. And for the second way, if you highlight multiple columns, you can also clear multiple columns.
Chapters/Timestamps
0:00 How to quickly clear the contents of a column
0:38 How to use the eraser icon to clear the contents of a column
1:06 How to clear multiple columns at the same time
پارسال
در تاریخ 1402/04/27 منتشر شده
است.
2,807
بـار بازدید شده