[January 2008]
Happy New Year everyone!
We're off to a brand new start - a fresh, clean slate! Let's all try and do something, if even just a little tiny something, to make this old world just a bit better for having been there.
Got your resolutions are written down and ready to go? I have already started working on my resolutions and one of them is to make this newletter even better for you, my loyal subscribers. By now, you have already received the Special Announcement that was sent out letting you know that my Office 2007 eBooks are now available for download. I have received so many compliments on these books!
If you haven't gotten your copy yet, make sure you do it soon! Say what you will about Office 2007 - many people love it and some hate it - but it definitely is NEW and difficult to traverse if you don't know the lay of the land. So get your copy today!
Table of Contents
Color One Cell Inside an MS Word Table - Make your information pop!
Limit Searches to a Column in MS Excel - Why look all over creation?
Align Tables to Formatting in Page Layout: MS Word - It's Done Automatically!
Color One Cell Inside an MS Word Table
A reader recently wrote to me and inquired:
"I have a table and would like to color the entire background of a single cell in the table. I am able to color the text in the cell, but not the entire background of the cell. I use MS Office 2003. Any help and suggestions are much appreciated."
My response:
- Place your cursor in the cell in which you would like to have shading.
- Now click on Format | Borders and Shading.
- Click on the Shading tab.
- On the left side, under Fill, select the color you would like to use.
- On the right-side, under Apply To, use the drop-down arrow and select Cell.
- Click on OK.
Limit Searches to a Column in MS Excel
Many of us have and use MS Excel Worksheets that accumulate more and more data over time. Pretty soon you will find yourself mucking about in all of that data, trying to search for something specific.
We all know that we can search in MS Excel by using CTRL + F to display the Find tab of the Find and Replace dialog box and do a search of the entire worksheet.
If you want to place a limit on your search, however, there is another way to do this. Follow the steps below:
- Select the range you want to search before you press CTRL + F.
Perhaps you only want to search a specific column in your worksheet. Selecting that column before displaying the Find tab of the Find and Replace dialog box will perform the search only in that range of cells, ignoring the rest.
Align Tables to Formatting in Page Layout: MS Word
When you have a document that contains tables and you decide to change the page setup, by default, tables will not change their width to match your formating.
For instance, say you have created a table that extends from the 1.0" page margin on the right. If you decide to change the margins to 0.5", the table moves to the left.
You could try to reposition your table by clicking and dragging the table borders so they continue to extend to the right margin or you could try formatting the columns and their contents to achieve that result. But why waste all that time when you could have Word automatically reposition it for you?
Before you make any changes to your page setup, follow the steps below:
- Click just to the left of your table and drag to select it.
- Once your table has been selected, right-click and scoll to AutoFit and then select AutoFit to Window.
MS Word will now automatically adjust your table width to any margin or page orientation format editing. With the AutoFit to Window feature enabled, you can use tables to keep your header and footer text properly aligned. Thus, instead of using tab formatting use a table set to AutoFit to Window to automatically center or right-align the contents of a header or footer!
Included in the Premium Newsletter:
- Windows Recycle Bin
- Type Text Directly onto your Images in MS Word
- Track Worksheet Changes in MS Excel
- Change Color of Text Without Changing Bullet Color in MS PowerPoint
- Embed a Sound in MS PowerPoint
- Carol's Corner Office members receive the premium edition of the Word Bytes Newsletter. To become a member click HERE.