Picture Perfect Envelopes
In connection to a tip I ran last week about changing the font, in MS Word, on an envelope or label, a reader wrote in wondering how to add pictures to envelopes.
Good question!
So this week I went in search of an answer—and thankfully, I found one.
(I also figured that if one person is interested enough to write in then there must be others that… Continue reading
But I Don’t Want To Print The Whole File!
Have you ever found yourself trying to print only a few pages of a long file?
Maybe you made changes to only one page and need just it—not the other 42.
Sound like a familiar situation?
If your answer is “Yes!” then here’s the solution to your problems.
Next time you go to print and need only a portion of the… Continue reading
Comments | Filed under: MS Office Help |
Toolbar Reset
In several issues of MS Office Tips & Tricks we’ve covered many different ways to alter your toolbars.
Have you made some changes that you regret?
Maybe you’ve made enough of them that you’d like to “wipe the slate clean” and start over with a particular toolbar.
Or, maybe someone else has recently made changes that you’d like removed.
Is there a way to return to the original… Continue reading
Comments | Filed under: MS Office Help |
Accessing The Recently Used File List With Your Keyboard
As we all know, in the MS Office programs there’s a list of recently used files at the bottom of the File menu.
Most people access these with the mouse—not a bad way, works well—but did you know that you can accomplish the same task with just a few keys?
No?
Well, you can, so let’s get to the “how” part.… Continue reading
Comments | Filed under: MS Office Help |
Now Where Did I Put That File? What Did I Call It?
Ever find yourself wondering these exact things?
I know I have and it’s a big pain when I’ve lost something I’ve recently worked on but can’t seem to relocate.
If you’ve gone through this, then you already know how quickly files seem to rotate off the Recently Used File list at the bottom of the File menu.
Then… Continue reading
Comments | Filed under: MS Office Help |
List of More Keyboard shortcuts for MS Word
Here’s another installment to add to your ever-growing list of keyboard shortcuts for MS Word.
Give these a whirl—they could come in very handy!
Justification Shorcuts:
Show Me The… Formulas?
I don’t know about you but when I’m trying to proofread a document I usually need to go through a hard copy. For some reason seeing things in printed form will usually help with that whole process.
So, what do you do when you’re trying to proof an MS Excel worksheet?
You can print it out, but let’s face it. What you get in the printout… Continue reading
Double-Click = Best Fit
As many MS Excel users are aware you can highlight a column and through the Format menu, Column sub-menu you can choose the AutoFit Selection choice. What this does is make the column just wide enough to fit the longest piece of data in the selection.
It’s a great thing—no guessing necessary to make the data fit.
However, we all like a faster way and for… Continue reading
Jazz Up Your Tables In MS Word
How would you like, with only a couple of clicks, to change this ordinary MS Word table
into this…
or maybe this…
or any of over 3 dozen styles?
Sound too good to be true?
Well, maybe it does, but let me assure you it is 100%, absolutely true!
Want to know how?
Yeah—of course you do. After all… Continue reading
PowerPoint Key Combinations
For all my keyboard enthusiasts I thought I’d include a short list of key combinations that are for MS PowerPoint.
Editing Shortcuts (In addition to the regular shortcuts for copy, paste, bold, Italics, etc…):
Comments | Filed under: MS PowerPoint |
I Put What In The Custom Dictionary? Now How Do I Get That Out Of There?
Here’s the scenario…
You’re running a spell check in MS Word, cruising along and suddenly you realize that you just accidentally clicked the Add button in the spell check window.
In other words, you just added your misspelled word to the custom dictionary. Now the incorrect spelling will be accepted as correct.
What do… Continue reading
You Don’t Have To Be Webster To Write Your Own Dictionary?
Most people know about the Spell Check feature of the MS Office Suite. In fact, we (myself included) find ourselves using it constantly.
It’s a wonderful tool, provided that it’s not your only set of “eyes” proofing your document.
At any rate, have you ever had a word that you constantly use but the program keeps suggesting that it’s… Continue reading
Comments | Filed under: MS Office Help |
Let’s Get Organized
Have you ever found yourself in MS Word, Excel or PowerPoint trying to use drawing tools to create an organization chart?
How did it go?
I’ve tried it in the past and it was a pain.
It was better than hand drawing one, but it was a constant struggle to group and ungroup things, keep everything on one page, draw connectors that are actually connected, move things… Continue reading
Comments | Filed under: MS Office Help |
Add-ins? Oh No – I Hated Math Class!
Don’t worry – no need to break out in hives – add-ins have nothing to do with the high school math class that seems to be still haunting you.
Add-ins can be wonderful little computer helpers.
Actually, the best definition probably comes from the online help provided with the programs, so… let’s use that one.
Add-ins are supplemental programs that extend the… Continue reading
Comments | Filed under: MS Office Help |
Psst… What’s The Password?
Have you ever had a MS Word or Excel file that you just didn’t want anyone to read? Or maybe it was OK for them to read it but not change it.
I know I have a few of these. Being a teacher it’s nice to be able to protect files containing tests. You know, just in case a student gets in them.
Anyway, I’m sure… Continue reading
Read-Only? Huh?
Ever see or hear the term “read-only” and wonder what it was all about?
If that’s you, then it’s time to put your mind at ease. (Not that you were losing sleep over it or anything, but it’s always good to know what the computer guy is talking about.)
To put it concisely, a read-only file is a document that you can open and read but no changes… Continue reading
Comments | Filed under: Uncategorized |
Give Me The Value And Just The Value
Have you ever found yourself working in MS Excel and wishing you could paste the value of a formula instead of the formula?
Or maybe you found yourself scrolling back and forth in a worksheet or flipping between different worksheets trying to type the value in by hand – desperately hoping you get it accurate.
You know what I’m referring to, the… Continue reading
Copy / Paste Keyboard Shortcuts
Since today’s tip revolves around copy and paste I thought I’d take this opportunity to quickly review the keyboard shortcuts for copy / paste and deletion functions.
I’ve also found a keyboard trick in MS Word for moving text around in a document.
So, let’s get to it…
Picture Perfect
Ever find yourself wishing you could put a screen shot into a Word document, Excel workbook, or PowerPoint presentation?
I know I use them all the time, and not just for this newsletter.
As a teacher I use them a lot when creating instructions for student projects or to create handouts to use during staff training.
It never occurred to me how much I’d use screen shots until… Continue reading
Comments | Filed under: MS Office Help |
Screen Shot? What’s That?
There’s a good chance that you’ve heard someone mention the term “screen shot” before.
Did you know what they were talking about or did you write it off as more computer jargon?
Well it you wrote it off, let’s just pull it out of the “mysterious computer jargon” file and put it into your active vocabulary list.
Basically a screen shot is just like a picture… Continue reading
Comments | Filed under: MS Office Help |
Creating A Table In MS Word Without A Mouse
What?
You can create a table without a mouse?
Are you sure?
Yes – I am and it’s easier than you might think.
All you need to know is how to line up your plus and minuses.
(Yeah – I said plus and minuses.)
To get Word to draw a table, without a mouse, you need to start by going to… Continue reading
An Office Assistant That Delivers
No not pizza delivery – sorry – but something you can really use.
How about a tip delivered to your desktop at program startup everyday?
If you like reading Office tips in little doses then you’ll love this. The only question is how do you arrange for this little delivery?
Well, the first thing you need to do is to get the Office Assistant running.… Continue reading
Comments | Filed under: MS Office Help |
Table Headers
Here’s the scenario, you’ve made a perfect table of information in MS Word and you’re getting ready to print your document. As you’re looking things over you realize that your table prints on several pages and your column titles are on the first page but not the others.
What do you do?
Do you make extra rows at the top of every page and manually… Continue reading
Preventing The “Saved Over” Blues
Do you have an Excel file that you constantly change data in and then have to remember to save it under a new name?
Have you ever caught yourself yelling at the computer “STOP!” as you realize that you just saved over the old data—and darn—you needed to keep that too!
While you’re still muttering at the computer, do you then go back and try… Continue reading
What’s up with all those tabs?
Did you ever notice that there are several tabs in the New window when you go to open a template you’ve created?
What’s up with all those tabs?
Well, to tell the truth, the tabs are useful little creatures.
Next time you go to open a template slow down and browse through them.
You’ll find that on the tabs are other… Continue reading
Affiliate Marketing: Make Money on the Internet!
(Or at least understand how other people are doing it!)
OK, I know this isn’t our normal type of topic, but we do have a lot of folks asking about how all this internet advertising and affiliate stuff works. So, here ya go!
You’ve seen them: ads asking you to punch a monkey, claim your free cruise, or spy on the… Continue reading
Comments | Filed under: Uncategorized |
Q:
I got an e-mail today that is formatted funny… Instead of being in paragraph form, it’s one line of text that’s about 47.5 feet long. Once I scrolled to the end, I forgot what the beginning said.
Can I make it easier to read on my end?
A:
You bet! Simply hit the Reply button and the message will come up correctly formatted in a new… Continue reading
Comments | Filed under: E-Mail Help |
