If you want to share a small part of your Excel worksheet but don’t want to send an Excel file, you can copy part of the worksheet to the clipboard as a picture instead, which can be pasted into any application that supports images, such as your favorite image editor.
When you are including graphics in a Word document many times you want to place the image in a particular way or at a certain angle. Word 2007 has just the tool for the job.
If you like to use Windows Calculator to perform quick calculations while in Excel, you can save time by adding it to your Quick Access Toolbar. This should work for any version of Excel that has the Ribbon.
One of my friends contacted me a while back asking why the default setting in Outlook 2007 is to not mark items as read until you switch to a different email, which leaves the new mail notification sitting in the system tray even though you’ve clearly read the email.
One of the best new features in Outlook 2007 is the To-Do bar, where you have quick access to your calendar as well as your task list. Unfortunately, the default setting of showing all of your tasks regardless of date can be overwhelming for anybody that has a lot of tasks, and just isn’t all that helpful.
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.
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.
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.
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)
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.
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.
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.
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.
Instead of using the standard white background with Word documents, here is how to add some background color to spice up your documents.
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.
Like everything in Excel, you can customize the way your worksheet looks by changing the color of the gridlines to something festive.
When your documents include pictures, charts, or other graphics it’s nice to add a caption to describe more to the reader.
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.
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.
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 2007 instead of only 65k in previous versions)
After the tenth time saving an Excel spreadsheet and then emailing it to a co-worker still using Office 2003, I’m willing to save in 2003 format by default. It’s not like the rest of the office is going to switch for a very long time anyway, and this way I can stop sending them the wrong documents by mistake!
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.
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 editing. It also prevents people from accidentally making changes to the document before forwarding it on to a client, for instance.
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.
If you are worried about sensitive data in your Microsoft Word document you can both encrypt and password protect the document to keep it secure. This feature is very useful if you have to store your documents in a shared location, such as a network folder or home computer.