It Selects the current region (associated by blank rows and columns) It Enters the value from the cell directly above into the active cell It Unhides the columns in the current selection. It is also used to switch between absolute/relative refs Let us see the uses and working of keyboard shortcuts. There are multiple Excel Keyboard Shortcuts. Let’s check out how Excel Keyboard Shortcuts works it is categorized based on the usage of Alt, Ctrl, Shift & Function keys. If you press ALT+H, it is further categorized Excel will display icons to see the shortcut keys for various groups appearing under the ribbon tab. When you press the Alt key, you can observe below mentioned Ribbon tab below-showing shortcuts keys to press, e.g. In Excel, Keyboard shortcuts are commonly accessed by using ALT, Ctrl, Shift, Function key and Windows key.

Shortcut keys in Microsoft Excel help you to provide an easier and usually quicker method of directing and finishing commands.

Excel functions, formula, charts, formatting creating excel dashboard & others

Microsoft 2007 excel shortcut keys