• Home  / 
  • Excel
  •  /  20 Excel Keyboard shortcuts for Beginners

20 Excel Keyboard shortcuts for Beginners

When starting with Microsoft Excel, knowing a few shortcuts will reduce your work time and make it easier to work on Excel. Using the mouse to do all the task reduces your productivity. Here are a few shortcuts to use when you just begin working with Microsoft Excel. These Excel Keyboard shortcuts for beginner works with all versions of Excel 2003, Excel 2007, Excel 2010, Excel 2013.

Get advanced excel training program on more than 200+ shortcut keys and formulas

Below are 20 Excel Keyboard shortcut for Excel beginners:

Excel Keyboard  Shortcut What does it do?
Ctrl+N Create a new workbook.
Ctrl+O Open an existing workbook.
Ctrl+S Save the active workbook.
CTRL+W Close the active workbook.
Ctrl+C Copy the contents of the selected cells to Clipboard.
Ctrl+X Cut the contents of the selected cells to Clipboard.
Ctrl+V Insert the contents of the Clipboard into the selected cell(s).
Ctrl+Z Undo your last action.
Ctrl+P Open the “Print” dialog.
Ctrl+1 Open the “Format Cells” dialog.
Ctrl+G Go to any special cell.
F2 Edit the current cell.
Alt+Enter In cell editing mode, enter a new line (carriage return) into a cell.
CTRL+; Enter the current date. Press CTRL+Shift+; to enter the current time.
CTRL+ENTER Fill the selected cells with the contents of the current cell.
Ctrl+B Bold.
Home Return to the 1st cell of the current row in a worksheet.
Ctrl+Home Move to the beginning of a worksheet (A1 cell).
Ctrl+R Fill Right.
Ctrl+Space Select the entire column.
Shift+Space Select the entire row.

We would love to hear from you which were the Excel Keyboard shortcuts you learned when you started using Microsoft Excel. You can write in comments below.

Do enrol for our free online excel course on shortcuts and formulas

About the author

Yoda Learning Team

Yoda Learning Trainer team includes of 12 Industry experts focused on developing “Project-based" learning solutions, which enable the learners explore real world situations and thus, make the learning process engaging and practical. They have a collective work-experience of 80+ yrs.

  • Hello Web Admin, I noticed that your On-Page SEO is is missing a few factors, for one you do not use all three H tags in your post, also I notice that you are not using bold or italics properly in your SEO optimization. On-Page SEO means more now than ever since the new Google update: Panda. No longer are backlinks and simply pinging or sending out a RSS feed the key to getting Google PageRank or Alexa Rankings, You now NEED On-Page SEO. So what is good On-Page SEO?First your keyword must appear in the title.Then it must appear in the URL.You have to optimize your keyword and make sure that it has a nice keyword density of 3-5% in your article with relevant LSI (Latent Semantic Indexing). Then you should spread all H1,H2,H3 tags in your article.Your Keyword should appear in your first paragraph and in the last sentence of the page. You should have relevant usage of Bold and italics of your keyword.There should be one internal link to a page on your blog and you should have one image with an alt tag that has your keyword….wait there’s even more Now what if i told you there was a simple WordPress plugin that does all the On-Page SEO, and automatically for you? That’s right AUTOMATICALLY, just watch this 4minute video for more information at. Seo Plugin

  • Hello, I enjoy reading all of your article post.
    I wanted to write a little comment to support you.

  • With havin so much written content do you ever run into any issues
    of plagorism or copyright infringement? My blog has a lot of unique content I’ve either
    authored myself or outsourced but it appears a lot of it is popping it
    up all over the internet without my authorization. Do you know any techniques to help prevent content from being stolen?
    I’d certainly appreciate it.

  • Defense against Chaturbate Token Hack and other
    sensitive information
    As the requirement for dependable and commanding security gains importance
    and the principles and requirements set by the Payment
    Card Industry progress to meet that need, the requirement for cutting edge resolutions will
    also upsurge. As hackers find new ways to blunder tokens in a system like Chaturbate Token Hack, fresh ways to
    safeguard sensitive information also requires development.
    The security flaunts that are used
    Conventional security is showing its drawbacks and proving itself to be inadequate in this digital age which are used
    in the present scenario. This is becoming more and more obvious as most people get more news about corporations that have
    been suffering from a hole of some kind or the other regarding safety issues.
    Often those firms have been under the fact that meek encryption is sufficient
    to defend sensitive token and other data like credit card data on their own sites.
    Unluckily, chaturbate token generator has lately become obvious
    that the concept is not true anymore.
    In this scenario free chaturbate tokens are one of the most
    essential prospects of this tool. Very frequently the data safety procedures are exploited
    or inadequately managed, and hackers can get a grip over the encryption secrets or find other glitches and cause serious destruction and obvious distress.
    Credit card tokenization is swiftly flattering one of the finest ways to
    contrivance proper safety and reach PCI obedience.
    The procedure works in this way, like a credit card,
    a token or debit card or any other payment technique is used in a money transaction, either on the web or any other electronic
    mean, and the original data is sent to the company which actually
    provides the tokenization facilities. One can get to know more about
    free chaturbate tokens in various websites.
    Directly after, a randomized and unique number
    is produced and sent to the user. This digit is considered as the token,
    is the solitary object that needs to be kept in a system that is internal.
    Conversely, if one stocks private evidence on their own system,
    they are the one liable for efficiently handling and constantly checking that information. But that is not enough to detect any kind of suspicious activity.
    Nobody can conclude that the hackers will not reach the computer via electronic means.

    Besides if you need more information about chaturbate token generator then do a
    little research from various sites.
    Conclusion
    Credit card tokenization was intended to help a user to remove those doubts of
    hacking. A user should end keeping delicate information on their individual system that may be a computer, laptop, a Smartphone
    or any other similar devices and transfer it to a system which is continuously as well as efficiently observed,
    safe, and updated. This can reduce other chances of hacking which also includes Chaturbate
    Token Hack as no data or sensitive information is
    kept on the user’s system.

  • Hello! I just wanted to ask if you ever have any issues with hackers?
    My last blog (wordpress) was hacked and I ended up losing several weeks of hard work due to no back up.
    Do you have any methods to protect against hackers?

  • seo

    Hello Web Admin, I noticed that your On-Page SEO is is missing a few factors, for one you do not use all three H tags in your post, also I notice that you are not using bold or italics properly in your SEO optimization. On-Page SEO means more now than ever since the new Google update: Panda. No longer are backlinks and simply pinging or sending out a RSS feed the key to getting Google PageRank or Alexa Rankings, You now NEED On-Page SEO. So what is good On-Page SEO?First your keyword must appear in the title.Then it must appear in the URL.You have to optimize your keyword and make sure that it has a nice keyword density of 3-5% in your article with relevant LSI (Latent Semantic Indexing). Then you should spread all H1,H2,H3 tags in your article.Your Keyword should appear in your first paragraph and in the last sentence of the page. You should have relevant usage of Bold and italics of your keyword.There should be one internal link to a page on your blog and you should have one image with an alt tag that has your keyword….wait there’s even more Now what if i told you there was a simple WordPress plugin that does all the On-Page SEO, and automatically for you? That’s right AUTOMATICALLY, just watch this 4minute video for more information at. Seo Plugin

  • Hi admin, i see your site needs fresh content.
    If you are too lazy to write unique articles everyday you should
    search in google for:
    Ightsero’s Essential Tool

  • Wark