-------------------------------------------------------------------
THE OFFICE LETTER
STANDARD EDITION
Tips, Tricks, Tools, and Techniques for Microsoft Office
Volume 4, Number 18 October 18, 2004
-------------------------------------------------------------------
IN THIS ISSUE
1) Excel: Range Names - Another Shortcut
2) Resources: Word Keyboard Shortcut Cheat Sheets
3) Word: 2005 Calendar Templates
4) Excel: Security Updates Released
Premium Edition Extra:
Excel: Hiding Rows with a Macro
-------------------------------------------------------------------
1) EXCEL: RANGE NAMES - ANOTHER SHORTCUT
-------------------------------------------------------------------
There seems to be no limit to the tips readers can find for range
names. Here's the latest, from TOL reader Jandy Warner.
Hi, I enjoy your newsletter very much. A quick way to name a
range is to highlight it with this shortcut:
1. Click on any cell in range.
2. Press and hold CTRL and SHIFT as you tap the "8" key at the
top of the keyboard. (For some reason this won't work if you
use the number pad.)
3. Click in the Name Box (it's just above cell A1 -- I sometimes
think of it as the "you are here" box).
4. Type the range name and press Enter.
The reason the "8" on the numeric keypad doesn't work is that by
pressing the Ctrl and Shift key down, you're using the equivalent
of Ctrl + * (the asterisk is a shifted "8"). If you use hold down
the Ctrl key and press the asterisk key on the numeric keyboard,
you'll find that the keyboard combo will also select the current
range.
Note, too, that in our original example two issues ago, we used the
Insert/Name/Create command to create TWO ranges (one for each
column, using the column header row for the range name). Jandy's
technique creates a single name for the ENTIRE range, including the
headings.
-------------------------------------------------------------------
GET THE WHOLE ENCHILADA!
-------------------------------------------------------------------
The new Camtasia Studio Add-in records all the richness of your
PowerPoint presentation. Preserve all animations, transitions, and
sound effects -- even your live audio and on-the-fly annotations!
Share your recorded presentation in the format that best suits your
audience, including Web site, CD, Flash or streaming video.
To find out more and download a free trial, visit us at:
http://www.techsmith.com/products/studio/powerpointaddin.asp?BAC-Office
-------------------------------------------------------------------
2) RESOURCES: WORD KEYBOARD SHORTCUT CHEAT SHEETS
-------------------------------------------------------------------
Our friends at KeyLogix, makers of ActiveDocs document automation
software (reviewed two weeks ago), have kindly provided two cheat
sheets for Word keyboard shortcuts you can download for free.
The first is the old-fashioned keyboard template you can print and
lay over (or above) your keyboard's function keys:
http://www.officeletter.com/samples/v04n18wordkbdtemplate.doc
The second is a list of Word's keyboard shortcuts:
http://www.officeletter.com/samples/v04n18wordkeybdlist.doc
Thanks, KeyLogix.
-------------------------------------------------------------------
3) WORD: 2005 CALENDAR TEMPLATES
-------------------------------------------------------------------
Microsoft recently released several 2005 calendar templates for
both Word and PowerPoint. You can find them in the online template
gallery:
http://office.microsoft.com/en-us/templates/CT011371131033.aspx
Unfortunately, the files are in a compressed format that many
readers may find difficult to expand. We've enhanced the Word 12-
month calendar and posted it for a simple download (no
decompressing needed) here:
http://www.officeletter.com/samples/v04n18calendar2005.doc
-------------------------------------------------------------------
BACKUP YOUR DATA WITH ZIPBACKUP
-------------------------------------------------------------------
Finally, a backup program that is easy to use and backs up
to standard Zip files on CDs, DVDs, or any other disk.
The ZipBackup Wizard is a snap for beginners. Filtering,
scheduling and disk spanning make it a powerful tool for
experts.
For a limited time, Office Letter readers receive 25% off
the regular price, plus a FREE 30 day trial at:
http://www.zipbackup.com/partners/officeletter
-------------------------------------------------------------------
4) EXCEL: SECURITY UPDATES RELEASED
-------------------------------------------------------------------
Microsoft released security updates to several programs last week.
Of interest to Office users is Microsoft Security Bulletin MS04-
033, "Vulnerability in Microsoft Excel Could Allow Remote Code
Execution."
Which users should be concerned? It's a mishmash. If you've
installed Office 2000 Service Pack 3 or Office XP Service Pack 2,
then you need to download a fix. If you use Office XP without any
service packs, or have installed Office XP SP1 or SP3, you're safe,
the company says. There's no mention of Office 97.
Once again the vulnerability centers around the ability for another
user to take control of your system. "If a user is logged on with
administrative privileges, an attacker who successfully exploited
this vulnerability could take complete control of an affected
system, including installing programs; viewing, changing, or
deleting data; or creating new accounts with full privileges. Users
whose accounts are configured to have fewer privileges on the
system would be at less risk than users who operate with
administrative privileges."
You can get the full details at Knowledge Base article 886836:
http://www.microsoft.com/technet/security/bulletin/MS04-033.mspx
-------------------------------------------------------------------
EASY-TO-USE WEB HOSTING FROM $9.95
-------------------------------------------------------------------
All plans include 24/7 technical support, unlimited e-mail, state
of the art web site builder, control panel admin, FrontPage and ASP
support. Domain names just $12.95. No contracts required, and
we'll set you up for FREE in under 20 minutes. Sign up today at:
http://www.officeletter.com/thehostgroup.html
-------------------------------------------------------------------
PREMIUM EDITION EXTRAS THIS WEEK
-------------------------------------------------------------------
This week Premium Edition subscribers receive an Excel macro that
hides rows that match user-defined conditions.
Why not subscribe to the Premium Edition today for just $12/year?
HTML format, extra content, access to all back issues, a fast
search engine, a printer-friendly format option, and no
advertising! Visit:
http://www.officeletter.com/subscribe.html
-------------------------------------------------------------------
CONTACT POINTS
-------------------------------------------------------------------
SUBSCRIPTION CHANGES
Your subscription record shows the following:
Email address: [EMAIL PROTECTED]
First name: subscriber at [EMAIL PROTECTED]
Last name:
Full name:
If you would like to edit the above data, click here:
http://www.office-letter.com/cgi-bin/mmp/[EMAIL PROTECTED]
To unsubscribe, visit:
http://www.officeletter.com/sub/substdremove.html
and enter your e-mail address.
SHARE YOUR TIPS: Send them to [EMAIL PROTECTED] and include
your permission to acknowledge you by name.
FEEDBACK: Send your suggestions and comments about The Office
Letter to [EMAIL PROTECTED]
RECOMMEND THE OFFICE LETTER TO YOUR FRIENDS AND COLLEAGUES
Point them to http://www.officeletter.com/current.html
MORE FREE TECH E-NEWSLETTERS: http://www.techletters.com
----------- THE OFFICE LETTER ----- www.officeletter.com ----------
Tips and Tricks for Microsoft Office - Published Weekly
Copyright 2004 Masterware, Inc. All rights reserved
Now In Our Fourth Year - ISSN: 1543-5768
Editor in Chief: James E. Powell
Contributing Editors: Jim Boyce (www.boyce.us)
Dick Archer (www.diseno.com)
