[October 1, 2009]
It is so hard to believe that it is October already! Where did my summer go? I surely tried to pack into my summer all the fun and frivolity I could so that I wouldn't feel as if I wasted any of it, but it still seems as though it was only a week long!
The leaves are changing and I have mums on the porch now and before you know it Halloween will be upon us. Wow! Time is just flying past me at an incredible rate. I am trying to force myself to slow down at least for ten or fifteen minutes every day to just center myself and live in the moment. Too soon we grow old and too old we grow wise eh?
Please join me in welcoming George, Clyde, Craige, Terry, Ronald, Jeffrey, Meir, and Hollis as the latest premium subscribers to Carol's Word Bytes Newsletter. Welcome to the family! 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 always thank you for it!
Let's get to the tips now!
Table of Contents
Create Quick Tables in MS Word - Save time and keystrokes!
List and Table Styles in MS Word - Know the facts.
Using Paste Special Options in MS Excel - More saved time and keystrokes!
 |
|
Create Quick Tables in MS Word
You can quickly create a table in MS Word if you can live with the restrictions imposed when MS word creates the table for you. Those restrictions are:
- You specify the number of columns and rows.
- You define how the table fits on the page.
- Rows start out one line tall, but automatically get taller if necessary to hold text or graphics.
If you can live with those restrictions, you will have a table quickly created for you.
Follow the steps below:
- Click in an empty paragraph where you would like the upper left-cell of your table to be located.
- Click on Table | Insert Table .
- In the Table Size area select the number of columns and rows.
- In the AutoFit Behavior section, specify how Word should determine the width of the table and its columns.
- By default, every new table uses the Table Grid style.
- Click the AutoFormat button to select from many prefab formats for your table.
- Click OK.
MS Word will now generate your table for you.
List and Table Styles in MS Word
MS Word has two built-in sets of styles that you may find useful when applying complex formatting:
List styles allow you to directly specify the level of a list item by selecting the style and applying it to your selected paragraphs. For instance, if you would like a bulleted list item that appears at the third indent level, you can apply the List Bullet 3 style and MS Word takes care of the rest. List styles are available for standard indented lists with no bullets or numbering, standard lists witih extra space inserted below the list item bulleted lists, and numbered lists.
- Table styles, which include all the formatting options available in MS Word's Table AutoFormat dialog. There are dozens of styles.
- To see all the built-in styles available to you, bring up the Styles and Formatting task pane and in the Show box, select All styles. This setting also controls which styles ae available from the drop-down Style list on the Formatting toolbar.
Using Paste Special Options in MS Excel
Using MS Excel's Paste Special options can make use of your creative talents.
It is often possible to save a lot of work by combining several operations in consecutive Paste Special actions. For instance, select All Except Borders to copy formulas and cell formatting without adding underlines and table borders from the original data.
Then repeat the Paste Special option and select the Column Widths option.
This will duplicate an entire table on a new worksheet, leaving out only the borders and underlines!
Included in the Premium Newsletter:
- Align Positive and Negative Numbers in MS Word
- Add Comments to a Formula in your MS Excel Worksheets
- Change the Default Comment Format in MS Excel
- Creating and Editing Linked Objects in MS Office
- Using Bookmarks in MS Word
- Add a Reference Field 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.