General Create new workbook – Ctrl+N Open existing workbook – Ctrl+O Save Workbook – Ctrl+S Close Excel – Alt+F4 (or) Ctrl+F4 Move to the next sheet – Ctrl+PageDown Move to the previous sheet – Ctrl + PageUp goto Data Tab – Alt+A goto View Tab – Alt + W goto Formula Tab – Alt +M
Formatting related Edit Cell – F2 Copy and Paste cells – Ctrl+C then Ctrl+V Bold – Ctrl+B Italicize font – Ctrl+I Center Align cell content – Alt+H+A+C Fill Color – Alt+H+H Add border – Alt+H+B Remove outline border – Ctrl+Shift+ _ Add outline to selected cells – Ctrl+Shift+& move to next cell – Tab move to previous cell – Shift+Tab Select all cells to the right – Ctrl+Shift+Right Arrow Select all cells to the left – Ctrl+Shift+Left