OnlinePCTips.com

PC Tips and Tricks to make your life easier
Subscribe

Excel – How To Save Time Using Shortcuts

May 28, 2011 By: lilybird Category: Software

In today’s hyper-speed world, endless streams of data and figures bombard us on a daily basis, especially in the office. As many people know by now, one of the most popular methods by which to gather these numbers in order to present them graphically and in an orderly fashion is with the help of Microsoft Excel 2010. Helpful spreadsheets and tables are created using this Microsoft Office program, and there are many features to be found on it. There are a few time saving shortcuts and features that will allow you to navigate Excel quickly and efficiently.

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.

The ribbon at the top of the page is an integral part of Microsoft Excel 2010. F1 brings up the Excel Help task pane. Pressing Ctrl + F1 will either display or hide the ribbon. A slight alteration, using Alt + F1, will create an embedded chart consisting of data in the current range. If you wish to insert a new worksheet, then you may do so by pressing Alt + Shift + F1.

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

Leave a Reply