Excel Shortcuts for Selecting and Deleting Rows

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:

Shift + Spacebar - Row Selection

Ctrl + (+/-) 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

Excel Shortcut To Hide Or Un-hide Ribbon Menu
Excel Shortcut To Format Cells

I am greatly impressed by the quality of your training. In fact it is the reason I am going to take the exam this time as I had previously decided not to take it because the quality of the training I had purchased was not what I had expected. All the best to you and everyone at Edupristine.
I am very pleased to have found these courses offered by a recognized, reputable training firm at a great value! Thank you!

Global Association of Risk Professionals, Inc. (GARP®) does not endorse, promote, review or warrant the accuracy of the products or services offered by Edu for FRM® related information, nor does it endorse any pass rates claimed by the provider. Further, GARP is not responsible for any fees or costs paid by the user to Edu nor is GARP responsible for any fees or costs of any person or entity providing any services to Edu Study Program. FRM®, GARP® and Global Association of Risk Professionals®, are trademarks owned by the Global Association of Risk Professionals, Inc

CFA Institute does not endorse, promote, or warrant the accuracy or quality of the products or services offered by EduPristine. CFA Institute, CFA®, Claritas®, and Chartered Financial Analyst® are trademarks owned by CFA Institute.

Utmost care has been taken to ensure that there is no copyright violation or infringement in any of our content. Still, in case you feel that there is any copyright violation of any kind please send a mail to legal@edupristine.com and we will rectify it.

Popular Blogs: Whatsapp Revenue Model | CFA vs CPA | CMA vs CPA | ACCA vs CPA | CFA vs FRM

2015 © Edupristine. ALL Rights Reserved.

tick_classroom_city.php Post ID = 56727