I’m sure you’ve noticed by now the Error button that pops up whenever Excel’s Error Checking feature thinks that there may be something wrong with a cell’s contents. Well, what if there are no errors? Continue reading
Karen from the Oaks NSW Australia asks:
I’m running Outlook 2007. I save my incoming email messages to various folders, so that I don’t fill up my Inbox. However, if I move sent messages from my Sent box to these folders, they lose their To Information and just show that they are from me. When I’m looking for
Have documents you access a lot? Check this handy MS Office tip that will teach you how to “pin” regularly access documents with ease! Continue reading
Ever found yourself staring at a column of data trying desperately to figure out how you’re going to peel out the portion of the data in each cell that you actually need? With the right formula anything is possible! Check it out! Continue reading
Be default, when we tell Excel to print we end up with whatever worksheet is currently selected spitting out of the printer.
Usually that’s great since it’s exactly what we want most of the time… but what about the other times?
You know, when you wanted the entire workbook or even multiple worksheets, but not all of them?
Learn how to remedy this problem by reading this tip! Continue reading
Are you looking to put a little space in-between your MS Word paragraphs, but don’t know where to find the option to do so? April has your answer right here, and it’s easier than you think! Continue reading
MS Excel: A Locked Cell is Not a Cell Protected From Changes
If you’ve ever found yourself nosing around the Protection tab in the Format Cells dialog box then you’ve probably found that the Locked check-box was selected and possibly thought that your worksheet was safe from changes made by others…
When the wavy red line became a part of the Spell Checker feature, I fell in love with it. I like that I know immediately when and where there is a problem.
On the other hand, I also know that I spend more time actually composing my writing, since I frequently stop, go back and fix those errors as they occur. It takes
MS Word: Insert Text Boxes That Come With Their Own Pizzazz
I often find myself using text boxes in Word for a variety of reasons… often it’s something that needs to stand out from all the rest of the text, or needs to be very mobile… and let’s face it, moving plain text around is just a pain.
Some people have one central location where they open Office files from on a regular basis… but others have several locations, and it’s a bit of a pain to constantly navigate from one location to another.
The more files you open, the bigger that pain becomes until it’s an all out headache.
You’ve got to be
There are certain things that we’d all like to have when we begin a new Excel workbook… such as number of worksheets, font, font size, etc…
For many people, this seems like an elusive process, since there are so many places to investigate looking for the old Default button.
Fortunately for all of us, a few
Here’s a tip that I recently found and put to immediate use… so I thought I’d share.
My sister had a birthday not too long ago, and a couple of friends and I decided to take her away for a few days on a getaway – no kids – no husband… only “the girls” were going on this one!
There are times when I’ve found myself working in MS Word, and I’ve needed a title or header for a page or section that was more of a title bar… something like this:
To create it, I could choose a text box and then format it appropriately but the reality is that it’s not
It’s not uncommon for us to find ourselves dragging a picture or drawing object around a document to place it where we need it, and then to turn around, go back to the Ribbon to set the word wrapping.
Let’s face it, sometimes it feels like a good 10 minutes before we’re done tinkering with these basic things, after inserting a picture
Many of us use the Print Screen button to capture screenshots… basically it’s a copy of whatever was on the screen when you hit the button and then it’s available to paste into your programs.
You may also know about the advantage of combining the Alt key with the Print Screen – it captures only the active window or dialog box.
MS Word: Pick and Choose Which Non-Printing Characters to Display
If you’ve ever used Word’s ability to display the non-printing characters in a document, you know how helpful it can be to visually verify information such as the actual number of spaces, tabs or paragraph marks present.
However, when you use that feature you
Richard from San Antonio asks:
I create a large number of tabs in Excel 2007 spreadsheets, each with a distinct title. Is there a way to search for a specific tab within the spreadsheet? Some of the spreadsheets might have 100 or more tabs.
Thanks for the question
MS Word: Using a Spreadsheet Within a Document
On more than one occasion, I’ve found that within a document I’ve needed to present data that really should be set up in Excel.
Don’t get me wrong, Word’s tables are great, but when it comes to calculations and numeric data displays, Excel wins hands down.
If you’re anything like me, you believe that there’s only one option when using the keyboard to paste in MS Excel – Ctrl+V.
While that obviously will paste your copied or cut information as it always has, you do have another option if you’re only looking to paste in one location.
MS Word: Stop Numbering Table Rows Manually, Word Can Do That for You
It’s not that uncommon… you’ve got a table in MS Word where you need the rows numbered, so you find yourself manually keying them in.
…1 – down arrow – 2 – down arrow – 3 – down arrow – 4
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