Carol's Corner Office

If you include a distribution list in the To or Cc box of an email message, all of the recipients -- whether members of the distribution list or not -- can see the addresses of individuals in the lists. Outlook does not retain the list name in the ... address field of the message but instead replaces it with the actual addresses from the list. In some cases, the members of a distribution list may not want to have their addresses made public, even to other members of the list. In these situations, address the message using the Bcc box, rather than the To or Cc box. To display the Bcc box in the ... (view more)

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 and you can do it rather easily as ... well! Follow the steps below to change the color of the grid lines: Select Tools | Options from the main menu. On the View tab, find the Window option section. Choose a color from the Gridlines Color (Excel 2002, 2003) or Color (Excel 97, 2000) drop-down list. You are now returned to your worksheet with grid lines the color of your choice! When you ... (view more)

I hate it when an error message shows up in my Excel spreadsheets! Doesn't everyone? When you see an error message it generally means that somehow, somewhere, a typo has made its way into one of your formulas or a piece of information is either ... incorrect or missing. If you were the author of the formula that is returning the error, you may not have too much difficulty in determining where the trouble is located. However, if you are working in someone else's spreadsheet, it may not be as readily apparent. That is when you use the Auditing Tools in MS Excel to sniff out the cause of the error. ... (view more)

Changing the size and font of comments in MS Word is easy and painless! You can use standard formatting commands to modify the text in comment balloons as you type. Follow the steps below to learn how: On the Format menu, click Styles and ... Formatting, which will open the Styles and Formatting task pain in the right margin. In the task pane, under Pick formatting to apply, make sure the Comment Text entry is visible. If it is, continue; if it is not, follow the steps below: On the Show drop-down menu, click Custom. In the Format Settings dialog box, under Style to be visible, click Comment Text ... (view more)

Ever want to learn how to copy and paste row height in MS Excel? I have had many inquiries regarding this tip and it is such an easy thing to do! Follow the steps below: Select the row you would like to copy. Click on the Format Painter icon on your ... Standard toolbar (or on the Home tab is you are using version 2007). You will now see a small paint brush. Simply drag it where you would like to copy the row height. That's all there is to it! You have now copied the format to your new row. When you become a member at CarolsCornerOffice.com, you have access to this and many, many more articles ... (view more)

Isn't it so frustrating when after you create a table, have it all formatted the way you want it, and have even keyed in all your text -- that you decide you want to key in text above the table? Ever have that experience? I bet more than a few of ... you have. You certainly don't want to start over from scratch! Well you might not believe it but I am going to tell you the simplest way ever to get that blank space above your table so you can key in any sort of text you like leading into your table. Follow the steps below to learn how: Click in the upper left cell of your table. If there is text in ... (view more)

I am a multi-tasker. I almost always have several applications open at any one time; for instance, when I am creating my newsletter! So, in the interest of saving time, I usually open all of these documents, spreadsheets, etc. all at once. Follow ... the steps below to learn how: Click on File | Open, or in 2007, click the Office button and Open. You can also use the keyboard shortcut CTRL + O. Find the files you would like to open. If the files are contiguous, click on the first one to highlight it and then depress your Shift key and while still holding it down, click on the last item in your ... (view more)

One of the things you can do in Microsoft Outlook is print a blank calendar. This can be useful for taking notes in a meeting or other office functions. Personally, I print a blank calendar each month for my students so they can keep track of what ... they have going on for the month. You can quickly print a blank calendar in Outlook using the steps below: Within Outlook, click the File menu, point to New, and click Folder. Type in a name for the folder. Click Calendar Items from the Folder contains list. Click Calendar under Select where to place the folder. Click OK. Highlight your new folder ... (view more)

I have had two very nasty experiences with the Dell Company. In the first case, every part had to be replaced in my brand new computer. The second time, the same thing occurred and Dell replaced my computer but refused to give me a computer with the ... same operating system as the one I had originally purchased. A friend of mine purchased a computer from Dell and was promised (I was on the phone line and heard) that her computer would be shipped with the software to downgrade to Windows XP from Windows Vista, but only if she purchased the most expensive version of Windows Vista in the first ... (view more)

There are a number of way in which you can copy formulas in MS Excel. You can use the Autofill feature or select the cells you want to copy to, enter the formula in the active cell and press Ctrl + Enter. These methods work very well for you in ... Excel unless you have hundreds of rows that you would like to copy. Let's say you have 100 classes listed in Column A of your spreadsheet and Column B lists the in-state tuition price of each class. Wouldn't it be nice to enter a formula that calculates the price for each class and displays the results in Column C? The practice of selecting hundreds of ... (view more)