select

Fri
30
Jan
Dennis Faas's picture

Find and Replace Across All Pages In MS Excel

There will always be a time when you need to do a find and replace on every spreadsheet in your MS Excel Workbook. Of course, you could do each find and replace separately but we all know I don't roll that way. I love to save time and keystrokes! So ... follow the steps below to learn how: Right click on a sheet tab and select Select All Sheets. Select Edit | Find, or click CTRL + F. Enter the term for which you would like to search. Click the Find Next button. In versions 97 and earlier you can only search a single spreadsheet. When you become a member at CarolsCornerOffice.com, you have access ... (view more)

Mon
29
Dec
Dennis Faas's picture

Adding a Work Menu in MS Word

The Work menu is one of the oldest and most obscure features supported by MS Word. The Work menu is basically a Word specific list of your favorite or most often used documents that remains hidden in the Customize dialog box until you drag it out of ... there and place it on your toolbar. The Work list will hold as many as nine document shortcuts. It is a handy place to store those documents that require regular access. Follow the steps below to put the Work menu in its place on your toolbar: Click on View | Toolbars | Customize. Select the Commands tab. Scroll to the bottom of the Categories ... (view more)

Mon
24
Nov
Dennis Faas's picture

Apply a Fill Effects Background in MS PowerPoint

Using fill effects in MS PowerPoint can give your presentation some razzle dazzle! I usually use this on my first slide, especially when creating a picture album. To use one of the fill effects options in MS PowerPoint, follow the steps below: Click ... on Format | Background. Click the drop-down list and then click Fill Effects. When the dialog box appears, you can select from four possible background types. To apply a gradient background, follow the steps below: Click the Gradient tab. The Fill Effects dialog box now includes the options that are available for applying a gradient background. ... (view more)

Wed
29
Oct
Dennis Faas's picture

Change File Save Location in MS Word 2007

Word 2007 by default stores your documents in the My Documents folder in Windows XP. If you are using Microsoft Vista, your documents will be stored in the Documents folder. The programmers most likely set this up in this manner so that you would ... always know where to find your files. Believe it or not, I have had users send me an email telling me that they have saved a Word document and have no idea where they have saved it! But, you may wish to store your documents in a different location, such as an external hard drive. If that is the case, you will have to use the File | Save As to ... (view more)

Thu
09
Oct
Dennis Faas's picture

Number Formatting in MS Excel 2007

Sometimes within your worksheet, you may have different, non-standard numbers. Perhaps you have dates and times and currency numbers. If you want MS Excel 2007 to interpret these different, non-standard numbers the way that you do, you will need to ... format the number properties in the cell in which they appear. Follow the steps below to change the number formatting of a cell in MS Excel 2007: On the Home tab of the Ribbon, find the Number group. In the Number group, there are various different options you can use to quickly format the numbers in your selected cells. The first option you will ... (view more)

Thu
02
Oct
Dennis Faas's picture

Set a Language Style in MS Word 2007

When you enter text into your Word document that is something other than English, chances are that MS Word will not recognize it and will interpret it as being misspelled. If it is necessary for you to have sections of non-English text within your ... English-language Word documents, then you know how annoying it is when Word checks the spelling of the non-English text using its English dictionary. Word is programmed to automatically proofread your document for the language version that is installed on your computer. If you purchased your licensed copy of MS Word in the United States, your text ... (view more)

Tue
16
Sep
Dennis Faas's picture

Use a Picture File as a Background in MS PowerPoint

Sometimes you want to get a little fancy with your PowerPoint presentation. Suppose you had put together a little presentation for Grandma and you wanted to do something special for her. Sure, that snazzy template is great but it won't mean a lot to ... Grandma. Wait! I bet Grandma's eyes would light up if she saw her old house in the background of this presentation, wouldn't they? Follow the steps below to learn how to accomplish this task: To use a picture file, rather than the template's defined background, select Format | Custom Background. Check the Omit Background Graphics From Master box. ... (view more)

Tue
12
Aug
Dennis Faas's picture

MS Excel's Top/Bottom Rule Allows for Rapid Data Analysis

MS Excel 2007 has a new feature called data visualization that will allow you to see when data in a worksheet has attained a certain value. You could use this nifty feature to see which departments in your company have attained above-average sales ... this quarter. Follow the steps below to learn how: Select the data cells you would like to analyze. Click the Home tab. In the Styles group, click Conditional Formatting. Select Top/Bottom Rules. Click Above Average. Click OK. All cells with above-average values will appear in red. If you would like to see the top 10% performers, follow these steps ... (view more)

Wed
16
Jul
Dennis Faas's picture

Building a Table of Contents Using Custom Styles

In my last article, we talked about generating a table of contents and updating it. What if you don't want to use Word's built-in heading styles for a table of contents? Perhaps you have created your own styles, such as OutlineLevel1, OutlineLevel2, ... or OutlineLevel3, and you wish to use these styles in the table of contents. You can use a combination of built-in and user-defined styles when generating the table of contents. Generate A Table of Contents Using Custom Styles Open a document that has been formatted with customized styles. Place the insertion point in the document where you want ... (view more)

Tue
15
Jul
Dennis Faas's picture

Updating an Automatic Table of Contents In MS Word

A reader recently wrote to ask "Once a table of contents has been created, can you change the page numbers appearing on the right side of the TO?" I am assuming that the reader is talking about an automatically generated Table of Contents (TOC). And ... if that is the case, the answer is yes, absolutely! The caveat is that you have to know how to create an automatically generated TOC in order to update it when you add more text. You can generate a table of contents using Word's built-in styles, such as Heading 1, 2, and 3, or by creating and using your own custom styles. If you have a document ... (view more)

Pages

Subscribe to RSS - select