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

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

Inserting Text Above or Below a Table in OpenOffice Writer

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. You need … Continue reading Inserting Text Above or Below a Table in OpenOffice Writer

Pictures and Shapes in MS Office

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 the … Continue reading Pictures and Shapes in MS Office

Drag and Drop Table Rows and Columns in MS Word

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 … Continue reading Drag and Drop Table Rows and Columns in MS Word