We live in a fast paced world. Every day, we are inundated with seemingly infinite amounts of data and numbers, especially in an office setting. Many people whose job it is to deal with and organize these figures utilize Microsoft Excel 2010. This portion of the Microsoft Office program enables the user to create spreadsheets and tables that are helpful in presenting data in an orderly fashion. Its numerous features may be accessed by way of several shortcuts that save users time and help them navigate Excel 2010 efficiently and effectively.
Enabling one to fill out spreadsheets is one of Excel’s specialties, and there are several keyboard shortcuts that will save you time and make the process even simpler. When you are moving between spreadsheets, pressing Ctrl + Page up will take you to the previous worksheet in the file. As you might expect, Ctrl + Page down will move you to the next sheet in the file. While navigating inside one particular worksheet, Ctrl + F9 minimizes the current worksheet. Ctrl + F10 will maximize it, while Ctrl + P brings up the backstage view in order to print the document.
Shortcuts also allow the user to enter information into cells quickly and efficiently. You will see that by pressing Ctrl + Shift + the semicolon keys you may insert the current time into the selected cell. Ctrl + the semicolon key inserts the current date. By combining Alt + =, you are able to insert a formula that adds up the value of a column of numbers as long as there are no gaps between the cells. In a selected cell, if you hold down Ctrl + K, you may insert a hyperlink into it.
Microsoft Excel 2010 is helped greatly by the ribbon that appears at the top of the page. Simply pressing F1 will make the Excel Help task pane appear. Holding down Ctrl + F1 either brings the ribbon up or hides it. Using a slightly different key combination, an embedded chart made up of data in the current range is created by using Alt + F1. By pressing Alt + Shift + F1, you may insert a new worksheet.
It is rather apparent that Ctrl, Alt, and Shift play large roles in performing the shortcuts stated. Users familiar with previous versions of Microsoft Excel will find this to be common knowledge. There are of course plenty more shortcuts featured on Microsoft Excel 2010. Those listed above are some of the most popular and will do much to familiarize you with the navigation of Excel 2010.
Now Try – Excel Courses
Leave a Reply