Wednesday, October 15, 2014

Excel - Key Board Shortcuts

Know these shortcuts to work faster with Excel.

To enter current date
CTRL + ;

To enter current time
CTRL + SHIFT + :

To select the entire data area where your cell pointer is or the entire worksheet
CTRL + A

To cut selected cells
CTRL + X

To copy selected cells
CTRL + C

To paste copied information
CTRL + V

To create new workbook
CTRL + N

To display Print dialog box
CTRL + P

To save the current workbook
CTRL + S

To move cell pointer to cell A1
CTRL + HOME

To switch to next worksheet
CTRL + PgDn

To switch to previous worksheet
CTRL + PgUp

To apply/remove Bold format
CTRL + B

To apply/remove Italic format
CTRL + I

To start spell check
Function key - F7

To type TWO lines in a one cell
After typing line 1, ALT + ENTER