Advantage IT Management Blog

Keyboard Shortcuts to Help You Excel in Microsoft Excel

Keyboard Shortcuts to Help You Excel in Microsoft Excel

Microsoft Excel is a great tool to organize data into spreadsheets, but it’s kind of a tricky beast to master. As is the case with most software programs, you can add an extra level of mastery to your skillset by having a full understanding of keyboard shortcuts. We’ve listed some of the most common shortcuts that you might use during your day-to-day duties in Microsoft Excel.

You can even print out this blog article and use it as a resource throughout the workday! That way, you’ll have a quick reference should you ever need one.

  • Cut: Ctrl + X
  • Copy: Ctrl + C
  • Paste: Ctrl + V
  • Open a Workbook: Ctrl + O
  • Close a Workbook: Ctrl + W
  • Save a Workbook: Ctrl + S
  • Undo: Ctrl + Z
  • Navigate between cells and menu options: Arrow Keys
  • Expand/Collapse Ribbon: Ctrl + F1
  • Move to the beginning of the worksheet: Ctrl + Home
  • Move to the next sheet in the workbook: Ctrl + Page Down
  • Move to the previous sheet in the workbook: Ctrl + Page Up

Entering Information in Cells

If you want to add information into cells, there are various shortcuts to doing so as well:

  • Enter the current time: Ctrl + Shift + :
  • Enter the current date: Ctrl + ;
  • Apply the General Number format: Ctrl + Shift + ~
  • Apply the Currency format with two decimal places: Ctrl + Shift + $
  • Apply the Percentage format with no decimal places: Ctrl + Shift + %
  • Apply the Scientific number format with two decimal places: Ctrl + Shift + ^
  • Apply the Date format with the day, month, and year: Ctrl + Shift + #
  • Apply the Time format with the hour and minute, and AM or PM: Ctrl + Shift + @
  • Apply the Number format with two decimal places, thousands separator, and minus sign for negative values: Ctrl + Shift + !

This only scratches the surface of what Excel is capable of. If you want even more keyboard shortcuts in addition to the ones that we’ve picked out, Microsoft details even more of them on its website.

What other tips are you hoping to see from us in the future? Let us know in the comments, and be sure to subscribe for even more blogs about how to be more productive throughout the workday.

VoIP Can be a Game Changer for Business Communicat...
LinkedIn Users Exposed on Hacker Forums
 

Comments

No comments made yet. Be the first to submit a comment
Already Registered? Login Here
Guest
Sunday, September 19 2021

Captcha Image

By accepting you will be accessing a service provided by a third-party external to https://www.advantageitm.com/

Mobile? Grab this Article!

QR-Code dieser Seite

Recent Comments

kanwal liaquat Most Noteworthy Data Breaches in 2019
24 August 2021
I agree with you data security is like a joke. Your data is never saved once you step on the interne...
RyanMcCawley Is it Wrong to Purchase Access to Your Own Data?
11 November 2020
As we know there are so many colleges and universities. From http://www.carwrapsanantonio.net/ stude...
WilliamMMartin What You Need to Know to Manage a Remote Workforce
29 April 2020
Managing a remote workforce is tough, but now a day it is the requirement and we all need to take ca...
Malcolm Quinn Gmail and the G Suite Get Overhauled with A.I.
13 April 2020
Some of the sites on the link can be overhauled and users can get different advantages. On the other...
Avye Goodwin ALERT: Change Your Twitter Password, Says Twitter
25 March 2020
When you create your Twitter account you have to make your password secure and healthy so that you c...