10 Excel Keyboard Shortcuts You Need to Know
Excel can be a complete minefield for some. Functions for this and formula for that. So much to remember. So many ways to do things.
But you don’t need to be an Excel expert to increase efficiency and save time. It doesn't matter if you are keeping spreadsheets to track your cryptocurrency interests or to track your lifestyle budget. Learning Keyboard shortcuts can greatly improve your productivity when working with spreadsheets.
POLL
How often do you use keyboard shortcuts in Excel? Put your answer in the comments below
• I never use the mouse – always the keyboard and shortcuts
• Most of the time
• I use the few I know
• What shortcuts?
Quick charts
Ever wanted to quickly insert a chart to your workbook to visualise your profit growth? Simply select the cells in your workbook containing the data that you would like to visualise and press F11
Spell Check
More often than not, spreadsheets contain elements of text. You can quickly run a spell check on your worksheet by pressing F7. However if you have text boxes on a worksheet, a spell check must be performed within the text box and not on the worksheet.
SUM
The most used formula in Excel is the SUM formula. In fact it is the only formula in Excel to have its own keyboard shortcut Ctrl+Alt+ =
Currency format
Working in finance often requires formatting values in currency. You can quick format a cell or a range of selected cells by pressing Ctrl+Shift+4. The currency selected will be the default setting for your region in Excel.
Selecting Entire Rows or Columns
To quickly select an entire Row press Shift+Spacebar
To select an entire column press Ctrl+Spacebar
Switch between Different Worksheet and Workbooks
Very often accountants work with multiple workbooks open and multiple worksheets in each workbook. Navigation can be aided with the use of keyboard shortcuts.
• Switch to the next worksheet in a workbook press Ctrl+PgUp
• Switch to the previous worksheet press Ctrl+PgDn
• To navigate through workbooks press Ctrl+Tab
View Cell Value or Formula
Sometimes it is necessary to view the formula in the cell rather than the value returned by the formula. You can quickly toggle between viewing the cell value or the cell formula by pressing Ctrl+‘
Learn and Earn Activity
Considering there are many many more keyboard shortcuts available in Excel, share with us the keyboard shortcut you use the most. Which of the above shortcuts will you find most useful? add your answer in the comments below to earn steem rewards.
For more Excel Learn and Earn Steem activities follow @theexcelclub and become an Excel Ninja in no time.
I use a lot F4 - repeat last action
Oh, I use F4 for relative and absolute cell references
Posted using Partiko Android
If you are not editing a cell or formula, it has another function.
Cool! very informative I like it guys thank you by showing these keys and shortcuts. I am now productive using excel to my work assignment especially doing evaluation rates. Thank you @theexcelclub & @paulag for the Ideas you showed to us. TEEM ON !BEER
You are very welcome
Posted using Partiko Android
KEEP DOING GOOD WORKS @paulag
I only use the few I know - which after thinking about it is pretty much just copy (CTRL C) and paste (CTRL V). Nothing fancy at all but I make do...
Posted using Partiko Android
Well now you have a bunch of shortcuts you can work with 😉
Posted using Partiko Android
To listen to the audio version of this article click on the play image.
Brought to you by @tts. If you find it useful please consider upvoting this reply.
You have been curated curated by @hafizullah on behalf of Inner Blocks: a community encouraging first hand content, with each individual living their best life, and being responsible for their own well being. #innerblocks Check it out at @innerblocks for the latest information and community updates, or to show your support via delegation.
Sorry, out of BEER, please retry later...
Congratulations @theexcelclub! You have completed the following achievement on the Steem blockchain and have been rewarded with new badge(s) :
You can view your badges on your Steem Board and compare to others on the Steem Ranking
If you no longer want to receive notifications, reply to this comment with the word
STOPVote for @Steemitboard as a witness to get one more award and increased upvotes!