Office Tips

Use Excel’s Concatenate Function to Join Several Strings of Text

by File in: Office Tips

If you’ve used Excel for any length of time, you know that this spreadsheet application is as adept at manipulating strings of text as it is at manipulating numbers. When it comes to functions, however, Excel users tend to be more familiar with the ones that compute new numbers than those that change text. If […]

Edit Shapes in a PowerPoint Presentation

by File in: Office Tips

In a recent article, we discussed how to insert action buttons into a PowerPoint presentation. Strangely, these actions buttons are found on the Shapes menu. In this article, we will look at adding and editing shapes in a PowerPoint presentation. As it turns out, you can manipulate the shapes on a PowerPoint slide to look […]

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 to Make Information More Readable

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

Create PDF Documents in Microsoft Office 2007 and 2010

by File in: Office Tips

Do you need to distribute your Microsoft Office 2007 or 2010 files as PDF documents often? You can easily export your Office 2007 files to PDF using an add-in supplied by Microsoft, called Save As PDF or XPS (XPS is the XML Paper Specification). This add-in creates PDF files for files in Access, Excel, InfoPath, […]

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

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

Prevent the Insert Key from Turning on Overtype Mode in Word

by File in: Office Tips

If you tend to accidentally press the Insert key when pressing the Delete key in Word, this tip will be useful for you. You can turn off the Insert key permanently in Word, if you decide you don’t need it and don’t want to keep accidentally going into Overtype mode. This post shows you how […]

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, Word 2007, and Word 2010. Word 2003 To set default margins in Word 2003, […]

Change the Default Save Location and File Format in Word 2007 and 2010

by File in: Office Tips

By default Word 2007 and Word 2010 save documents in the My Documents folder. If you want to save Word documents in a different location, you can change this default. The procedure is similar for Word 2007 and Word 2010. We used Word 2007 as an example and pointed out the differences in Word 2010. […]