[April 15, 2009]
Happy Easter to everyone. I know this is a few days late but I still wanted to extend my greetings.
Even though spring is here it doesn't always feels like it. It was very chilly and rainy here today and I am told that we will have even cooler temperatures tomorrow. I will be very happy once it becomes warm outside and stays that way! We have been clearing brush and trying to keep the forest from encroaching and believe you me, Mother Nature is a force to contend with! The work is never ending and you never know when you are going to come face to face with a snake, mole or some other critter!
Let's get to the tips now!
Table of Contents
Change the Indentation of an MS Excel Cell - Do it Your Way!
Transposing Data in MS Excel - Very Easily Done!
Using the Eraser Tool in Tables in MS Word 2007 - Fixes lots of things!
 |
|
Change the Indentation of an MS Excel Cell
Many times you may wish to change the indentation of the cells in your spreadsheet. This is a quick and easy task, as evidenced by the steps below:
- Key in your text in the cells in your spreadsheet.
- Select the list where you would like to change the indentation.
- Click the Increase Indent icon on the Formatting toolbar until you reach the indentation you want.
- Alternatively, you can click Format and the Alignment tab and in the Indent Box change the number of characters to indent.
- Click on OK.
That's it! You're finished.
Transposing Data in MS Excel
The Transpose feature in MS Excel is used to change a vertical range of cells to a horizontal range or vice versa.
Follow the steps below to learn how to use this feature:
- Copy of range of cells.
- Select a cell in the current or any other worksheet and right-click.
- From the shortcut menu that appears, select Paste Special.
- Check the Transpose check box.
Voila! Transposed! I know you will make use of this feature often!
Using the Eraser Tool in Tables in MS Word 2007
One of the fairly cool things you can do in MS Word is draw tables. I think you will agree that this is a really cool feature.
Another really cool feature is the Eraser tool. You can erase any lines that you have created in your table until it looks exactly the way you want.
Follow the steps below to learn how:
- Create a table as you would any other time.
- Make sure that the insertion point is in your table.
- Display the Design tab of the Ribbon. Note that this is only displayed when your insertion point is in the table.
- Click on the Eraser tool in the Draw Borders group.
- Click and drag to select the table lines you wish to erase.
- Click on the Eraser tool once more or press the ESC key.
Please note that when you erase a line that is a common border between two cells, the cells are then merged.
Just think what else you could learn if you were a Premium subscriber!
Included in the Premium Newsletter:
- Create Bulleted Lists in MS Excel
- Highlight in MS Word Using the Find and Replace Feature
- Applying Styles in MS Excel
- Turn Off Document Protection in MS Word
- Working with Columns in MS Word
- Acronmys in 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.