Office Tips

Hide Confidential Data in a Word 2007/2010 Document

by File in: Office Tips

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 prone and time consuming. If you often need to hide confidential data in a Word 2007, there is a free add-in for Word 2007, called […]

Sum a Table Column in Word

by File in: Office Tips

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 do this in Word 2003, 2007, and 2010/2013/2016. As an example, we will total a column of decimal numbers. Word 2007 thru 2016 Open Word […]

Preserve Cell References when Copying a Formula in Excel

by File in: Office Tips

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 of cell reference is called a relative reference. When we copy (Ctrl + C) the formula in the image above, and paste (Ctrl + V) […]

How to Customize the Ribbon in MS Office

by File in: Office Tips

Office 2007 added the ribbon bar to the interface, but did not allow you to customize the tabs on the ribbon bar. You could not add, remove, or move buttons on the tabs without using a third-party tool. Microsoft changed that for Office 2010, 2013 and 2016. Now, you can add commands to the ribbon […]

How to Repair Any Version of Microsoft Office

by File in: Office Tips

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 occasions, however, when the problem is larger than just an issue with a single application and you need to repair the entire Office suite. All […]

How to Restrict Editing on Word Documents

by File in: Office Tips

Word allows you to control the types of changes other people make to documents you distribute electronically. You can easily track any changes made to the document. Any text that has been changed displays in red. The procedure for restricting editing on a Word document is slightly different, depending on whether you are using a […]

Paste Text into Word Without Formatting

by File in: Office Tips

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 once you have pasted the text into Word, there is a way to make Word paste text from an outside source with no formatting by […]

Use Spike to Cut and Paste Multiple Text Items in Word

by File in: Office Tips

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 that text into another location. It is called the Spike and it is different in than the Clipboard, which allows you work with only one […]

How to Insert an Excel Worksheet into a Word Doc

by File in: Office Tips

One of the benefits of using an office suite like Microsoft Office is that the programs in the suite all interact with each other well. For example, you can easily embed an Excel worksheet into a Word document and be able to edit the spreadsheet in Word. Note that even though the screenshots below are […]

How to Layer Objects in a PowerPoint Presentation

by File in: Office Tips

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 print or screen. Unlike popular programs such as Word and Excel, PowerPoint’s entire design principle revolves around objects to create your presentation. Just like a […]