Excel Keyboard Shortcuts for Accountants

Excel can be a complete minefield. There's a function for this, a formula for that. You can be a while trying to figure out how to get things done.

You don't need to be an Excel expert to increase efficiency and save time, however. Learning keyboard shortcuts can greatly improve your productivity when working with spreadsheets.

In this bite, learn some of the most useful Excel keyboard shortcuts for accountants.

TIP: The shortcuts featured in this bite are widely used but not all shortcuts are applicable to all keyboards, eg keyboards in different languages, Mac keyboards, etc. Different versions of Excel may also require different shortcuts.

next

Spend a few minutes working through the bite then share your thoughts by answering the question posed. Don't forget to log your CPD, so you can watch your CPD clock up over the year.


But before we get started, vote in the poll below and see how your answer compares to that of other users.

Read through the bite and then share your thoughts on the question posed.


But before we get started, vote in the poll below and see how your answer compares to that of other users.

next

Your vote

How often do you use keyboard shortcuts in Excel?

You can see how often you and other users of this bite use Excel shortcuts.

Hearing about shortcuts for the first time? Shortcuts expert? Whatever the case, scroll through some useful Excel keyboard shortcuts and then share your favourites to earn a bit of CPD.

What do you think icon
next
race track

Insert charts

Ever wanted to insert a chart into your workbook to visualise your profit growth? Simply select the cells containing the data that you would like to visualise and press F11.

next

Spell check

More often than not, spreadsheets contain elements of text. You can run a spell check on your worksheet by pressing F7.

TIP: If you use text boxes in Excel, you must perform a spell check in each text box and not on the worksheet.

tick icon
next
pencil calculator and sums

SUM

The most commonly used formula in Excel is SUM. In fact, it is the only formula in Excel to have its own keyboard shortcut: Alt+=.

next

Format currency

Working in finance often requires you to format values in a certain currency. You can apply the currency format to a cell or range of selected cells by pressing Ctrl+Shift+4. The currency selected by Excel will be the default currency setting for your region.

globe icon
next
rows of red chairs

Select entire rows or columns

To select an entire row, press Shift+Spacebar.

To select an entire column, press Ctrl+Spacebar.

next

Switch between different worksheets and workbooks

Accountants often work with multiple workbooks open and multiple worksheets in each workbook. Navigation can be aided with the use of keyboard shortcuts…

switch between icon
next
compass icon
  • To switch to the next worksheet in a workbook, press Ctrl+PgUp.
  • To switch to the previous worksheet, press Ctrl+PgDn.
  • To toggle between different workbooks, press Ctrl+Tab.
next

View formulas

Sometimes it is necessary to view the formula in a cell rather than the value returned by the formula. You can quickly toggle between viewing the cell value and the cell formula by pressing Ctrl+`.

man looking through binoculars
next
 

There are many more keyboard shortcuts available in Excel.

Which Excel shortcuts do you find most useful in your role as an accountant or finance professional? Share your tips with other users of this bite!

New to shortcuts? Which of the above will you find helpful?

Share your answer in the box below then scroll down to log your CPD:

    You need to sign in or register before you can add a contribution.

  1. David M
    Posted yesterday at
    I don't think I will use these. There is too much much scope for misuse and mistakes.
    0
  2. Tanya W
    Posted 22-Jan-2020 at
    Always love learning new shortcuts & tips. I didn't know the Sum one or the Spell check but will make use of them. Also found another good one in comments (Alt + d + f + s) which I will find useful.
    0
  3. Imelda B
    Posted 21-Jan-2020 at
    Very useful tips will use most of them.
    0
  4. Michelle B
    Posted 20-Jan-2020 at
    Another great bite. Great shortcuts to have
    0
  5. Suzannah H
    Posted 20-Jan-2020 at
    I find shortcuts hard to remember and prefer to use icons. Good to know they exist though.
    0
  6. Jason ephraim B
    Posted 20-Jan-2020 at
    I switch between work sheets on a regular basis. I also know a umber of shortcuts which are very useful.
    0
  7. Neldabye G
    Posted 20-Jan-2020 at
    I find the above quite useful. this will definitely make my life easier
    0
  8. Vera C
    Posted 19-Jan-2020 at
    switching between worksheet very helpful
    0
  9. Olga P
    Posted 19-Jan-2020 at
    Alt+D+F+S is my favorite, I find shortcuts very useful
    0
    1 reply - view
    1. Tanya W
      Posted 22-Jan-2020 at
      Didn't know that one - thank you.
      0
  10. Sarah M
    Posted 16-Jan-2020 at
    Didn't realise you could spell check on excel, this is really useful
    0
  11. view additional comments
next
stopwatch icon

To finish your CPD Bite, answer the question above and share what you've learned. Then you can log your bite, and watch your CPD clock up.


Did you find this CPD Bite useful? It was written by accountingcpd.net author, Paula Guilfoyle.

Excel shortcuts can come in handy when building a financial model. Why not check out some of our Financial Modelling courses now, and you could get 4 more hours of CPD?

go to courses

Did you find this CPD Bite useful? You can get more CPD Bites and more on this topic as part of an accountingcpd licence. Sign up today for flexible, relevant and enjoyable CPD. Its CPD as it should be.

find out more