Office Articles
Make OpenOffice Writer Look and Function More Like Microsoft Word
Enjoy using this free tool that much more
Using Excel’s What-If Analysis Goal Seek Tool
Lets you work backwards to get the desired cell output
Viewing and Inserting the Date a Document was Last Modified in a Word Document
Especially helpful when working with others
Each document you create in Word contains information about the document or Properties, such as the date the file was created, the author of the document, and the number of […]
Insert a Bullet in the Middle of a Sentence in Word
You may want to use it for design or emphasis
There may be times when you want to insert a bullet in the middle of a sentence or a line of text. For example, you might want to put bullets […]
Group Rows and Columns in an Excel Worksheet
Makes working with them so much easier
Excel is one of the applications in the Office suite that is equally useful in the workplace and in a home or home office. Excel is capable of storing great […]
Quickly Spell Out Numbers in Word and Excel
It's less stress on the brain
If you use a lot of numbers in Word documents and want to be able to quickly spell them out, there is an add-in for Word that allows you to […]
How to Create PDF Documents in Microsoft Office
Different methods, depending on your version
Do you need to distribute your Microsoft Office files as PDF documents often? Depending on which version of Office you have, there are different ways to save your document as […]
Change the Default Margins Used in New Word Documents
Give them your own special look
If you use the same margins in most of your Word documents, you can set default margins once to be used for every new Word document you create. This post […]
Hide Confidential Data in a Word 2007/2010 Document
Prevents redacted text from being revealed
When sharing a Word 2007 document, you may need to delete or hide confidential information. You can search for the data and remove it manually, but this can be error […]
Sum a Table Column in Word
Plus insert more complex formulas
Word allows you to calculate the sum of a column in a table, just like you would in a spreadsheet program like Excel. This post will show you how to […]
Preserve Cell References when Copying a Formula in Excel
Handy if you want to display a total elsewhere
When you copy a cell containing a formula, you will notice that the cell references in the formula also move a corresponding number of cells across and down. This type […]
How to Repair Any Version of Microsoft Office
Fixes most Office problems in a jiffy
I’ve previously written articles on Microsoft Office like how to fix the Word has stopped working error and how to fix the Outlook has encountered an problem error. There are […]
Paste Text into Word Without Formatting
Easier than reformatting or pasting into Notepad first
By default, Microsoft Word tries to preserve the styles of text copied from a source outside of Word. If you don’t want to have to manually remove the style information […]
Use Spike to Cut and Paste Multiple Text Items in Word
A nifty and useful feature you may not know about
There is a little known feature in word that allows you to gather groups of text and/or graphics from different locations in a Word document and then paste all of […]
How to Layer Objects in a PowerPoint Presentation
Make a boring presentation more snazzy
If you never use desktop publishing programs such as Microsoft Publisher, Corel Draw, or Adobe InDesign, you may not be familiar with using objects and layers to create documents for […]
Change Measurement Units in Microsoft Word
Useful for custom margins or using the metric system
By default, Microsoft Word uses inches as its unit of measurement in dialog boxes and on the ruler. You can change measurement units to centimeters, picas, points, or millimeters. This […]
Center Your Worksheet Data in Excel for Printing
Let's face it, it looks much nicer
If you have created a small worksheet in Excel, you may want to center it on the page when you print it. By default, it will print in the upper, […]
Generate Random Text or Lorem Ipsum Text in MS Word
Great for doing website or document mockups
Ever need to add some random or meaningless text into Microsoft Word to test a document, temporarily fill some space, or to see how some formatting looks? Luckily, Word provides […]
2 Ways to Use Excel’s Transpose Function
Because we all have our worksheet quirks
If you work extensively with Excel at home, at work, or in a home office, you have the luxury of setting up your worksheets exactly as you want them. However, […]
