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.
4 thoughts on “Short Cut Keys– that every Excel user should know”
Have never used the Ctrl + ‘ – in the past, thanks for sharing.
I find Ctrl + & very very useful – for adding an outside border to the cell(s) selected.
Nice one as well
If you are familiar with formatted tables in Excel, Ctrl+T is the shortcut to convert a (normal) range to a formatted table.
There are many benefits of using tables in Excel such as
– automatic expansion of the table when new content is added below the table (adds a new record) or to the right of the table (adds a new column/field).
– formulas referring to cells within the table follow a structured reference convention (using column header names instead of R1C1 style cell references), hence easier to understand.
– a formula entered in a cell in an initially blank column is auto-filled down that column.
– you can have multiple tables on a single worksheet, each with its own auto-filter options (filters apply across the entire row, so need to be careful).