EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 120+ Courses All in One Bundle
  • Login
Home Excel Excel Resources Excel Formula and Functions Microsoft Excel Shortcuts For PC
Secondary Sidebar
Excel Functions
  • Excel Formula and Functions
    • Compatibility Mode in Excel
    • VLOOKUP Names
    • Advanced Formulas in Excel
    • Excel Function for Range
    • Excel Template for Payroll
    • Excel Sum Time
    • Payroll in Excel
    • Complex Formulas in Excel
    • Pivot Chart in Excel 2016
    • Advanced Excel Formulas
    • Best Basic Excel Formulas
    • Use Excel As Your Calculator
    • Print Command Button in Excel
    • Excel SUM MAX MIN AVERAGE
    • Excel Basic Functions For Beginners
    • Interactive Excel Dashboard
    • Features of 2016 Excel Workbook
    • What's New In Excel 2016
    • Microsoft Excel Skills
    • Microsoft Excel Shortcuts
    • Microsoft Excel Tips and Tricks
    • Excel Skills
  • Excel Functions (12+)
  • Excel Tools (114+)
  • Financial Functions in Excel (17+)
  • Logical Functions in Excel (14+)
  • Lookup Reference Functions in Excel (35+)
  • Maths Function in Excel (47+)
  • TEXT and String Functions in Excel (26+)
  • Date and Time Function in Excel (24+)
  • Statistical Functions in Excel (59+)
  • Information Functions in Excel (4+)
  • Excel Charts (56+)
  • Excel Tips (222+)
  • Workplace Productivity (4+)
  • Microsoft Office Tools (15+)
  • MS Excel Shortcuts (4+)
Excel Functions Courses
  • Excel Training
  • Excel Advanced Training
  • Excel Data Analysis Training

Microsoft Excel Shortcuts For PC

By Jesal ShethnaJesal Shethna

Microsoft Excel Shortcuts – Since its release in 1985, Microsoft Excel Shortcuts has been a helpful tool for collating and analyzing information quickly and effectively. Excel spreadsheet is one of the most widely used computer applications that help organise, store, and analyse data in tabular form that is easily evaluated.

pivot tables

Though charts, formulas, and other tools help manipulate, analyse, and manage all the important data, it can be overwhelming to use spreadsheets without MS excel shortcuts. Fortunately for Excel users, every menu and operation in the application can be controlled from the keyboard with proper excel shortcuts. The list of Excel shortcut tricks which is more than 225 can itself be overwhelming to learn and use effectively, but once mastered, the result would be a highly effective and efficient output in a shorter time period.

Start Your Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

Those who are familiar with old excel shortcuts tricks for excel should notice that some of the old excel shortcuts do not work in Microsoft Excel 2013. Ctrl + C and Ctrl + V still do the copy-and-paste job, but some of the old menu keys do not work anymore. When the old shortcut is clicked, a box pops up informing that the access key is from earlier Microsoft Office.

office access

One more useful tool, though not included in excel shortcuts, would be hovering the pointer tool above the buttons to know their functions.

All in One Excel VBA Bundle(120+ Courses, 30+ Projects)
Basic ExcelAdvanced ExcelVBA & MacrosExcel Dashboards
Pivot TablesStatistical FunctionsFinancial FunctionsCharts & Graphs
Price
View Courses
120+ Online Courses | 30+ Projects | 500+ Hours | Verifiable Certificates | Lifetime Access
4.9 (64,325 ratings)

wrap text

With experience, the excel shortcuts and tricks will be memorized by people who regularly use excel, but initially, it is important to know a few basic excel shortcuts on the keyboard that would save time and energy for users.

The top 20 MS excel shortcuts key used for Microsoft Excel by individuals and businesses alike are:

  1. Home
  2. Ctrl + Page Down & UP
  3. Ctrl +Arrow Keys
  4. Ctrl + *
  5. Ctrl+5
  6. Shift + F10
  7. Ctrl + shift + [desired function key]
  8. Ctrl + F1
  9. F2
  10. F4 or Ctrl + Y
  11. F6
  12. F12
  13. Ctrl + Enter
  14. Ctrl + Alt + V
  15. Shift + Spacebar
  16. Alt
  17. End
  18. Enter
  19. Esc
  20. F1

Microsoft Excel Shortcuts Key

  1. Home

When working on the excel spreadsheet, the Home button on the keyboard conveniently takes the user back to the beginning of a row with just a click. If the scroll lock is turned on, clicking the ‘Home’ button takes the user to the cell in the window’s upper-left corner. If a menu or sub-menu is open, the home button selects the first command on the visible menu.

