[ April 2007 ]

Happy Easter to everyone! If your persuasion doesn't celebrate Easter, then Happy Spring!!

My pansies and daffodils are in bloom and the forsythia is golden and growing wildly. How could you NOT love springtime?

Easter Bunny

Carol's Signature

Table of Contents

Grid Line Colors in Excel - Don't like the default color? So change it!

Split a Bulleted List Between PowerPoint Slides - Don't let PowerPoint keep downsizing - split your list.

Print Multiple Sheets on One Page in Excel -Save ink and use this shortcut.

Grid Line Colors in Excel

Although I find that the light gray color of the grid lines in MS Excel is just right for me, some folks have problems with it. Luckily, you can change the grid line color to something more suitable to your tastes.

Follow the steps below to change the color of the grid lines:

  1. Select Tools | Options from the main menu.
  2. On the View tab, find the Window option section.
  3. Choose a color from the Gridlines Color (Excel 2002, 2003) or Color (Excel 97, 2000) drop-down list.

gridline color

You are now returned to your worksheet with grid lines the color of your liking.

Return to Table of Contents

Split a Bulleted List Between Slides in PowerPoint

I don't know of a way to build in automatic overflow of text to a new slide in PowerPoint like you can do with text boxes in Word or in Publisher. However, once your presentation is designed, you can split a bullet list between two slides.

  1. Follow the steps below to split up a bulleted list in your PowerPoint presentation:
  2. In Normal view, switch to the Outline tab.
  3. Move the insertion point where you want to split the text.
  4. Press Enter.

For this to work, you must have your AutoCorrect option set properly.

  • From the main menu choose Tools | AutoCorrect.
  • in the AutoFormat As You Type tab, find the Apply As You Type section.
  • Un-check the AutoFit body text to placeholder option.

Otherwise, PowerPoint will continue to shrink the font when you have more text than can be accommodated on a slide, which is not what you want to happen.

AutoCorrect Dialog Box

Your bulleted list should now be split between two slides.

Auto Format as you Type

Return to Table of Contents

Print Multiple Sheets on One Page in Excel

If you ever have the need or desire to print several worksheets on one page in MS Excel, you can do it. Just follow the steps below.

  1. Choose Print from the File menu. Excel displays the Print dialog box.
  2. In the Print What area of the dialog box, choose Entire Workbook.
  3. Click the Properties button. Excel displays the Properties dialog box for the printer.

All printers are different so you will have to poke around a bit in your printer's properties to find the right place.

With my printer, I select:

  • Options.
  • Paper Set Up.
  • Then select Make Post or Many Pages on a Sheet.
  • Set the Pages Per Sheet drop-down list to 4.
  • Click OK to close the Properties dialog box.
  • Click OK to actually print the worksheets.

Your printer may offer a similar capability to what is outlined here, but you may need to do some exploring through the printer's Properties dialog box to find it.

Of course, printing in this manner can lead to some very small text on the printout, because the printer driver simply reduces each page to occupy a proportionate area of the printed page.

Return to Table of Contents

Included in the Premium Newsletter:

  • Creating an E-mail Letter in MS Publisher
  • Delivery Point Barcodes in Word 2007
  • Restricting Permission to Your Documents in Office 2007
  • PowerPoint Presentations End with a Black Slide
  • Add and Edit Data in Access
  • Carol's Corner Office members receive the premium edition of the Word Bytes Newsletter. To become a member click HERE.