Skip to content
June 9, 2016 / Erik Svensen

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.

 

Advertisements

4 Comments

Leave a Comment
  1. Alex Powers / Jun 12 2016 9:07 pm

    Have never used the Ctrl + ‘ – in the past, thanks for sharing.

  2. Tony / Jun 14 2016 2:00 pm

    I find Ctrl + & very very useful – for adding an outside border to the cell(s) selected.

  3. kviccaji / Jun 14 2016 3:25 pm

    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:

WordPress.com Logo

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

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s

%d bloggers like this: