Tuesday, 6 January 2015

Shortcut Key for Delete/Insert Column & Rows in MS Excel

            Some time we need to insert or delete column and rows in excel sheet. You can do this with your mouse, but I always prefer to use keyboard shortcut keys for fast work.  Here I will show you easy keyboard shortcut key for deleting and inserting column and rows anywhere in excel sheet and this shortcut keys will work all the version of Microsoft excel like 2003, 2007, 2010 and 2013. Just follow these steps.

1.  Open your Microsoft Excel sheet    

2.  Keep the cursors where you want to insert the column or rows

3.  Hold the “Ctrl” key and press “+” button in numerical keys. You will get the dialog box of “insert” select “Entire column or row” and press “enter”
Shortcut Key for Delete/Insert Column & Rows in MS Excel


Shortcut Key for Delete/Insert Column & Rows in MS Excel


4.      For deleting column and row Hold the “Ctrl” key and press “-” button in numerical keys.  You will get the dialog box of “delete” select “Entire column or row” and press “enter”
 Shortcut Key for Delete/Insert Column & Rows in MS Excel


Watch video tutorial… Please like, share and subscribe

No comments:

Popular Posts