Users can move to the beginning of a worksheet by combining Ctrl + Home buttons. When working in a cell, using the Home/End buttons allows users to conveniently move to the beginning and the end of a cell data.

To extend the selection to the starting point in a row, combine Shift + Home and to extend the selection to the beginning of the worksheet, click Ctrl + Shift + Home buttons.

insterpad

  1. Ctrl + Page Down & UP

The Ctrl + Page Down or Ctrl + Page Up button helps in quickly surfing through worksheets in excel. Instead of crawling through the lines, users can jump from one worksheet to another with ease through this keyboard shortcut. Ctrl + Page Up moves to the previous worksheet whereas the Ctrl + Page down moves to the next. If the user has about 8 worksheets and is working on the 7th but wants to check some data on the 3rd, then all he has to do is hold down the Ctrl button and press the page up 4 times.

  1. Ctrl +Arrow Keys

The arrow keys are useful in moving one cell up, down, left, or right in an excel worksheet. With the help of the shortcut Ctrl + Arrow keys, the user can easily move to the edge of the next data region, but only if there are no blank cells on the worksheet. This helps to scroll through pages faster. Pressing Ctrl + Down Arrow key will take the user to the last row on the worksheet whereas clicking Ctrl + Up Arrow key will take the user to the first row in the worksheet. The same applies to the right and left arrow keys.

directions

  1. Ctrl + *

When the user desires to either copy or delete the current region around the actively working cell, the shortcut Ctrl + * (asterisk) helps select the currently active range in the cell with the entire data area enclosed by blank rows and blank columns.

excel shortcuts

The shortcut covers the data set in all directions from the currently active space up to the end of the worksheet or a blank row or column. When working on a PivotTable in an excel worksheet, the shortcut helps in the selection of the entire PivotTable Data. The asterisk key is available on the numeric keyboard for independent selection.

  1. Ctrl+5

For those who like to finish the task on the list and strike it off, the shortcut Ctrl + 5 will do the job effectively.

notes

Striking a task off the ‘To Do List’ will make it clear to the user what has been accomplished and what is left to do. If all the task in the cell has been completed, the entire cell can be selected and strikethrough by pressing Ctrl + 5 shortcut.

calender

  1. Shift + F10

The shift + F10 shortcut functions like the right-click on the mouse, opening up the menu for use. It is agreed that moving the hand to the mouse when working on a keyboard can be an annoyance, hence having this option on the keyboard is a blessing. Further, users can use the arrow keys to move through the menu and press enter to select the desired option. To check the fly-out menus the right arrow can be used.

excel options

  1. Ctrl + shift + [desired function key]

The control + shift buttons help in inserting various functions in the worksheet with ease. To insert the current time, click Ctrl + Shift +; Users can format the date and time on their worksheet by inserting desired function key along with Ctrl + Shift buttons.

date

The Ctrl + Shift + = will open the insert cells options. Ctrl + Shift + W will wrap the text. Ctrl + Shift + 7 will select the border or outline of the worksheet. Ctrl + Shift + # will apply the date format with the day, month, and year. The new Ctrl + Shift shortcuts with various helpful combinations make the task of managing the Excel worksheet much easier.

  1. Ctrl + F1

When working on the worksheet, the ribbon can be distracting or encroach on the workspace. The problem can be handled deftly by pressing the Ctrl + F1 shortcut, which hides the ribbon. Pressing the shortcut again will make the ribbon visible once again.

weight tracker

  1. F2

To edit the current working cell just click on the F2 button on the keyboard. Users can not only edit the active cell but can also efficiently position the insertion point at the end of the cell contents with ease using this shortcut.

f2

Clicking on the F2 button helps in moving the insertion point into the Formula Bar when editing in a cell is turned off. To display the print preview area on the Print tab in the background, combine Ctrl and F2 keys.

  1. F4 or Ctrl + Y

When the user has to repeat a complicated command previously applied to the Excel Worksheet, pressing the F4 key will do the job. The shortcut repeats the last command except in some cases where the action cannot be repeated through the shortcut. The shortcut F4 will also deftly cycle through all the combinations of locked and unlocked locations or data when a formula in a cell is being edited.

For example – if the last function was to strike through a column on the to-do list with the shortcut key Ctrl + 5, the action can be repeated by pressing the F4 key with ease. When working on an excel worksheet, it is very convenient to have a shortcut to repeat the last formatting action for complicated, lengthy functions with just a click of a button, saving time.

  1. F6

When working with Microsoft Excel, users often have to switch between the current worksheet, task pane, zoom-in, zoom-out controls, and ribbon to select various functions. Reaching out for the mouse for selection can be tedious, but fortunately,y the shortcut key F6 comes to the rescue. When the user has split the worksheet into more than one pane, the shortcut will include the split panes when switching between different areas.

  1. F12

