Office Tips

Change the Layout of a PowerPoint Slide with Just a Few Clicks

by File in: Office Tips

In educational and business settings, PowerPoint reigns supreme as the number one electronic slide presentation application. In fact, the application from Microsoft’s Office suite is used so frequently by instructors, students, and business people that it is common to see the same layouts repeatedly from presentation to presentation. Luckily, you can easily change the layout […]

Group Rows and Columns in an Excel Worksheet

by File in: Office Tips

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 amounts of information; sometimes that information becomes too unwieldy such that using the data stored in an Excel worksheet becomes more and more of a […]

Quickly Spell Out Numbers in Word and Excel

by File in: Office Tips

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 do this easily. There is a version of this add-in for Excel that installs and works the same way as the version for Word. This […]

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