At some point, you may have started to create a table in Word 2007, got a good amount of the table done, and then discovered you want to make your columns into rows and your rows into columns, basically turning your table 90 degrees, to better display your data. Unfortunately, there is no way to [...]
Office Tips
Transpose Table Contents in Word 2007
August 28th, 2010 by Aseem Kishore
Use the Spike to Copy and Paste Text in Word
August 15th, 2010 by Aseem Kishore
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 copied [...]
Embed an Excel Worksheet into Word 2007
August 13th, 2010 by Aseem Kishore
Layering Objects in a PowerPoint Presentation
July 10th, 2010 by Aseem Kishore
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
June 28th, 2010 by Aseem Kishore
By default, Microsoft Word uses inches as its unit of measurement used 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 2007 and Word 2003 and earlier. Change Measurement Units in Word 2007 To change [...]
View Word 2007 in Full-Screen Mode
June 25th, 2010 by Aseem Kishore
Microsoft Word 2003 has a full-screen mode available under the View menu which is ideal if you want to present material in a Word document. This option allows you to hide the Office elements around the edges of the document, making the document take up the whole screen. However, Word 2007 does not seem to [...]
Center Your Worksheet Data in Excel 2007
June 20th, 2010 by Aseem Kishore
Fill Space in Microsoft Word with Random Text
June 19th, 2010 by Aseem Kishore
You may want to put some meaningless text into Microsoft Word to test a document, temporarily fill some space, or to see how some formatting looks. Word provides a quick and easy method of entering random text into your document. To do this, position the cursor at the beginning of a blank paragraph. Type the [...]
Customize the Quick Access Toolbar in Microsoft Office 2007
April 21st, 2010 by Aseem Kishore
The Quick Access Toolbar in Microsoft Office 2007 is a customizable toolbar that provides one-click access to some commands. The commands on the Quick Access Toolbar are independent of the tab that is currently displayed. You can add commands that you use frequently to the Quick Access Toolbar, and you can place the Quick Access [...]
Turn Columns into Rows Using Excel’s Transpose Function
April 13th, 2010 by Aseem Kishore
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 [...]