Excel Shortcuts

          

              1. Inserting the Total :

                           Alt +  ;

               

                      Using this shortcut, you can add the total of selected field/ row.

               2. Inserting Current time in a cell :

                      Ctrl + Shift + ;

                     You can add current time in selected cell

              3. Inserting Correct Date :

                    Ctrl + ;

                               Inserting current date in selected cell.

              4. Highlighting a column :

                   Ctrl + space

            5.  Highlighting a row :

                        Shift + space

             6. Removing a column :

                        Ctrl + 0

             7. Removing a row :

                   Ctrl + 9

              8. A new cell

                   Alt + Enter

               9. Show/ hide formula :

                 Ctrl + ~