[October 15, 2009]

There is a definite chill in the air now and it gets dark very quickly after five thirty in the evening. The winter clothing is in the closet, the cat has gotten her winter fur and the mice are scurrying, trying to get indoors for the winter. The Fall foliage is absolutely beautiful to take in. When the sun hits the trees at just the right angle, they look aflame with color! I am truly blessed to live in the country where I can see all this pageantry take place with a front row seat. The older I get the more I see miracles everywhere in nature. I hope I never get too old or jaded to see the beauty in a Fall sunset or the glory of the sun shining on wet leaves and spider webs.

No matter where you are located in this big old world of ours, I hope you are taking the time to enjoy the changing of the seasons. We're all busy and try to cram in as much as we can every day, but try to find at least five or ten minutes to center yourself, still the noise and just be. You will be amazed at the change and you can then see things with a clearer eye and enjoy the changes that are taking place all around you.

Please join me in welcoming Timothy, William, Judith, Charles, James, Lawrence, Bernie, Holly, Graham, Vincent, Murad, Gabrielle, Jack, John, j ean, and Giussepe, 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!

Carol's Signature

Table of Contents

Add Group and Outline in MS Excel 2007- Easy to do!

Add Group, Outline Symbols, etc. in MS Excel- Save time and keystrokes!

Copying or Applying Color to Groups and Outlines in MS Excel- Spiff it up!

Word 2007 audio course buy word 2007 audio course

Add Group and Outline in MS Excel 2007

To add Group and Outline in MS Excel 2007, follow the steps below:

  1. Select the cells to group.
  2. Select Data | Group in the Outline group.
  3. Alternatively, click Alt + Shift + Right Arrow and click OK.
  4. Repeat the steps above and add group and outline to more sections in your spreadsheet.

To clear groups and outlines, select the same cells and select Data | Ungroup in the Outline group.

Bookmark and Share

Return to Table of Contents

LaptopToys.net
Laptop Toys - Laptop Cooling

Add Auto Outline Symbols, etc. in MS Excel

Follow the steps below to learn how to add these symbols to your toolbar in Excel:

  1. Place your mouse arrow over one of your toolbars.
  2. Right-click and select Customize from the shortcut menu.
  3. Select the Commands tab.
  4. From Data, drag the appropriate icons to the Standard toolbar.

In version 2007:

  1. Right-click and empty space on the Ribbon, and select Customize Quick Access Toolbar (QAT).
  2. From the resulting dialog box, under Choose Commands from, use the drop down arrow to select All Commands.
  3. Scroll down until you find the icons you would like to add, highlight them and click Add.

That's all there is to it!

Bookmark and Share

Return to Table of Contents

Copying or Applying Color to Groups & Outlines in MS Excel

To copy or apply colors to summary totals in MS Excel follow the steps below:

  1. Create your summary report using Group and Outline.
  2. Select any cell in the List.
  3. Click Ctrl + Shift + * (asterisk) to select the List.
  4. Click Alt + ; (semicolon) to select the visible cells.
  5. Copy and paste the data into a different spreadsheet.

OR

  • Apply color to the visible cells by selecting a color from the Fill Color icon on the Formatting toolbar.

 

Bookmark and Share

Return to Table of Contents

Included in the Premium Newsletter:

  • Print Selected Pages From Different Sections of your MS Word Document
  • Print your MS Excel Spreadsheet on a Fixed Number of Pages
  • Recycle Slides in MS PowerPoint
  • Random Footnote Separator in MS Word
  • Give your Right-Aligned Text Some Space in MS Excel
  • Print Files without Opening Them

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.