Office Tips

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

Change Measurement Units in Microsoft Word

by File in: Office Tips

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 post shows you how to change this setting in Word 2016 and earlier. Change Measurement Units in Word To change the default measurement units in Word, […]

View Word Documents in Full-Screen Mode

by File in: Office Tips

Really old versions of Microsoft Word had a full-screen mode available under the View menu, which was ideal if you wanted to do a presentation of the content in your document or if you just wanted to use up all the screen real estate. This option allowed you to hide the Office elements around the […]

Center Your Worksheet Data in Excel for Printing

by File in: Office Tips

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, left corner of the page. For a very small set of data, this can detract from the effectiveness of your presentation. There is an easy […]

Generate Random Text or Lorem Ipsum Text in MS Word

by File in: Office Tips

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 a couple of quick and easy methods for entering random text into your document. Random Text To do this, position the cursor at the beginning […]

2 Ways to Use Excel’s Transpose Function

by File in: Office Tips

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, each person has their own quirks and methods for working with Excel. Some prefer organizing data into columns and others into rows. If someone gives […]

How to Use Excel’s What-If Analysis

by File in: Office Tips

One often overlooked feature of Excel is the What-If Analysis tool that allows you to explore different scenarios without changing the values in your spreadsheet. This function is particularly useful for economics and management majors as well as business owners because you can see how different values affect models, formulas, and projected profits. Excel’s What-If […]