If you work with very large Excel Workbooks, you know that you can spend quite a bit of time deleting columns of data.
You can delete a column (or row) by right-clicking on a cell in your column and selecting the delete option. This can, however, become wearisome when you have lots and lots of columns to delete in your worksheet.
I suggest using a keyboard shortcut instead. We all know that I love to save time and keystrokes!
- Simply select your column and click CTRL + – (minus sign).
- You can quickly add a columns by clicking CTRL + Shift + = (equal sign).
There are usually more than one way to accomplish something in Excel and this is no exception.
You can also right-click and delete multiple rows (i.e., ten rows). Simply select the rows, right-click and select Delete. If you still have rows to delete, just use your F4 function key to do the rest!