Nothing can be more frustrating than the hard work lost when the user fails to save the file, especially if it is data entered on Spreadsheet. The right thing to do is use the shortcut F12, which brings up the save as an option for the file. It saves the user lot of unnecessary functions which leads to the save option.

save

  1. Ctrl + Enter

Another useful excel shortcuts include the combination of the Ctrl + Enter key, which fills the selected cell range with the contents of the current entry. By using the shortcut, the contents of an edited cell can be automatically exported to other selected cells.

  1. Ctrl + Alt + V

It is easy to remember this particular shortcut since everyone is quite familiar with the Ctrl + V option, which is regularly used to insert the copied content of the clipboard at the desired point. For some of the complicated data used in the Excel worksheet, users may have to use Paste Special option. The shortcut Ctrl + Alt + V opens the Paste Special dialog box for pasting the cut or copied object, text, or cell contents on a spreadsheet. The copied content can be pasted in another program as well.

paste special

  1. Shift + Spacebar

Since every row in the Excel spreadsheet has an individual function, users may be required to select an entire row for a function. Using the shortcut Shift + Space makes the task easy. Once selected, changes can be applied to the whole row.

selection

To select a column use the shortcut Ctrl + Spacebar

  1. Alt

There is no argument that keyboard shortcuts are very useful while working on an excel spreadsheet. How about having a shortcut that opens up a menu of excel shortcuts on the ribbon? The alt button is the key that displays the Key Tips or new shortcuts on the ribbon of Microsoft Excel. For example, when you click on the Alt button, the options for new shortcuts on the ribbon open up – H for home, P for Page Layout, and M for Formula. When you further press Alt + M, the formula function opens up.

formulas

The alt key is also combined with various keys for creating different shortcuts, the most popular being Alt + F4 to close an open file.

  1. End

The End button, when used with an Excel worksheet, turns the End Mode on or off. This can be viewed in the bottom corner of the spreadsheet.

end mode

When the end mode is on, the user can press the arrow keys to move to the next blank cell in the column or row as required. Once the arrow key has been used to access the blank cell, the end mode turns off. The End button has to be clicked once again to activate it for further use. If the spreadsheet has only blank cells, then the shortcut moves to the last cell in the column or row.

The End button is also used to select the last command on the menu when a menu or submenu is visible.

  1. Enter

When the entry in the cell or the Formula Bar is completed, the user can select the Enter shortcut to complete the entry and move on to the next cell.

For example, when the date is entered in the column, the data entry for Rental Company can be accessed for editing by pressing the enter key.

excel template

When the spreadsheet is in the data format, the shortcut moves to the first field in the next record. It can be combined with different keys for accessing different excel shortcuts. For example, using the Alt + Enter shortcut will create a new line in the same cell.

information

  1. Esc

No matter how experienced you are, there are sticky places you get on the Excel worksheet from which the escape route will be through the shortcut button Esc. The shortcut is also used to cancel undesired, completed, or wrong entries in a cell or formula bar. If there are menus, submenus, message windows, or dialog boxes open, the shortcut will close them.

  1. F1

Finally, if the user is still at a loss and needs some help, F1 is the right shortcut for call out for help.

excel help

It opens the Excel help task pane, which has a search box where the user can seek help either offline or online.

too-much-technology

The list should help novice Excel users to get familiar with excel shortcuts, which will help them achieve the task quickly and easily.

Related Articles:-

Here are some articles that will help you to get more detail about the Excel Shortcuts, so just go through the link.

  1. Best Basic Excel Formulas
  2. Microsoft Excel Tips and Tricks
  3. How to Improve your Microsoft Excel Skills?
  4. Pivot Chart in Excel
Popular Course in this category
All in One Excel VBA Bundle (120+ Courses)
  120+ Online Courses |  500+ Hours |  Verifiable Certificates |  Lifetime Access
4.9
Price

View Course

Related Courses

Excel Training (23 Courses, 9+ Projects)4.9
Excel Advanced Training (16 Courses, 23+ Projects)4.8
Excel Data Analysis Training (17 Courses, 8+ Projects)4.7
74 Shares
Share
Tweet
Share
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Excel Charts
  • Excel Tips
  • All Tutorials
Certification Courses
  • All Courses
  • Excel VBA Course - All in One Bundle
  • VBA Course
  • Excel Data Analysis Course
  • Excel for Marketing Course
  • Excel for Finance Course
  • Excel for HR Training

ISO 10004:2018 & ISO 9001:2015 Certified

© 2022 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA
Free Excel Course

Excel functions, formulas, charts, formatting creating excel dashboard & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more