Microsoft Excel Shortcuts
In the fast paced world in which we live, we are bombarded with an interminable amount of data and numbers, and those in the business world know this only too well. As many who work with data for a living are aware, one of the most popular methods by which to gather these figures into readable tables and spreadsheets is Microsoft Excel 2010. This program makes it easier than ever to compose graphic organizers so that others may make sense of otherwise mind boggling information. Because there are a great number of features provided by Excel 2010, there are almost as many shortcuts that allow the user to save time.
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.
As in previous versions of the program, Microsoft Excel 2010 makes heavy use of the Ctrl, Alt, and Shift keys in its shortcuts. Many shortcuts will therefore be familiar to users of prior Excel programs. As you may know, there are plenty of other shortcuts for Excel, but those herein are some of the most common and most used, saving you time while utilizing the program?s many features.
Now Try – Excel Courses
.gif "Free Traffic System - Increase Targeted Website Traffic with Free
Unlimited One Way Links")
