If the Spreadsheet contains data, a warning dialog box will appear asking for our confirmation. If the Spreadsheet doesn’t contain any data, the Spreadsheet will be deleted straight away without any warning. From the shortcut menu that appears we select the command Delete as shown in the image below. As mentioned above, the same number of selected Columns will be Deleted.įor us to Delete a Spreadsheet in our Workbook, the first way is to move on top of a Sheet that already exists in our Workbook, and then do a right click with our mouse. The second way is from the Home tab, we locate the area named Cells of the ribbon as shown below and then we select the command Delete and from the drop-down menu we select the command Delete Sheet Columns. The first way to Delete Columns, is to do a right click with our mouse on top of the selected Columns and then from the shortcut menu that appears we select the command Delete. When we Delete Columns, the same number of Columns selected will be Deleted and the ones at the right will move left, depending on how many Columns where selected. As mentioned above, the same number of selected Rows will be Deleted.įor us to Delete Columns in a Spreadsheet, we must select the number of Columns that we want to Delete. The second way is from the Home tab, we locate the area named Cells of the ribbon as shown below and then we select the command Delete and from the drop-down menu we select the command Delete Sheet Rows. The first way to Delete Rows, is to do a right click with our mouse on top of the selected Rows and then from the shortcut menu that appears we select the command Delete. When we Delete Rows, the same number of Rows selected will be Deleted and the ones below will move up, depending on how many Rows where selected. Whatever way we choose, the same dialog box will appear which is named Delete, where we have the following options to choose from:įor us to Delete Rows in a Spreadsheet, we must select the number of Rows that we want to Delete. The second way is from the Home tab, we locate the area named Cells of the ribbon as shown below and then we select the command Delete and from the drop-down menu we select the command Delete Cells. The first one, is to do a right click with our mouse on top of the selected area, and then from the shortcut menu that appears, we select the command Delete as shown below. Once the area of Cells is selected, there are two ways to Delete Cells.
The number of Cells selected, the same amount will be Deleted in our Spreadsheet.
All you need to do is to continue reading this post.įor us to Delete Cells in a Spreadsheet, we must select the area of Cells that we need to Delete as shown in t he image below. What happens though, when we come to a point that we want to Delete Cell, Cells, Row, Rows, Column, Columns and Sheet, Sheets in a Excel Workbook.
How to delete blank columns in excel spreadsheet how to#
In a previous post of mine, I had mentioned How To Insert Cell, Cells, Row, Rows, Column, Columns and Sheet, Sheets in a Excel Workbook.
0 kommentar(er)
