Ever felt the need to select an entire row for making changes?
More often than not, deleting or adding cells in Excel becomes the only option when correction is required. To rectify those problems, we either have to resort to deleting rows or adding new, to maintain the professionalism of the excel sheet. For example, unwanted calculation rows while auditing will make your document look unprofessional and unclean. In order to keep your model clean, one has to select rows 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 rows!
Following is the shortcut for Windows:
⇧+Space - Row Selection
^ + (+/-) for addition and deletion after selecting row
Now that you have learnt the excel shortcut for adding or deleting rows, now know Excel Shortcut To Hide Or Un-hide Ribbon Menu and Excel Shortcut To Format Cells