Excel Shortcut Keys

    Here are some of the Excel shortcut keys that would make your excel work easier and quicker.  Practice these to obtain mastery.  

GET THE SUM OF THE COLUMN/ROW DATA
Press
Alt +
      On your keyboard, place the cursor at the end of the cell where you want the sum to appear then Press Alt + keys.
   

You could also do the same to get the sum of the rows.


SELECT THE ENTIRE COLUMN

Press
Ctrl Spacebar

       On you keyboard, select any cell in the column that you want to select.  Then press the Ctrl Spacebar.


SELECT THE ENTIRE ROW
On you keyboard, select any cell in the row that you want to select.  Then press the Ctrl Spacebar.
   

INSERT COLUMN
Press
Ctrl Shift +

       Place your cursor in the column where you want to insert the new column.  Then press the Ctrl Shift +.

INSERT ROW

Press
Ctrl Shift +
       Place your cursor in the row where you want to insert the new
  row.  Then press the Ctrl Shift +.

DELETE ENTIRE COLUMN

Press
Ctrl -
       Place your cursor in the column that you want to delete.  Then press the Ctrl -.




DELETE ENTIRE ROW

Press

Ctrl -

       Place your cursor in the row that you want to delete.  Then press the Ctrl -.

HIDE COLUMN


Press
Ctrl 0

       Place your cursor in the column that you want to hide.  Then press the Ctrl 0.

HIDE ROW

Press
Ctrl 9

       Place your cursor in the row that you want to hide.  Then press the Ctrl 9.

Link:  VBA Tips