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
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
We’ve all experienced times when we hover over a button on a toolbar and the Help Tip displays but then disappears so fast that we missed it.
Find yourself moving the mouse pointer off the button then back on it in an attempt to actually see what it said?
If you missed it
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
Keep track and easily open all of your recent files in Open Office! This one’s a real time saver! Continue reading
Recently while working in OpenOffice.org Writer, I found myself repeating my actions over and over again.
I knew that MS Office had a way to repeat the last action or word entered, so I went looking for what Writer has to offer.
What I found was on the Edit menu:
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
The Autofit feature in Calc and other spreadsheet programs is an extremely helpful feature.
You can simply double-click on the right divider line in the column title, and the column will automatically expand to fit the longest piece of data.
But what if you don’t want to fit the longest
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!
If you’ve used OpenOffice.org Calc at all, I know that you’ve found the Delete Contents dialog box.
How could you not?
Every time you select a cell or range of cells and try to clear their contents you automatically hit the Delete button and that annoying dialog
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
Have you ever needed your headers or footers to be different on odd and even pages?
Maybe you’ve created a document that will eventually be put together like a book so the pages that will end up on the right of the finished document need the page number on the right side of the page with the same scenario for the left side pages.
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.
If you use a lot of graphics in your OpenOffice.org documents, you’re probably in a love/hate relationship with the built-in graphics Gallery.
Love to access the graphics, hate the space that the gallery eats up on your screen….
Well, to be truthful, the problem with the space it takes, is that my monitor is wide-screen and
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
OpenOffice.org Writer: Quick Divider Lines Using 4 Simple Keystrokes
Every once in a while, you just need a horizontal line in your document to create a visual break of one thing to another… maybe you need to separate a page “headline” from the body of the document or separate different topics from one another in
OpenOffice.org Writer: Inserting Text Before or After a Table
It happens to anyone who uses tables in a word processing program like OpenOffice.org Writer – we insert a table at the very top of the document and find ourselves unable to add text above it because we didn’t leave a blank line there.
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.