[September 1, 2010]
And, we're back! As you know, my computer died right around the time that the last newsletter was due to be published and that is precisely why it was not published!
I owe a big debt of gratitude to Dave Hartsock of Dave's Computer Tips. Dave is a wizard when it comes to computers and he walked me through purchasing and installing a new hard drive and restoring everything from my old one because he had previously told me to purchase Acronis True Image to perform backups of all my data.
You may remember Dave because I have mentioned him before regarding different software contests he runs and also because I write articles for Dave's Computer Tips once or twice a month. Dave also has a Forum on his site where folks post their computer and software problems and questions and other moderators like myself attempt to resolve those issues for folks. If you have not visited Dave's Comptuer Tips before, you owe it to yourself to check it out.
Believe it or not some of the leaves on my trees have begun to change. Ahh...summer....your visit is so fleeting. Your leaving is such sorrow. But if you are like me, you like the changing of the seasons even if your favorite is going to be gone soon. The crisp air in the Fall will be a welcome change, but we still have some warm weather left. I I suspect we will be getting some more rain as well, which we dearly need.
The baby hat is finished and I am getting my knitting needles ready to start on a blanket. Hopefully I will have it finished before my grandchild arrives! It's a BOY!!
Please be aware that Microsoft has announced that free support has now been withdrawn for Office 2003. They will start to phase out tips and tricks for Office 2003 over the next few months. Paid support, of course, will remain available to everyone but the Microsoft tips and training sites will now focus on versions 2007 and 2010. So if any of your friends, co-workers or colleagues are still using and plan to continue to use Office 2003 steer them to our newsletter. Yes, we will begin phasing in tips and tricks for Office 2007 and 2010 but we won't forget the folks still using version 2003!
I had the honor approximately three weeks ago, of visiting an elderly woman in the hospital to notarize her living will, medical directives, etc. She was quite a lady and though she knew her days on this earth are not many, she still retaied her sense of humor and her caring for others around her. She was a lovely woman who had traveled the world and I loved to sit and listen to her recount her travels and experiences. It made me sad to see her failing and knowing that she would not be here to regale me with her tales much longer, but I am the better person for having known her. No matter how many times I see it and am a part of it, I am always struck by what a short time we are allotted here on earth. I think that it is very hard, if not impossible, to wrap the human brain around the concept of time, but at these events, I always make a vow to myself that I will live more in the moment and try to make a difference during my visit. I hope that you also vow to leave the world a better place. 'Tis a shame it takes us so long to learn these basic lessions. Too soon we grow old - too old we grow wise - an old German proverb.
The quote for the day is:
I still find each day too short to think all the thoughts I want to think, take all the walks I want to take, read all the books I want to read, and see all the friends I want to see. -- John Burroughs
Please join me now in welcoming Robert, Donald, Rocjard. Steven, Pauline, Juanita, and John, as the latest premium subscribers to Carol's Word Bytes Newsletter. Welcome to the family! I am trying to reach a million subscribers so, if you know someone who struggles with an application in Microsoft Office, like Word or Excel, do them a favor and tell them about our newsletter. They will be grateful to you for helping them!
Let's get to the tips now!
Table of Contents
Working with Columns in MS Word 2007 - Have it your way!
Transpose the Contents of your Table in MS Word - So easy!
Zoom Only Selected Cells in MS Exce l- Cool stuff to know!
 |
|
Working with Columns in MS Word 2007
MS Word comes with a tool on the Page Layout Ribbon in version 2007 that allows you to modify the number of columns in your document or the text in a selection.
The Columns tool is located in the Page Setup group of Word. It has several options:
One - Use a single column.
Two - Use two equal width columns.
Three - Use three equal width columns.
Left - Use two columns in which the left column is more narrow than the right column.
Right - Use two columns, in which the right column is more narrow than the left column.
More Columns - Display the Columns dialog box so you can set up the columns to your liking.
You can use the Columns tool by simply selecting one of the above options. If you have selected text prior to employing the Column tool, your selection is applied to only that text. If you make a selection and then decide you do not like the results, you can immediately click CTRL + Z to undo the formatting.
Transpose the Contents of your Table in MS Word
If you work with tables in your documents, there may come a time when you might find it in your best interest to transpose the contents of your table so that the rows become columns and the columns become rows.
There is no way to do this in MS Word, but there is a way to this in MS Excel.
Follow the steps below to learn how:
- Create your table in MS Word.
- Select the entire table and copy it to the Clipboard.
- In MS Excel, use Paste Special to paste the table as text.
- Select the cells you would like to transpose.
- Click on Edit | Copy.
- Right-click on the upper left-hand corner of a range of empty cells than can accommodate the transposed result.
- Select Paste Special and check the transpose checkbox.
Zoom Only Selected Cells in MS Excel
You can zoom only selected cells in MS Excel rather than your entire worksheet. To do so, you must use the Selection option with the Zoom. This option will allow you to select the cells you would like to zoom in on and chooses just the right percentage to see the selection as large as possible.
Follow the steps below to learn how:
- Select the range you would like to enlarge.
- Using the Zoom drop-down arrow, select View | Zoom | Fit selection.
- When you are finished, select 100% (or the appropriate percentage) from the Zoom control in the Toolbar or select Edit | Undo Zoom or click on CTRL + Z.
Included in the Premium Newsletter:
- Center a Page With Vertical Settings in MS Word
- Show Weekdays Next to Dates in MS Excel.
- Add a Watermark to MS Word 2007 Documents
- Use Drag and Drop to Create Hyperlinks in MS Excel
- Force MS Word to Print Letter Before Envelope
- Compose an E-Mail Without Leaving MS Word
Shouldn't you be a premium subscriber?? With a premium subscription, you get more than double the content and NO advertising! Plus, most instructions come with clear screenshots! With your premium subscription you also receive access to an archive of five years of newsletters and deep discounts on all books and tutorials I publish!! So what are you waiting for? Sign up today!
Carol's Corner Office members receive the premium edition of the Word Bytes Newsletter. To become a member click HERE.