MS Excel 2007 & 2010: How Do You Like to View It?
We all have one… you
know, that preferred view of our MS Excel worksheets.
Some people like to see
everything in the Normal view.
Others prefer the Page
Layout view, where Excel shows the physical breaks between each page, as well
as the… Continue reading
MS Excel: Data Too Long
for the Cell? Use Shrink to Fit & Let Excel Fix the Problem for You!
Ever have data in MS Excel that’s just a bit too long for the cell?
What happened?
Did the column widen to accommodate? Or, maybe you got the infamous
If you use Outlook for appointments or reminders, I’m sure you’ve seen the Reminders Window on more than one occasion.
(Yes – mine is empty. Must mean that I’m all caught up, right? Yeah, right – I wish…)
Anyway, I know that I’m not the only one who has accidentally closed that thing before I meant to
MS Office 2007 & 2010: I Thought That the Clipboard Could Hold More Than One Item?
You’re right – it can…
you were used to accessing something like this via the Edit menu in older
versions of MS Office:
A clipboard pane where all
the items that have been copied or cut, are stacked in a list… Continue reading
In Windows 7, when using the Snipping tool, (one of the greatest features of Win 7), I can copy the snippet OK and place it in MS Word, but I cannot place the object right or center nor can I text wrap around the object. Any ideas?
Back in the days before the introduction of Windows 7 and Vista, if you wanted to take a picture… Continue reading
MS Excel: A Little Something
More to Say
Ever find yourself working
on an Excel formula and wondering how in the world the person you’re handing
this off to will ever understand some of the more complex calculations?
Short of writing lengthy
documentation, or spending a whole lot of time walking them through things piece
by piece, there… Continue reading
Roger writes:
I have someone I e-mail a lot, and I get tired of opening and closing Outlook. Is there any way to e-mail someone without having to do that?
Hi, Roger!
If you want to e-mail a certain person quickly without opening and closing your e-mail client (such as Gmail or Outlook), there is one way you can do it, and that is by creating an e-mail shortcut for the person on your desktop. It’s easy; here’s how: Continue reading
Thom, from Dallas asks:
Why do Word and Excel files get so large when the content is so small? As I make numerous changes and saves to a Word file, the file becomes bloated over time. If I open the large Word file and copy (Ctrl-C) and paste the content to a newly created word document, the file
So, here’s the scenario… you’re happily working in one of the newest versions of an MS Office program and things are progressing nicely.
Then suddenly it happens – the program window goes “wacky” and you find yourself looking at the file after a zoom in or zoom out.
What happened there?
To be quite
Yep – that’s right – you can send text messages to phone using Outlook e-mail… or any other email client.
This is one of my favorite, but yet completely simple tips to use. I have a friend who you can only seem to reach by text and a sister that is easier to find that way as well. Unfortunately, I don’t always have the opportunity to pull
I can’t speak for everyone, but I’m a die-hard fan of Print Preview.
It gives me a sense of the overall look of the final product, which I find to be an invaluable tool.
Word 2007 has the Print Preview option under the Office Button in the Print choices.
Earlier versions of Word used to allow me to get into the… Continue reading
MS Office 2007 & 2010: Let the Program Bring the Templates to You
At one time or another, we’ve all found ourselves searching online for just the right template to do the job we need.
Even using the Microsoft templates site, which is quite organized and easy to use, can be tedious and frustrating, as you try search after search after search.… Continue reading
Georgia asks:
The Send/Receive button in my Outlook 2007 is on the right side. Can you please tell me how to move it to the left side?
Georgia, as you can see below, my Send/Receive button is near the center of the toolbar. To move it, begin by right clicking on the toolbar and then select Customize from the menu.… Continue reading
I can’t speak for everyone but I love to the recent files list… I mean what’s not to love?
You can bypass the whole Open dialog box and the sometimes complicated navigation, to actually pull up any recent file just by looking in one place.
If you’ve investigated in Office 2010 then, you know that the recent files list is found under… Continue reading
MS Word: Why Does Inserting A Picture Always Cause Such a Mess?
Okay, so maybe it’s not a complete “mess”, but if you’re not familiar with the interactions of text and pictures in a Word document then, it probably feels that way to you.
After you insert a picture, you suddenly find yourself looking at this great big huge gap between two lines of… Continue reading
You know that person who e-mails everything so efficiently using distribution lists?
And… what are you doing?
Choosing each person individually for each message you send?
Maybe you’re searching out a previously sent message that went to the right group of people, creating a forward message, clearing out the old content of the message and then composing the new e-mail?… Continue reading
Undo – Redo – Undo – Redo… I don’t know about you, but I find that I tend to use that cycle of events a lot when I’m putting finishing touches on things… especially on one of my “picky” days when everything has to be perfect.
Anyway, it’s a great feature, and I’m sure that I’m not the only one using it.
However, did… Continue reading
If you made the transition to the Ribbon User Interface when Office 2007 was released, the upgrade to Office 2010 really wasn’t a big deal for you.
There are changes, but not in a way that gives you that “I’m lost” feeling so many people felt with their beginning efforts in Office 2007.
But, if you’re one of the many who didn’t use Office… Continue reading
Ever find that you need the column width from one column transferred to others without all the data and other formatting?
Maybe the width you need is in a column formatted as bolded text and, while the width needs to be transferred, the rest doesn’t. In a case such as this the old Format Painter won’t help as much as we’d like it to, since it transfers… Continue reading
Don, from Roanoke VA asks:
I’ve got a problem with the MS Word 2010 application. Every time I open the program I get a security warning just below the ribbon stating that macros have been disabled (click enable content.) Could you explain this macro, and how do I make this action enabled by default. I can’t seem to find a solution under the file tab>options.
When you’re at the end of a bulleted or numbered list, what do you choose to do?
I mean we all know what happens… you enter the last item and hit the Enter key… and there’s yet another bullet or number.
Most people I’ve watched in this situation start up with the Backspace key and often end up hitting it one too many times… Continue reading
OK, so all of the MS Office 2007 & 2010 users have come to deal with the fact that the menu & toolbar system is gone and in its place we have the Ribbon.
It’s a rather large “gadget” and takes quite a bit of screen space.
Many have learned to live with it “as is” but others have learned to minimize it.… Continue reading
Daniel, from Florida asks:
I’m able to copy documents I’ve typed on Word into the body of an (AOL) e-mail but I can’t copy any text that was scanned into my computer. How do I copy scanned documents into the body of an e-mail? I’m not talking about an attachment.
Converting Images to Text
Today, everything seems to be about speed. There… Continue reading
You may be backing up your Outlook files frequently so that you can recover the data – emails, contacts, calendars, tasks, and more – whenever you reinstall MS Outlook after a format of System Drive. This article offers you a tip that will allow you to set up your MS Outlook once and forget about backing up the contacts, emails, etc.
NOTE: This tip is applicable only… Continue reading
When you’re using MS Outlook’s calendar, do you find yourself staring at those 30 minute time slots provided, and wishing that it had more detail to it? Less detail?
Maybe your life goes at an amazing pace, and you need to see detail at smaller time intervals…
Or, maybe you end up with long appointments in your calendar and really don’t even need the… Continue reading
When you’re trying to finalize the appearance of a document, do you find yourself hoping that everything is lined up correctly?
I mean, is that picture or shape really lined up with the text or some other object?
We do have the horizontal and vertical rulers to work with, but if you’re trying to align many different items, it can take a lot of… Continue reading
Many of us have a template or two that we use all the time.
Of course, the first thing we do upon opening the template is to make a few changes to the layout or text.
We make those changes again, and again, and again, and again…
Well, you get the idea…
With the endless work of changing… Continue reading
