 January 2009 Issue #48 |
| | | Happy New Year! | 
Whether or not you made a resolution to be more productive and organized this year, it's likely that you will need to continue to save time and to discover new, easy ways to accomplish your work in these challenging times. To be a part of the solution for you, one of my goals this year is to expand the useful tips, handy shortcuts, and valuable how-to lessons that will help you to make the most of the programs on your desktop. Look in this and future issues for great ways to be more productive...and, hopefully, less stressed! Wishing you a world of happiness in the New Year! |
|  | | | | Feature Article | 5 Easy Ways to Manage Excel Worksheets  (Excel 2007 & Excel 2003)
1. Quickly Move to a Worksheet
To quickly navigate to a worksheet in an Excel workbook, right-click on any of the 4 triangle navigation buttons (located immediately to the left of the worksheet tabs) to display a pop-up menu of worksheet names.
2. Move Between Worksheets in a Workbook
With up to 1,024 worksheets possible in a Microsoft Excel 2007 workbook (255 in Excel 2003), try these keyboard shortcuts to toggle or cycle between worksheets:
- Next worksheet: [Ctrl] + [Page Down]
- Previous worksheet: [Ctrl] + [Page Up]
 3. Insert a New WorksheetJust press [Shift] + [F11] to create a new worksheet. 4. Easy Worksheet Management
Right-click on any sheet tab (Sheet1, Sheet2, etc.) for a shortcut menu of worksheet options. This is a quick way to rename, delete, add, apply colors to worksheet tabs, copy, and more.
By the way, you can also rename a worksheet by double-clicking on any sheet tab (Sheet1, Sheet2, etc.) to highlight the sheet name. Type a new name and press [Enter]. Tip: avoid ALL CAPS which increases the width of the sheet name.
5. Fast Worksheet Copy How do you copy a worksheet with a master format such as a quarterly or monthly layout? Please don't say copy and paste! This choice does not give you an exact copy and you'll waste time trying to re-format columns and re-create other formatting. Although the worksheet tab shortcut menu is one way to copy a worksheet, especially across workbooks, a fast easy approach is to hold [Ctrl] while dragging a worksheet tab to a new location in the workbook. Your mouse pointer will look like a page with a plus (+) sign. Release the mouse first and then [Ctrl] to see the new worksheet. Finish by renaming the copy. 
|
| Quick Tips & Tactics | Office 2007: Minimize the Ribbon The Office 2007 Ribbon can be minimized so it is not visible while you are working in a document. Try one of these tips: - Double-click on the active tab. Double-click on any tab to re-display the Ribbon.
- Minimize the Ribbon using the [Ctrl] + [F1] toggle which leaves only the tabs.
Press [Ctrl] + [F1] again to restore the Ribbon. - Right-click the Ribbon, Office button, or Quick Access toolbar and select Minimize the Ribbon from the shortcut menu. Repeat again and uncheck the option to restore the Ribbon.
- Click on the drop-down arrow at the right end of the Quick Access toolbar and choose Minimize the Ribbon.
Word 2007 Keyboard Shortcut for Zoom Question: Hi Dawn, I printed out the keyboard shortcuts for Word, Excel, Access, PowerPoint, and Publisher for Microsoft Office 2007. (Note: keyboard shortcut handouts available at: http://www.softwarepro.com/tips/handouts.htm). I could not find the shortcut for Zoom in Word. Does Zoom have a keyboard shortcut? Answer: Yes, there is a keyboard shortcut for Zoom in Word but it isn't intuitive. Here are the steps (actions are similar in other Office 2007 programs): - Press [Alt] + W, and then press Q.
- Press the [Tab] key repeatedly until the Percent box is selected, and then type a percentage or press [Up] arrow or [Down] arrow to select a percentage (or type a value for the percent).
- [Enter] to enable your zoom selection.
|
| Mouse Bytes | Speaking of Excel...Spreadsheet Jokes Ready for an "interesting" sense of humor? Check out these Excel and spreadsheet jokes...if you dare. The world's largest collection of spreadsheet humor on the Web...also, likely the only collection of spreadsheet humor on the Web. Offered by John Walkenbach, author of a number of great Excel books. |
Latest Software Productivity Guide | Word 2007: How to Simplify Long or Complex Documents 
Timesaving Solutions for Microsoft Word 2007 Now available in digital download format (PDF), printed full-color learning guide, or both! |
| About Dawn | Dawn Bjork Buzbee is The Software ProŽ with over 25 years experience transforming geek speak into people friendly. A professional software speaker, trainer, consultant, and author, Dawn has helped more than 100,000 individuals to learn smart, easy, and productive ways to use software and technology more effectively.
Microsoft has awarded Dawn with the certification of Microsoft Certified Application Specialist (MCAS) Instructor for her expertise in Microsoft Office 2007 and Windows Vista. Dawn also holds the distinctions as a Certified Microsoft Office Expert and a Certified Microsoft Office Specialist Master Instructor with a proven track record in Microsoft Word, Excel, Outlook, PowerPoint, and Access. >>Find out more |
| |
|
|
