[July 1, 2010]

Wow! Summer has definitely arrived! It is 98 degrees in my little corner of the world today. I thank my lucky stars every night for air conditioning! I love to have the windows open and hear the birds singing and the other sounds of nature but when it is time to sleep at night I need my air. The heat in my hometown today is oppressive. When you walk out the door it feels as if you are walking into a wall. It should be a bit cooler tomorrow but I think I will be doing my walking/running on the indoor treadmill rather than outside.

Thank you all for your well wishes regarding my husband's illness. He is unfortunately, still having health issues so I really appreciate you good thoughts and prayers. Your support is very gracious and kind.

We will be having the annual Independence Parade in my town again this year and I really want to attend. I enjoy watching all the kids, neighbors, etc. What I most enjoy are the pretty fireworks after dark. Hopefully I will get to see them this year. Keep your fingers crossed for me!

On this Independence Day, please take a moment and remember all the brave men and women who fought to keep our country free.

The quote for the day is:

A good motivation is what is needed: compassion without dogmatism, without complicated philosophy' just understanding that others are human brothers and sisters and respecting their human rights and dignities. That we humans can help each other is one of our unique human capacities. - - Tenzin Gyatso, Fourteenth Dalai Lama

Please join me now in welcoming Ben and Susan 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!

Carol's Signature

Table of Contents

Match the Worksheet to the Job with a Custom Template in MS Excel - Time saver !

Add a Decimal Tab to a Single Table Cell in MS PowerPoint 2007 - So easy!

Add a Decimal Tab to Multiple Table Cells - Time saver!

Word 2007 audio course buy word 2007 audio course

Match the Worksheet with the Job in MS Excel

When you insert a worksheet using the Insert | Worksheet menu option, MS Excel automatically bases the new sheet on the default template. But you may not want to insert just a blank worksheet. Suppose your company uses a special Client Tracking template. A workbook is dedicated to each client and there could be several case worksheets in each workbook. Rather than a blank worksheet, you may want to insert a blank Client Tracking template.

Luckily, you can select the template that MS Excel uses to create a new worksheet.

  1. Instead of clicking on Insert | Worksheet from the menu bar, right-click on a worksheet tab and then select Insert from the shortcut menu.
  2. The Insert dialog box will open, displaying the templates on your PC.
  3. Select the appropriate template.
  4. Click OK.

Return to Table of Contents

LaptopToys.net
Laptop Toys - Laptop Cooling

Add a Decimal Tab to a Single Table Cell in PowerPoint

To align a number to a decimal tab in a table cell, you must insert a tab character before the number in a PowerPoint 2007 table.

Follow the steps below to learn how:

  1. In the Navigation pane, click the slide that you want to edit.
  2. If you do not see the Ruler, click to select the Ruler check box in the Show/Hide group on the View tab.
  3. Position the cursor in front of the number that you want to align in the table.
  4. Click CTRL + Tab to insert a tab character before the number.
  5. On the left-hand side of the horizontal ruler, click Left Tab three times to change to Decimal Tab.
  6. On the horizontal ruler, click the location where you want to place the tab.
Bookmark and Share

Return to Table of Contents

Add a Decimal Tab to Multiple Table Cells

To align numbers to a decimal tab in multiple table cells, follow the steps below:

  1. Select the range of table cells that you would like to format.
  2. On the Home tab, click the Paragraph dialog box launcher.
  3. Click Tabs.
  4. In the Tab stop position box, set the value that you would like for your tab.
  5. Click Decimal under Alignment.
  6. Click Set.
  7. Click OK twice.

For each cell that contains numbers that you want to align to the decimal tab, follow these steps:

  • Position the cursor in front of the number that you would l ike to align i n the table.
  • Click CTRL + Tab to insert a tab character before the number.
Bookmark and Share

Return to Table of Contents

Included in the Premium Newsletter:

  • An MS Excel Chart in an MS PowerPoint Presentation?
  • Filing Contacts in MS Outlook
  • Rule Requesting Some Read Receipts in MS Outlook
  • Font Changes Size in MS PowerPoint
  • Display Track Changes with Your Preferences in MS Word
  • Display a Cheat Sheet for Your Function in the Formula Bar in MS Excel

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.