Wednesday, May 02, 2007

Games and Tips for today 5-2-07


http://www.huhahi.com/fun/balls_game.html

http://www.jokeroo.com/games/snowplow.html


Multiple Select Without a Shift

Do you use MS Office drawing tools, WordArt, textboxes or graphics?

Ever find yourself struggling to select multiple items at once?

there's a little help in this area that's associated with the Drawing toolbar.

What we're looking for is the "Select Multiple Objects" button.

You're probably not seeing this one yet, but we can easily fix that right now.

At the end of the drawing toolbar, there's a down arrow.

Click it and choose Add or Remove buttons, Drawing submenu.

When the list of available buttons for the Drawing toolbar is displayed, choose Select Multiple Objects from the bottom of the list.

Once the button is displayed, you're ready to go.

Click the button.

The Select Multiple Objects window will open with a list of available objects for selection in the file.

Make sure all the elements you want selected simultaneously are checked and then click OK.


The Print Area in Excel

Basically, it's a specific area in a worksheet to be printed, ignoring everything else on the sheet.

So, how do we actually set the print area?

It's as easy as 1, 2 and well, we really don't need 3. So, how about 1 and 2?!

1. Highlight the cells to be printed.

2. Go to the File menu, Print Area and select Set Print Area from the submenu.

That's it. You're done.

Now, when you print, you'll get only the information in the cells that you selected.

(A quick note here: I did try using the Ctrl key to select separate sections for the print area. What I found was that Excel printed each section on a separate sheet of paper).

Okay, so now that you know how to print just part of a worksheet, let's say you used this little trick to print part of a worksheet and now you need to print the entire thing. How do we get it all back?

It's easy enough. You don't even have to highlight the cells!

Simply go to the File menu, Print Area and select Clear Print Area from the submenu.


Do you use styles in MS Word?

Do you always follow one particular style with another one? Maybe a certain heading style is always followed by another style in whatever work you do.

Would you like a way to get Word to make the style switch automatically?

Yeah, who wouldn't in cases where the style switch is made so frequently?

You'll be surprised at just how simple it is to get Word to automatically switch them up.

First, we need to see the Styles list. The Format menu, Styles and Formatting choice will do the trick or if you're task pane savvy, you could switch over to using the drop down list of choices there.

Either way, we need this list:

If the Style you need to work with isn't on the list, just click New Style and select it from the list.

Once you can see the first style in your "chain" of two, place the mouse pointer over it and click the down arrow on the right side.

Choose Modify from the menu that opens.

Once in the Modify Style window, you're looking for the "Style for following paragraph" field.

From this drop down list, choose the style that should be applied to paragraphs that come after the initial one.

For example, if you always follow Heading 1 with the Normal style, be sure you select Normal from the list.

Click OK when you're done.

That's it. One style to follow another, without the extra work of actually making the change!

No comments: