Is the Insert key completely useless? Actually, it isn't. In Microsoft Word it has a couple of functions you may be surprised to learn about.
MS Excel: It’s All About the Right and Left of the Thing
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!
How to Password Protect Worksheets in Excel
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... Whew! We're safe - … Continue reading How to Password Protect Worksheets in Excel
Controlling Spell Check in PowerPoint
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 … Continue reading Controlling Spell Check in PowerPoint
Inserting Pre-Designed Text Boxes in Word
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 … Continue reading Inserting Pre-Designed Text Boxes in Word
MS Office: Add Your Locations to the My Places Bar
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 … Continue reading MS Office: Add Your Locations to the My Places Bar
MS Excel: Customizing Worksheet Defaults
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 … Continue reading MS Excel: Customizing Worksheet Defaults
Converting PowerPoint Presentations to Video
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 … Continue reading Converting PowerPoint Presentations to Video
MS Word: Color Backgrounds for an Entire Paragraph
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 necessary. … Continue reading MS Word: Color Backgrounds for an Entire Paragraph
MS Word: Location and Text Wrapping in One Setting
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 … Continue reading MS Word: Location and Text Wrapping in One Setting