Do you work with a lot of Google Docs documents? Do you have spreadsheets, Word documents, PDF reports, PowerPoint presentations stored in your Google Docs account, and are looking for an easier way to create or manage these documents from Microsoft Office desktop UI?
There are tons of desktop apps available for managing Google Docs documents, but recently Google has released an official add-in which
MS Excel: Finding a Long Lost Friend… the Format Cells Dialog Box
Let’s be honest, there are times when faced with the Ribbon and all its tabs, groups and buttons, that we miss our old friend the Format Cells dialog box.
It was our “one-stop”
MS Word: How To Ensure That Your Formatting Is Kept When You Copy And Paste Text
When you copy and paste text, do you ever find yourself wondering why sometimes certain formatting traits were pasted with the text and at others aren’t?
It can seem sort of random to most people… and random is
Benson in Austin TX asks:
I am organizing a class reunion. In the next 3 months, I’ll accumulate at least 200 new email addresses that I’ll use only once or twice. I use Outlook and don’t want it to conflict with my regular personal/business address book? Is there a way to do this?
MS Office: A Picture of a Different Shape
Today I want to point out a very simple and quick way to change the way pictures and graphics are displayed in your documents, presentations, worksheets, etc…
We’re going to take a look at how the fill of a shape can really make a difference in
Powerpoint: Making the Difficult Fonts More Readable
When putting together a document and using some more interesting fonts, I’m sure that you’ve run into the same thing that I have… the font is cool, what you want, but not very readable for some people.
The design of the font just makes it feel “squished” together.
For you and me, not
Rose from Coon Rapids MN asks:
When I am typing a document in Word 2007, I get a wide space between the lines. How do you reduce that space?
Rose, thanks for the question. The search for your answer helped me find an answer to a question I was too lazy to
MS Word: Manually Move Table Rows or Columns Without Copy and Paste
Let’s face it, there are just times when the table you’ve set up now seems to be “out of order”. You find yourself wishing that the 3rd row was now the 5th row and that the 4th column should have actually have been the 2nd.
We’ve all done it at one time or another… you need to create a new file that’s pretty much identical to another one, so you open the file that you have, make the changes and then save it.
In that very, very short time while you watch the file being saved you are struck speechless with the horrible realization that you just made a
Henry from Denton, MD asks:
Windows 7 Office 2007, Outlook 2007. Incoming new e-mails do not show up in bold before they are read. How can I reinstate the Bold?
Henry, by default, Outlook displays unread messages with a bold font. However, it appears that your default has changed. No problem. We’ll
MS PowerPoint: Who Knew That the F2 Key Has a Use Here Too?
As I’m sure you already know, the F2 key when used in MS Excel will put you into the editing mode for the contents of a selected cell.
It’s a really handy little tool, since you can navigate through the sheet
When setting up a worksheet where we need to separate one section of information from another, and present that separation clearly, we often use cell borders to accomplish the job.
Obviously that option is a great way to get the job done, but we tend to use those for everything… so making that visual break between data sections requires a bit of finesse with those borders.
MS Excel: Copy / Paste Only a Cell Comment
When reviewing the contents of a worksheet, do you find that you’ve got the same comment to make over and over again? (The least of which being “Where the heck did that come from?”)
I know that when I go through and start getting into
How much time have you spent customizing the Quick Access Toolbar in your MS Office 2007 programs?
If you’re anything like me then it’s quite a lot…
When you move to a new computer – or maybe decide that you want the one at home to match the one at work – what do you do?
It’s called a Drop Cap and, while this may not be something that we would use every day, it is a quick and very easy way to add a little something extra to your documents, making it something that would be a good addition to our “Hey, I know how to do that” list.
Franklyn asks:
When writing email, there are times I would like to use a superscript (degree F) and subscript (H2O). Is there a way to have them available?
Franklyn, if you’re using Microsoft Word or Outlook 2007 or 2010, you can easily add either superscript…
If you’ve recently given up your Microsoft Office 2003 for the “latest, greatest” version, Office 2010, you may be a bit disoriented.
You’ve heard the hype about the new Ribbon User Interface but now you’re faced with actually having to use it…
If it’s not something you’re taking to easily or just feel like you need more guidance, I have a suggestion or two
Microsoft Excel is the one of the most popular spreadsheet programs used worldwide. It has a variety of features such as data storage, creating reports and charts, using mathematical functions, performing statistical analysis, ability to connect to databases, making use of pivot tables, V-lookups etc. One such very useful feature within Microsoft Excel is the ability to make use of “macros”.
What is a Macro?
The other day we talked about a method to copy and paste the OFFICEUI files (which contain all the custom User Interface information for one of the Office 2010 programs). It’s a good method, but it requires you to know where to look for the files.
It’s a great way to save your customizations, in case something happens to your system
If you’re a person who likes to use transition effects when moving your presentation from one slide to the next and favor consistency in your choice of transition, then you’ve probably found yourself looking at something like this, while you select a slide, apply the transition effect, move to the next slide, apply effect, move to the next slide… Continue reading
Richard from Hudson, Florida asks:
I am using Microsoft Outlook 2003. Sometimes in checking my mail, a red flag would come up on the right side of a message and the page would shake. I tried to shut down Outlook and restart it, no help. I would even reboot and the red flags are still there. I
MS Excel: Delete Multiple Comments at Once
If you’ve got an Excel worksheet that contains a lot of comments, it can be a bit of a pain to remove them all when you’re done.
Think about it. If the worksheet is a large one and you’ve managed to accumulate quite a few comments, it’s
Do you “undo” a lot in MS PowerPoint?
Ever run out of undo steps and wish for more?
If your response was yes, here’s what you need to know about PowerPoint to get a few (or a lot) more undo steps added to your list.
Use
MS Word: Moving In a New Direction
Ever find yourself looking to rotate text in MS Word?
Maybe you’re trying to make a flyer with phone number tabs across the bottom? Or, maybe you need to run some text down the side of a document and you don’t want
When you open a file in one of your MS Office programs, do you find that you’re always navigating away from “My Documents” to some other folder?
Ever wish that it would just open up to that location in the first place?
If so, here’s the good news… you can set each program to go directly to whatever location you desire, when you
When you’re in the Options dialog box for one of these newest MS Office programs, have you ever noticed this part of a section header? (You’ll notice that not all section headers have one…)
Even if you did notice it…did you take the time to investigate?
For many people the answers are no…
Dale from OR asks:
I can receive email messages with no problem in Outlook, but all my outgoing email stays in my Outbox and won’t send. Can you help?
Despite possibly being the world’s most ubiquitous e-mail program, Microsoft’s Outlook e-mail client is not without its flaws. Now in its 14th iteration
