Make Excel 2007 Wrap Text in Cells
In Excel if you have a long entry in a cell the text automatically spans into multiple columns. Here’s how simple Excel 2007 makes the task of wrapping text in worksheet cells.
Magnify Selected Cells In Excel 2007
Excel has a zoom feature so that you can increase the size of the entire document, but sometimes you just want to zoom in on a specific set of cells that you are working on, and Excel 2007 makes this task simple….
Add Background Pictures To Excel 2007 Worksheets
Chart, numbers, worksheets … at a business presentation it can get rather monotonous looking at the same data sheets. Here is a way to add background graphics to your Excel spreadsheets to spice up those meetings…
Make Word 2007 Always Save in Word 2003 Format
After a dozen times of accidentally sending a Word 2007 document to co-workers still stuck on Office 2003, I’ve decided to make Word save in the Word 2003 format by default. (you can do the same thing in Excel)…
Save Time By Customizing the Quick Access Toolbar in Office 2007
With all the hype about the Ribbon, one of the more overlooked new features in Office 2007 is the Quick Access toolbar, which can be tremendously useful if you just take the time to customize it.
Use Smart Tags in Word 2007 to Resume Numbered Lists
One of the more frustrating tasks in Word has is trying to continue a numbered list when it gets broken. In Word 2007 you can use the smart tags to easily continue the numbered list.
Make Row Labels In Excel 2007 Freeze For Easier Reading
If you have large and long workbooks or Excel spreadsheets, being able to see the column or row labels is extremely important. Here is a quick way to freeze the labels in place for fast and easy viewing of your data….
Keyboard Ninja: 21 Keyboard Shortcut Articles
The Keyboard Ninja uses shortcut keys to accomplish tasks in less time than using the mouse. He uses the keyboard to launch applications, switch between windows or tabs, or change settings on his computer….
Keyboard Ninja: Insert Tables in Word 2007
If you frequently use Microsoft Word and want to achieve Keyboard Ninja status, you need to learn how to add tables to your Word document without touching the mouse.
Add Background Color To Word 2007 Documents
Instead of using the standard white background with Word documents, here is how to add some background color to spice up your documents.
Make Excel 2007 Print Gridlines In Workbook File
By Default Excel does not print out gridlines with your Excel data. Here is how to make Excel print out the gridlines for easier document readability.
Quickly Add Captions to Your Graphics in Word 2007
When your documents include pictures, charts, or other graphics it’s nice to add a caption to describe more to the reader.
Add Emphasis to Paragraphs with Drop Caps in Word 2007
You can add emphasis to your Word 2007 documents by using Drop Caps… you know, those big letters at the beginning of a document or paragraph that make your document look really professional.
Insert Horizontal Lines In Word Documents Quickly
When you want to quickly insert a horizontal line into your Word document instead of going through the Borders and Shading dialog box in the Ribbon here is a keyboard shortcut to save you time.
Convert Older Excel Documents to Excel 2007 Format
Excel 2007 can open a document from a previous version of outlook in Compatibility Mode, but if you want to take advantage of some of the new features you’ll need to convert the document.(You can use 1.1 million rows in Excel…
Quick Tip: Align Cells in Excel 2007
When you import data into an Excel Spreadsheet it is not always aligned in good proportion to the rest of the document. Here is the quick and easy way to line it up.
Mark Your Document As Final in Word 2007
When you are all finished with a Word document that has been passed around your company for reviews, you can mark the document as final so that your colleagues know that it’s the final version and does not require additional …
Find Emails With Attachments with Outlook 2007’s Instant Search
The Instant Search box in Outlook 2007 is a huge improvement over previous versions of Outlook, but remembering all the search operators can be a little difficult, so here’s a quick one that I use all the time….
Add Line Numbers In Word 2007 Margins
All geeks love line numbers… you can even add line numbers in your Word 2007 documents with just a few steps.
Embed True Type Fonts in Word and PowerPoint 2007 Documents
If you are the creative type that likes to use custom fonts in your documents or PowerPoint presentations, here is a cool tip to ensure that the readers of your document see the document with the fonts intact, just the way yo…
Using Comments in Word 2007 Documents
The comment tool in Word 2007 is a great way to proof-read a report or thesis paper and make notes to yourself instead of writing them onto a sheet of paper.
View Your Google Calendar in Outlook 2007
Google Calendar is a phenomenal web application for managing your calendars, but so many of us are still forced to use Outlook at work. The good thing is you can have the best of both worlds by subscribing to y…
Import Text into Excel 2007
Nothing equals Excel for crunching of numbers, but what if your data isn’t already in an Excel spreadsheet? It’s as simple as using the Text Import Wizard.
Quickly Translate Text to Another Language in Word 2007
The Research Pane in Word 2007 can help you easily translate text into other languages, using bilingual dictionaries powered by WordLingo.com.
Quick Tip: Automatically Compact Access Databases
Although it’s unlikely that you’ll ever hit the maximum Access database size of 2GB, it’s still good to know that you can set your database to automatically compact or shrink the file size. This is especially true for databas…
