Related Articles

If you work in an office, chances are you use Microsoft Excel frequently. In fact, you may spend a whole day working on one workbook with its various spreadsheets. Learning a few shortcuts can help you increase your productivity in Excel by reducing the amount of time you take to do a task.

1. Click the box next to the label "Clipboard." This keeps the clipboard visible and enables you to copy and paste more quickly.

2. Select large sections of the worksheet more quickly. Click the top-left corner of the selection, scroll to the bottom-right corner, hold "Shift" and click your mouse to select the area between these two corners. This is much faster than clicking and dragging with the mouse.

3. Create macros for tasks you do frequently and assign them a button or keyboard shortcut. The "Record Macro" function is in the "Developer" tab under the "Code" group. Enter all the keyboard functions you want to include in the macro, then click "Stop Recording."

4. Memorize formulas or functions you use often, or write them down on a sticky note near your monitor.

About the Author

Michael Smathers studies history at the University of West Georgia. He has written freelance online for three years, and has been a Demand Studios writer since April 2009. Michael has written content on health, fitness, the physical sciences and martial arts. He has also written product reviews and help articles for video games on BrightHub, and martial arts-related articles on Associated Content.