Ever find that you have part of an Excel 2007 worksheet that you need others to see. That is, they need to see the information displayed but in no way, shape or form do they need to actually possess the worksheet itself?
Basically – they need an “electronic print out” of a portion of a worksheet – in other words, you need so show them a picture… Continue reading
Do you find that referring to cell ranges in Excel formulas is a difficult task? Confused by the use of the colons, commas and spaces?
These characters are definitely a part of formula writing and if they aren’t used correctly, you’ll probably run into some problems.
So, here’s the information that can make formula writing with ranges a much more manageable task… Continue reading
I know that my PowerPoint users can identify with this one… You’ve spent a lot of time putting together the perfect presentation and now it’s time to do a quick run through to see how it looks.
Well – you thought that it was “perfect” but now you see that content holders (such as the title, main text, etc…) are all slightly different. Some titles ended up… Continue reading
If you’re an MS Word table user then it’s quite possible that you’ve spent some time trying figure out how to wrap the text of your document around the table.
There isn’t an overly obvious answer so I’m sure that many of you have just given up on truly wrapping the text around the table.
For those of you who have unsuccessfully searched here’s… Continue reading
Are you still finding it difficult to locate things in the newest Office programs – you know, all the things that were so easily at your fingertips and are now “lost” somewhere on the Ribbon?
Well I ran across something the other day that just may help you to complete the transition from the menus to the Ribbon.
I was on Microsoft’s sight and… Continue reading
When you’re working with Microsoft Office 2007 SmartArt graphics do you ever think to yourself how nice it would be if all the shapes in the graphic didn’t have to be the same?
Maybe your basic SmartArt graphic like this one:
Would make more sense or be more useful to you if it looked something like this:… Continue reading
For years we’ve all used Microsoft Word and have come to rely upon our handy little underline button.
Assuming that you’ve made the transition to Word 2007, then I’m sure you were happy to see the Underline button safe and sound (not to mention easy to find) on the Home tab of the Ribbon.
But, have you really looked at the new Underline button?… Continue reading
Have a lot of sheets in your Excel workbooks?
Tired of scrolling left and right to find the right tab?
Or maybe you do the whole Ctrl + Page Up / Ctrl + Page Down thing, but that can be tedious too and let’s face it, it’s pretty easy to blow right by the sheet you need.
So, you’ve got to… Continue reading
Working with Office 2007?
Everyone you share files with need them saved for an older version?
Maybe you have 07 at work and some other version at home…
Whatever the situation how many times do you find yourself saving a new file in an Office 2007 program as an Office 2007 file when it should have been in the 97-2003 file… Continue reading
Here’s a quick Word tip for all of you who are attached to your emoticons… you know, the little 
and 
we’re so fond of using in text and e-mail?
Well, if you like these little guys and haven’t tried one in Word lately then you really should!
As part of the AutoCorrect list there are three emoticons set to be replaced by… Continue reading
When we think of using Ctrl + Z we’re all thinking “undo” – which is true but in our minds that means removing the last character entered, putting text back that we just deleted or removing formatting that we tried but just didn’t like.
All of these things are exactly what Ctrl + Z is for but there’s more.
More you ask?… Continue reading
If you use comments in MS Excel then you might find yourself wishing that there was a way to color code them.
Maybe some comments are notes you’ve made to yourself about double checking a formula, maybe others pertain to something entirely different.
Whatever your needs it might interest you to know that you can change the color of your comments with just a… Continue reading
Yeah, I know. Excel is primarily for numeric data , but let’s face it, we tend to use a lot of words in our Excel worksheets. Given all those words, it’s only reasonable to find that typos and misspelled words are occurring in Excel too.
So, it makes sense to me to understand (not just assume) what cells the spell check feature is actually checking. Did you… Continue reading
We all know that Word and PowerPoint have the Change Case feature. It’s an extremely useful tool, so much so that there are times when working in Excel I find myself wishing it was there too.
I realize that Excel really isn’t meant for a lot of text but there are times when you just can’t get around it.
At any rate, if you’ve… Continue reading
I’m sure that we all know how to attach a file to a message in MS Outlook, but did you know that you also attach an Outlook item?
Yep – that’s right, you can easily attach a calendar item, contact information, note, etc…
All those things you have in Outlook and aren’t sure how to share them are just as easily shared as any… Continue reading
How many times have you found yourself working in one of the MS Office programs and creating something that you just know probably already exsist out there somewhere?
If you’re anything like me then the answer is a simple “too many times to count”.
And… right on the heels of that thought is the realization of just how much time you’ve wasted over the… Continue reading
When you’re editing a complicated slide in PowerPoint and you’ve got a lot of animations to set it’s sometimes difficult to know that it’s all going together as you have it pictured in your mind.
To be sure that it’s coming along as you hoped you’ll want to preview it… so what do you do?
Most people leave the Normal view and actually begin… Continue reading
OK – So by now I’m sure that you’ve found the Search box in Outlook 2007.
This is a quick and handy way to locate a message with a quick key word or phrase.
However, sometimes the results are so numerous that it’s no help at all…
Logically you might take the next step to expand the… Continue reading
For many of us the font used in our documents, presentations and workbooks is a choice we actively make. When I’m creating something for others to see – which is most of the time – then I want it to look a certain way.
The easiest way to create something that I’ll like is to have my default font set to my
I obviously can’t speak for you but I do know that there are times when I’m working in Excel and find myself in need of a calculator.
I know, I know, there are quite a few of you wondering why I’d want a calculator when Excel can basically do all that for me.
Well, sometimes I just feel that it’s easier to… Continue reading
Do you use the color-coded categories in MS Outlook 2007?
I don’t know about you but I love them in conjunction with e-mail rules so that as certain messages come in they are marked for my attention as soon as they hit my Inbox.
What I’d like to discuss today is an extension of the category use.
Did you ever notice… Continue reading
Have you used a table in MS Word lately?
Find that your column is a little too narrow to fit the data?
Now, if we were working in Excel we’d just double click the right border of the column label… but this isn’t Excel so we’re out of luck, right?
Wrong. AutoFit works on Word tables too!
All… Continue reading
Have you ever noticed that MS Excel automatically tries to print everything on your worksheet?
This works wonderfully for most things we do, but what about the times when you only need part of a worksheet printed? Or, what do you do when you have a large worksheet containing many calculations that feed to one particular section of the sheet and you only want to… Continue reading
Do you have a custom logo, picture or return address set up that you really wish would just show up every time you print an envelope?
That sure would be nice. I mean, no messing with templates, copy/pastes or other methods you may dream up to get your envelopes to your liking.
Well, I have good news. That “dream come true” is easier to… Continue reading
Not many things can aggravate me more than when I’ve got to transfer page setup information from one worksheet to another.
Often, I’ll set up a worksheet not realizing that later I’ll need to add another worksheet in the workbook that needs all the same settings.
Since I’ve just added the sheet it comes with the default settings
I’m sure that we’ve all had the experience of the screen tip popping up when we pause the mouse pointer over a button on the MS Office Ribbon.
When it comes to those tips people tend to fall into 3 different categories… those who don’t need them, those who like the small tip that lists the name of the button only and those people who want to… Continue reading
Have you ever felt frustrated when working with MS Word’s tabs? I mean, you’re trying to set up your tab stops, but you’re finding it difficult to ensure that they are placed properly between the margins.
You’ve got the ruler displayed (View menu, Ruler choice – or – View tab on the Ribbon, check the Ruler option), but it’s still a bit of a pain to double… Continue reading
