Wondering what happened to Normal View in MS Word? You may have found Draft View as a substitute, but is there any way to make it stick? April explores an answer. Continue reading
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
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