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.


4 thoughts on “Short Cut Keys– that every Excel user should know

  1. 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).

    and more…

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s