Carol Bratt

Working with multiply sheets concurrently is how MS Excel power users create and format a complex workbook with the least amount of effort expended. Follow the steps below to make working with multiple sheet a piece of cake and you will be on your ... way to becoming a power user! Hold down the CTRL key as you click each tab top select multiple worksheets. To select a contiguous group of worksheets, click the first one in the group and then hold down the Shift key and click the last one in the group. To select all the worksheets in the current workbook, right-click any worksheet tab and choose ... (view more)

Each time you save a Word 2007 file, it winds up in the My Documents folder. I will tell you how to change your default document folder for Word 2007 files. In Windows, all your Word documents save to the My Documents folder by default. However, you ... may require that you save your documents to a folder on a network server. Rather than navigating to the network server every time you need to save a file, you can change the default so your Word 2007 files automatically save to the correct folder. Follow the steps below: Click the Office button. Click the Word Options button. Click Save. Under ... (view more)

Outlook 2007 makes it surprisingly easy to add appointments. It will also warn you when you have double-booked! There are two ways to enter an appointment. One is very quick and the other is more complete. If you know you're going to have lunch with ... your sister on Tuesday, it's not that big a deal and so you can simply click on the starting time of your lunch date on your calendar, type a description, such as Lunch with Sis, and press Enter. Voila! Your appointment is now scheduled. Oftentimes the appointments that you set up at work require you to include a bit more detail that you would ... (view more)

When you're in a meeting and you are trying to set up the next meeting, you need to find the dates fast. In Outlook 2007 that is no longer a problem! To find a date quickly, follow the steps below: Choose Go | Go To Date. Or press CTRL + G. The ... dialog box appears with a date highlighted. To go to another date, type the day you want as you normally would. There is another really cool way to change dates in Outlook 2007. You can type in something like "thirty days from now." Outlook understands English when it comes to dates. I'm not sure if you want to use that feature all the time, ... (view more)

The easiest way to get around in your calendar is using the Date Navigator which is located in the upper right corner of your screen. To use the Date Navigator, follow the steps below: Click the Calendar button in the Navigation Pane. Or, you could ... simply click CTRL + 2. Immediately your calendar appears! Choose View | To-Do bar. The To-Do bar appears on the right side of the Outlook screen. The top part of the bar contains the Date Navigator. The bottom part shows an abbreviated list of your upcoming tasks and appointments. Click the word Day, Week or Month in the Navigation Pane. One of ... (view more)

Lines are used for all graphics in MS Excel. Lines are typically used to outline the shape, but you can also use them for arrows and for drawing directly on your worksheet. Excel allows you to specify the color or pattern that should be used for ... your lines. To change the line color used in an object, follow the steps below for a version prior to 2007: Make sure the Drawing toolbar is displayed. Click once on the object whose line color you want to change to select it. Click on the Line Color tool o n the Drawing toolbar. The color of the lines in the object are changed to the color used in ... (view more)

To ensure that the formatting of your slides remains static when a presentation is opened by someone else, you should stay with the default fonts that ship with Windows. It is not guaranteed, but usually it is safe to use Arial or Times New Roman ... fonts. Having said that, your presentation stands out from the mundane when you use different fonts. Using one or two different fonts within your presentation makes it more interesting. The only drawback to that is that if your audience doesn't have the fonts that you used installed their system, then PowerPoint will select a font substitution and it ... (view more)

Most folks use the same margins for all of their documents. It's just as easy to set the default margins in Word 2007 as it was in 2003. Follow the easy steps below so that you only have to set your margins once. If, for instance all of your ... documents have one-inch margins, you can set them once, and then make it the default setting for all new documents. Follow along with the easy steps below: In the ribbon, click the Page Layout tab. Click the Margins tool in the Page Setup group. Click Custom Margins. Change your right and left margins to one inch. Click the Default button. Click Yes. All ... (view more)

You will notice at the bottom of the Ribbons in MS Word 2007 there appear small groups. Each group contains individual tools or controls. Suppose you are displaying the Page Layout ribbon and you really want to access the Home ribbon's Editing ... tools? That's where the Quick Access Toolbar comes into play! Any item on the ribbon, whether it be individual tools, groups and even dialog box launchers, can be added to the Quick Access Toolbar (QAT). If you find that you use the Bold attribute quite often, it's a simple matter to add it to the QAT. Simply right-click on Bold and choose Add to Quick ... (view more)

MS PowerPoint has always been super easy to use even if you've never had any formal training, but this version is even easier than ever before! Take a look at the features below: There are twenty slide themes that apply colors, fonts and effects ... that will make your presentation look professional and consistent. More than twenty pre-set color schemes that will determine the colors applied to the slide text and background, hyperlinks, and a half dozen accent colors. It's even possible to create your own custom schemes. Version 2007 boasts two dozen pre-set font themes that apply specific fonts ... (view more)