Short Cut Keys– that every Excel user should know
Here is a list of short cut keys that I almost use every time I work in Excel.
The short cut keys works in the English version of Excel – localized version may use other keys.
CTRL + ‘ – copies the content of the cell above and enter edit state of the cell – very handy when creating almost the same formula as the cell above
F4 – when you are editing a cell reference in the formula bar the key cycles through the absolute and relative for column ref and row ref
CTRL+ _ (underscore) – removes any border around the selected cells
CTRL + ENTER – when a range or multiple cells is selected and you press CTRL + ENTER when you input values or formulas the input will be inserted in your entire selection
CTRL + F1 – Hide the Ribbon
CTRL + 1 – Open the format cells dialog
Hope these can help you too – if you have other favourites please let me know in the comments below.