Best shortcut keys in excel

Best shortcut keys in excel

 MS Excel.

Microsoft Excel is a spread sheet developed by Microsoft for windows, mac OS, Android  and IOS. it features calculation, graphing tools, pivot tables, and a macro programing language called visual basic for Applications.

 

MS Excel shortcut keys.

Shortcuts are a great way to save time and energy in excel,

but there are more then 200, so the list can seem best 10 shortcuts.

keyboard shortcuts in excel allow you to do things with your keyboard instead of your mouse to increase your speed.

Insert The Total.

Auto sum shortcut keys in excel. Quickly create a Microsoft excel formula to get the sum of all cells by highlighting the cells you

want to know the value of and pressing Alt and =(equals) together. 

 

 

 

 

Show Hide Formulas.

 This shortcut will toggle between displaying cell values and cell formulas. You can use this shortcut to quickly see every formula in a worksheet, instead of the value it returns.

use this shortcut to showing or hiding the formula in MS Excel.

 

 

 

A New Line In a Cell.

use this shortcut when you need to start a new line inside a cell.

press Alt+Enter to insert a line break. Double click the cell in which you want to insert line break.  click the location where you want to break the line.

 

 

 

Removing a Row.

select a row you want remove it. use this key to remove quickly. select an entire row that you want to remove and then press this key.

this shortcut key help you to remove unwanted rows.

 

 

 

 

 

Removing a Column.

select a column you want remove it.

use this key to remove quickly. select an entire column that you want to remove and then press this shortcut key.

this shortcut key help you to remove unwanted column.

 

 

 

Insert the correct time.

Insert current time into an excel.

On worksheet , select the cell into which you want to insert the current time.

press the ctrl + shift + semi-colon key.

the current time will add in your cell automatically.

 

 

 

Insert the correct date.

Insert current date into an excel.

on worksheet, select the cell into which you want to insert the current date.

press the ctrl + semi-colon key.

the current date will show in your cell automatically.

 

 

 

Highlighting a column.

 select any cell which you want to select.

you want to select all columns use this key

press the ctrl + space key to highlight your

selecting columns.

release the ctrl key and space key and the entire column will be selected.

 

 

 

Highlighting a row.

select any cell which you want to select.

you want to select all rows use this key

press shift + space key to highlight your selecting rows.

release the shift key and space key and the entire row will be selected.





                                      comment below.
                          " how this post use full for you
                            what type of post you want."