Microsoft Office 2003 Killer Tips

by Stephenson, Kleber

• ISBN13: 9780735714373
• ISBN10: 0735714371
• Format: Paperback
• Copyright: 2005-01-01
• Publisher: New Riders Press

Summary

-Popular tips format provides instant answers and insider access to all of the features hidden within Office 2003!-Features more than 300 illustrated, stand-alone tips covering each of the suite's major apps: Outlook, Word, Excel, Access, PowerPoint, FrontPage, InfoPath, and OneNote.-Author Kleber Stephenson also wrote the enormously popular Microsoft Windows XP Killer Tips.

Table of Contents

CHAPTER 1 A Day at the Office	1	(16)
Get the Most Out of Office 2003
Turn Off the Task Panes	2	(1)
They're Expandable	2	(1)
Task Panes on the Move	3	(1)
Quick Menu Expand	3	(1)
Customize Your Menus	4	(1)
Keep the Fun Rollin'-Customize your Toolbars	4	(1)
Split the Toolbars	5	(1)
Open and Close Toolbars the Easy Way	5	(1)
Toolbars Getting Crazy...Reset'Em	6	(1)
Linking Your Buttons	6	(1)
Getting Geeky with Toolbar Buttons	7	(1)
The Move Button Trick	7	(1)
Side by Side...So Cool	8	(1)
Add Places	8	(1)
Show Small Icons in My Places Bar	9	(1)
Save It Here Instead	9	(1)
No Access...I'm Protected	10	(1)
Copy and Paste on Steroids	10	(1)
The Assistant's Got to Go	11	(1)
Help Me Made Easy	11	(1)
I'm Hung Up, But I'll Recover	12	(1)
Get Faster with Shortcut Keys	12	(1)
Research This!	13	(1)
Do-It-Yourself Repairs	13	(1)
Link Your Docs	14	(1)
You Can Cut, Paste, and Delete from Here	15	(2)
CHAPTER 2 Spread the Word	17	(48)
Working with Word
Print Word's Shortcuts	18	(1)
Repeat That Search	18	(1)
Instantly Open Your Last-Used Document	19	(1)
Customize Your Dictionary	19	(1)
Shortcut to Your Text	20	(1)
Word's Rising in the Charts	20	(1)
Flirting with Disaster	21	(1)
I've Only Got One Sheet of Paper	21	(1)
Keeping Up to Date with Fields	22	(1)
Super-Fast Time and Date	22	(1)
Turn Fields into Text	23	(1)
Stop Control-Clicking (It's Bad for You)	23	(1)
Find and Replace Using the Clipboard	24	(1)
Word's Super-Secret Work Menu	24	(1)
I Can Actually Select That Table	25	(1)
Oui, Oui-I Can Translate	25	(1)
Don't Just Paste It, Spike It	26	(1)
Smart Tags Really Are Smart	26	(1)
Print Like the Post Office	27	(1)
I Don't Use Avery Labels	27	(1)
Print a Portion	28	(1)
Backward Is Better	28	(1)
Give Me a Hundredth of an Inch	29	(1)
Groovy Menus	29	(1)
Send, Share, Compare	30	(1)
You're Restricted	30	(1)
Split and Edit	31	(1)
You Can Use Your Toolbars in Full Screen Mode	32	(1)
Word Hopping	32	(1)
Edit Multiple Pages	33	(1)
Save 'Em All, Close 'Em All	33	(1)
Navigating the Easy Way	34	(1)
Yay, Previews!	34	(1)
There's a Comparison to Be Made	35	(1)
Bookmarks Are Better	35	(1)
Need a Table of Contents?	36	(1)
Reading Layout's Got to Go	36	(1)
Lacking Creativity? Make It Work for You	37	(1)
Quick Print Preview	37	(1)
Autocorrect My Abbreviations? Cool!	38	(1)
Lots O' Lines	38	(1)
I Knew There Had to Be a Better Way	39	(1)
Tab Your Cells	39	(1)
Preserve Your Formatting	40	(1)
Excel's Got Nothin' on Word	40	(1)
It's All About the Plus (and Minus) Signs	41	(1)
A Template of Your Very Own	41	(1)
Splitting Up Isn't Hard to Do	42	(1)
Shrink Your Document	42	(1)
I've Made a Mistake	43	(1)
Undo It All	43	(1)
Pick the Pilcrow	44	(1)
Customize Your Bullets	44	(1)
I Need a Little Room	45	(1)
Type It Again	45	(1)
That's Not Page One	46	(1)
Save That Table Size	46	(1)
Control Your Column Widths	47	(1)
AutoFit Just One Column	47	(1)
Find All the Same	48	(1)
Quick Synonyms	48	(1)
It's All in the Line Number	49	(1)
In Summary...	49	(1)
Give the Scraps to Your Desktop	50	(1)
Resume or Resume	50	(1)
Remembering Shortcuts	51	(1)
Want Control Over Your Text? Then Shift	51	(1)
Editable Print Previews	52	(1)
Quick Case	52	(1)
Picky Selections	53	(1)
Fake It, Dummy	53	(1)
The Easy Way to Get Text Above Your Table	54	(1)
Voice Your Comments	54	(1)
Drag, Hover, Drop	55	(1)
Now You See Me, Now You Don't	55	(1)
The Key to Tests	56	(1)
AutoColor	56	(1)
Edit Cycling in Word	57	(1)
F8 to Extend	57	(1)
Click It, Then Type It	58	(1)
Personalize Your Envelopes	59	(1)
Super-Charge Word's Performance with Placeholders	59	(1)
Quick Graphic Resize Trick	60	(1)
Resizing the Right Way	60	(1)
Be Exact	61	(1)
Getting Precise with Word's Grid	61	(1)
Not Your Ordinary Text Box	62	(1)
Adding Captions	62	(1)
I Need More AutoShapes	63	(1)
Getting Precise with AutoShapes	63	(2)
CHAPTER 3 Bright Outlook	65	(46)
Working with Outlook
Protect Your Personal Folders	66	(1)
Just Start Up	66	(1)
Same Email...Different Computers	67	(1)
Be Choosy with Field Chooser	68	(1)
Sort Your Mail	68	(1)
Email Shortcut	69	(1)
I've Got Things to Do	69	(1)
Fast Track to the Inbox	70	(1)
Organize Your Messages Quickly	71	(1)
Easy Edit	71	(1)
Keep Email Consistent	72	(1)
Drag-and-Drop Your Attachments	72	(1)
Control-Click Hyperlinks	73	(1)
Email Your Notes	73	(1)
Sticky Notes...Really!	74	(1)
Choose an Account	74	(1)
Track Down the Personal Folders	75	(1)
Personalize Personal Folders	75	(1)
Un-Junk Email	76	(1)
Can't Spell?	76	(1)
Save Your Searches	77	(1)
Collapsible Groups	77	(1)
Even a Folder Needs a Home (Page)	78	(1)
Maximum View	78	(1)
Start Up Where You Want	79	(1)
Launch Outlook at Startup	79	(1)
Don't Dump It, Archive It Instead	80	(1)
Snag Stationery	80	(1)
Compare Folders	81	(1)
Get Rid of the Junk	82	(1)
Outlook's Hidden Help	82	(1)
Auto-Sort Email	83	(1)
Web Browsing with Outlook	84	(1)
Single Task, Multiple Categories	84	(1)
A Reading Pane You Can Actually Read	85	(1)
A Reminder to Turn Off Reminders	85	(1)
Using Shortcuts in Outlook	86	(1)
Get Rid of J	87	(1)
You've Got Mail...Sounds	87	(1)
Back Up the Bad	88	(1)
Sign It	88	(1)
Flag It	89	(1)
Follow-Up Flags	89	(1)
Color-Code Messages	90	(1)
Bcc Groups	90	(1)
Don't Reply There	91	(1)
Request a Receipt	91	(1)
Show Only the Unread	92	(1)
Oops, I Didn't Mean to Send That	92	(1)
Zip It!	93	(1)
Quick, Send Webpages	93	(1)
You've Always Got Mail	94	(1)
You've Been Notified, You've Got Mail	94	(1)
No Office? No problem!	95	(1)
Right-Click Contacts	96	(1)
Right-Click Attachments	96	(1)
You're Annoying	97	(1)
You're Safe	97	(1)
Quick Junk Button	98	(1)
Turn Off the Reading Pane	98	(1)
Sort the Junk with AutoPreview	99	(1)
Stop Desktop Alerts	99	(1)
Let 'Em Vote on It	100	(1)
Print Your Contacts	100	(1)
I Prefer Nicknames	101	(1)
Check a Contact's Activities	101	(1)
Find a Group of Contacts	102	(1)
Get Directions	102	(1)
You Can Picture It	103	(1)
Quickly Add to Contacts	103	(1)
Categories Can Remind You	104	(1)
Don't Just Reply, Send an Instant Message	104	(1)
Forward a vCard	105	(1)
Snail Mail Your Contacts	105	(1)
Quickly Create Appointments	106	(1)
Print Blank Calendars	107	(1)
Share Your Calendars	108	(1)
I Need My Weekends	109	(1)
Master Time Zones	109	(2)
CHAPTER 4 Power(ful)Point Of View	111	(38)
Working with PowerPoint
Changing Colors	112	(1)
Snag Slides	112	(1)
Deliver the Package	113	(1)
Begin or End in a Flash	113	(1)
Tab a Bullet	114	(1)
Shift to Slide Master	114	(1)
Master Your Presentation	115	(1)
Don't Print, You're Hidden	116	(1)
Quick Copy	116	(1)
Web It	117	(1)
Don't Forget to Embed	117	(1)
That's Perfect!	118	(1)
Global Font Replacement	119	(1)
Super-Fast Shapes	119	(1)
More and More Shapes Made Easy	120	(1)
Perfectly Spaced Shapes	121	(1)
Give Me More Guides	122	(1)
Picture This!	123	(1)
Options Are Great!	123	(1)
Word Presentations?	124	(1)
Link'Em	124	(1)
Size Down	125	(1)
Take a Picture	126	(1)
Control the Shadows	127	(1)
Super-Fast Symbols	128	(1)
Kiosk Cool	128	(1)
Mix It Up	129	(1)
Can't Miss That Logo	129	(1)
It's Good to Take Notes	130	(1)
Giddyap	130	(1)
Don't Just Flip, Transition	131	(1)
Pixel Pushing	132	(1)
Power Albums	132	(1)
Summary Slide	133	(1)
Blackout	134	(1)
Objects Too Small?	134	(1)
Give Credit	135	(1)
Can You Spell Business?	136	(1)
Become a Template Designer	137	(1)
Don't Cut, Crop Instead	138	(1)
We're Connected	139	(1)
I'd Like to Comment	140	(1)
Quickly Animate Objects	141	(1)
More Templates	142	(1)
I'm Compressed!	142	(1)
Preview and Edit	143	(1)
Quick Notes	144	(1)
Customize Your Customers	145	(1)
Don't Have Transitions for the Web?	145	(1)
Quick Defaults	146	(3)
CHAPTER 5 Time To Excel	149	(56)
Working with Excel
Stop Flinching	150	(1)
Gettin' Crazy with Backgrounds	151	(1)
Whoa, That's a Different Worksheet	152	(1)
Centering Text	153	(1)
A Quicker Calculator	154	(1)
It's Picture Time	155	(1)
Take a (Real) Picture	156	(1)
My Favorite Workbook, Right Away	157	(1)
ABC's to 123's	158	(1)
Better Prints	159	(1)
Control Your Prints	160	(1)
It's Time to Break Up	161	(1)
A Familiar Print	162	(1)
Print a Workbook Range	163	(1)
Am I Rich Yet?	164	(1)
You Could Save a Pence	165	(1)
It's a Random Thing	166	(1)
.2989345?	167	(1)
Share Your Formatting	168	(1)
The Title's the Same	169	(1)
How Long Til My Birthday?	170	(1)
Quick Calculations	171	(1)
Total Your Worksheets	172	(1)
Another Quick Calculation	173	(1)
Quick Lists	174	(1)
More Quick Lists	175	(1)
My Own Quick Lists	176	(1)
I Want More	176	(1)
Movable Data	177	(1)
Protect Your Worksheets	178	(1)
Be Impatient	179	(1)
Freeze!	180	(1)
In the Red	181	(1)
Wrap Text	182	(1)
It Looks Cool, So It Must Be Done	183	(1)
Share (Kind Of)	184	(1)
Do You Validate?	185	(1)
Give Me Fractions	186	(1)
Check All of My Spelling	187	(1)
The Formula to Comments	188	(1)
Wingdingin' It	189	(1)
Excel Can Be Lonely	190	(1)
Let's Hook Up	191	(1)
Quick Graphs	192	(1)
Jumpin' Here, Jumpin' There	193	(1)
Smart Navigation	193	(1)
Power Sharing	194	(1)
Hide Worksheets	195	(1)
Don't Forget the Pixels	196	(1)
Case-Sensitive Sorts	196	(1)
Select Large Ranges	197	(1)
Show Off Your Formulas	198	(1)
Remember to Color Code	199	(1)
"Watch" Your Window	200	(1)
Don't Save the Geek-Speak	201	(1)
Paint Columns and Rows	202	(3)
CHAPTER 6 Easy Access	205	(28)
Working with Access
Your Very Own Tooltips	206	(1)
It's Your Default	207	(1)
I'm Important!	207	(1)
Say No to Snap to Grid	208	(1)
Instant Fit	208	(1)
Can You Picture It?	209	(1)
The Object of Shortcuts	210	(1)
Access Specifications	211	(1)
All I See Are Asterisks	211	(1)
Don't Import-Link	212	(1)
Take It to the Web	213	(1)
Menu Bar Objects	214	(1)
Don't Double-Click	214	(1)
Zoom Zoom	215	(1)
Instantly Launch a Form	215	(1)
Instantly Launch a Record	216	(1)
Get Your Tabs in Order	217	(1)
Hidin' Out	217	(1)
A Better View	218	(1)
How's Your Relationship?	219	(1)
Line 'Em Up	220	(1)
Quick Calendar	221	(1)
A Better Preview	222	(1)
Shift Size	223	(1)
Title Pages Made Easy	224	(1)
Can't Close	225	(1)
Can't Add	225	(1)
Set the Timer	226	(1)
What's This?	227	(1)
Gettin' Around	227	(1)
Super-Fast Append	228	(1)
Report Snapshot	229	(1)
Analyze This!	230	(1)
Quick Dates	230	(1)
One-Click Excel	231	(2)
CHAPTER 7 Get Published	233	(20)
Working with Publisher
Edit in Word	234	(1)
Delete the Whole Thing	234	(1)
Navigate Web Publications	235	(1)
Customize Color Schemes	235	(1)
Get Personal	236	(1)
Control Groups	237	(1)
That Should Be a Picture	237	(1)
The Key to the Web	238	(1)
Headin' to the Printers	238	(1)
Publisher-Friendly Printers	239	(1)
I've Been Framed	239	(1)
Flowing Text	240	(1)
Transparent Shapes	241	(1)
Paint Your Formatting	241	(1)
Don't Stress Over Fonts	242	(1)
What Are Your Measurements?	243	(1)
Drag, Drop, Move	244	(1)
Drag-and-Drop Duplicates	245	(1)
Faux Frame	246	(1)
Line Up	247	(1)
Exact Rotation	247	(1)
Find the Right Words	248	(1)
Rulers Anywhere	248	(1)
Wrap Text	249	(1)
Recolor Pictures	250	(3)
Index	253