Ever felt the need to select an entire column for making changes?
More often than not, deleting or adding cells in Excel become the only option when correction needs to be done. To rectify those problems, we either have to resort to deleting columns or adding new to maintain the professionalism of the excel sheet. For example, unwanted calculation columns while auditing will make your document look unprofessional and unclean. In order to keep your model clean, one has to select columns and perform the steps mentioned above.
However, the question is what to do when you are dealing with large sets of data. Using your mouse will eventually waste your time and effort. We have a faster and easier solution for you to quickly select and delete columns!
Following is the shortcut for Windows:
⌃ + Space - Column Selection
⌃ + (+/-) for addition and deletion after selecting row
Now that you have learnt the excel shortcut for adding or deleting columns, now know Excel Shortcut To Format Cells and Excel Shortcut To Hide Or Un-Hide Ribbon Menu