Office Tips

How to Create PDF Documents in Microsoft Office

by File in: Office Tips

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 a PDF. For Office 2007, for example, you can save files to PDF using an add-in supplied by Microsoft, called Save As PDF or XPS. […]

Use the Keyboard to Change Row Height and Column Width in Excel

by File in: Office Tips

If you prefer using the keyboard rather than the mouse, there is a way in Excel to change the row height and column width using the keyboard; however, it is not very intuitive. To set the row height, press Alt to put Excel into a “shortcut key mode.” You will see shortcut keys displays on […]

Change the Default Margins Used in New Word Documents

by File in: Office Tips

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 shows you how to set your default margins for Word 2003, 2007, 2010, 2013, and 2016.   Word 2007 thru Word 2016 The procedure for […]

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 […]

Convert Older Office Documents to Office 2010, 2013 or 2016 Format

by File in: Office Tips

Microsoft Office open documents created in older versions of Microsoft Office. However, they are opened in “Compatibility Mode,” and not all the features of the new version of Office are available for the older document. To use the newer features of Office on an older document, you must first convert the document to the newer […]

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 […]