Most Important key board short keys of MS EXCEL

 

What are Most Important key board short keys of MS EXCEL?

Key board short keys of MS EXCEL  are two or more keys pressed together to perform an action which can also be done with your mouse.

Why do we use key board short keys of MS EXCEL?

As the name tells us that these are short keys, hence shortest way to perform an action which saves time.

short keys of MS EXCEL?

Here are some handy and useful short keys of MS EXCEL

Ctrl+W           to Close a worksheet 

Ctrl+O            to Open a worksheet 

Alt+H              to Go to the Home tab 

Ctrl+S              to Save a worksheet 

Ctrl+C              to Copy  text

Ctrl+V              to Paste already copied text 

Ctrl+Z              to Undo changes made   

Delete key       to Remove data in a CELL 

Alt+H                to Choose fill color 

Ctrl+X               to Cut the data (to paste somewhere else)

Alt+N                to Go to Insert tab 

Ctrl+B               to Bold the selected text font 

Alt+H, A, then C   to Center align cell contents 

Alt+P                  to Go to Page Layout tab 

Alt+A                  to Go to Data tab 

Alt+W                  toGo to View tab

Shift+F10             to Open context menu

Alt+H, B              to Add borders

Alt+H,D, then C  to Delete a column 

Alt+M                   to Go to Formula tab

Ctrl+9                   to Hide the selected row

Ctrl+0                    to Hide the selected column

Ctrl+arrow key     to Move to an edge of the current data in a worksheet

Ctrl+End         to Move to the last cell on a worksheet

Ctrl+Home      to Move to the A1 cell 

Ctrl+Page Up  to Move to the previous sheet in a worksheet

Tab              to Move one cell

Ctrl+T          to open the Create Table dialog

Ctrl+Y         Repeat the last command or action