Excel: Getting around without mouse-madness — Business Management Daily: Free Reports on Human Resources, Employment Law, Office Management, Office Communication, Office Technology and Small Business Tax Business Management Daily

Excel: Getting around without mouse-madness

by on
in The Office Tech Pro

If you have attended any of our recent webinars on Microsoft Office applications, you have probably heard me tout the value of using keyboard shortcuts as time savers and accuracy boosters.

Another side benefit to navigating around your applications without scrolling is avoiding hand, wrist and elbow injuries which may result from repetitive strenuous motion, like excessive use of your mouse.
Microsoft Excel: Time-Savers for Every Skill Level
Here are 3 great tips to save your body and mind while working in Excel.

1. Use hotkeys to navigate your menus. Whether you are using 2007 or earlier versions of Excel if you simply tap your Alt key, you should notice the menu bar (97-2003) or ribbon (2007) change. In the earlier versions, you can now tap the underlined letter, such as F for File or W for Window and it will drop down the menu. From there just tap the underlined letter that indicates the selection you want to make, such as S for save or F for freeze panes, respectively.  In 2007, tapping the Alt key will reveal all the hotkeys available on the ribbon showing and your Quick Access Toolbar.





2. Use your Ctrl key and your arrow keys to navigate to the last non-blank cell in the column or row. For example, if you have data down to row 100, Ctrl+down arrow will stop there. Be aware if you are using this technique in a column or row with some blank spaces, it will stop before each one. Add the Shift key, so Ctrl+Shift+down arrow to select all the cells down to the last non-blank cell in the column. Add Ctrl+Shift+right arrow to the sequence and select an entire table. Hint: Ctrl+A or Ctrl+* will also select a whole table of data.


There's so much more to learn! Get all the concise Excel training you need in this colorful handheld document: Microsoft Excel: Time-Savers for Every Skill Level
3. Do you have a lot of data entry to do for which it would be a lot easier if Excel would simply drop the cursor to the right? You can change a setting in Excel to do this for a project or permanently if you choose. In 2003 and earlier versions, you’ll find it by navigating to Tools, then Options, then the Edit tab. Change the setting from down to right in the Move selection after Enter field. In 2007, you’ll find this by clicking the Office Button, selecting Excel Options and choosing Advanced. It will be the top option.




There are dozens of awesome shortcuts to make your life easier in Excel. What’s your favorite?
Look for great shortcut hints in the latest installment in my Office Technology Training series — Microsoft Excel: Time Savers for Every Skill Level.

The editors at Business Management Daily have turned not one but TWO training events into one easy-to-read Executive Summary. The first section will help you save time and hassle. The second will help you get the most out of Excel. See for yourself:

Part I: Ways to Improve Speed, Accuracy
1. Shortcuts, Tips & Tricks
2. Wrangling Worksheets
3. Typing Less in Excel
4. Time-Saving Templates
5. Troubleshooting Formulas

Part II: ‘Power Tools’ for Managing Data
1. Drilling Down to the Data You Need
2. Whipping Text Imports Into Shape
3. Macros – Reuse/Recycle
4. Vertical Lookup Functions

Get your copy today for just $39.95!

{ 2 comments… read them below or add one }

jaya October 29, 2012 at 12:24 pm

how to use shortcut keys for page preview

Reply

Raghu August 22, 2012 at 4:02 pm

Here are videos to show how you can work in Excel without knowing any formulas

1. How to change CASE in Excel

http://www.youtube.com/watch?v=w2JdQuybKjU&feature=plcp

2. How to Convert Columnar Data into Tabular Form

http://www.youtube.com/watch?v=dbHh41qMsHQ&feature=plcp

3. How to COLOUR Duplicate Rows in Excel

http://www.youtube.com/watch?v=oRckmKTRbYE&feature=plcp

4. How to Change UPPER & lower Case in Excel

http://www.youtube.com/watch?v=UQ6Ud8MgrfY&feature=plcp

5. How to Remove all DUPLICATES in Excel

http://www.youtube.com/watch?v=Nh-8D_AklwM&feature=plcp

6. How to REMOVE Extra SPACES in Excel

http://www.youtube.com/watch?v=A7lh1tX7EeY&feature=plcp

7. How to Remove NUMBERS & ALPHABETS in Excel

http://www.youtube.com/watch?v=GMj89gqizzA&feature=plcp

8. How to CLEAN Data in Excel

http://www.youtube.com/watch?v=zhFroHy8tqw&feature=plcp

The tool used is there on website http://exceladdins.net

Reply

Leave a Comment