Archive for the ‘Excel’ Category


How To Learn Excel

Dear Computer Lady, Could you please advise me of the best way to learn excel. With thanks, Karen

Read More...

Question About Excel Email Cell Format

Dear Computer Lady, I am baffled by a cell format issue in Excel (ver. 2003). For some unknown reason, when I enter a person’s email address in a cell, Excel automatically formats the entry with a “Mailto” format or tag. So when I click on the cell, my email client opens up with a blank [...]

Read More...

How To Make Two Lines in A Cell

Dear Computer Lady, I am using Windows XP with Excel 2002. I would like to know if there is a way to have 2 lines of type in each cell (for a round robin tournament spreadsheet I’m trying to create)? Thanks, Geri Dear Geri, There is a way to create two (or more) lines of [...]

Read More...

How To Highlight in Excel

Dear Computer Lady, I’m working on a list in Microsoft Excel. I need to highlight certain lines with either yellow or purple, but still leave the text black. When I highlight the line and chose yellow or purple, it changes the text to either yellow or purple. Please help!!! Sylvia

Read More...

Excel Formats Email Addresses

Dear Computer Lady, I am baffled by a cell format issue in Excel (ver. 2003). For some unknown reason, when I enter a person’s email address in a cell, Excel automatically formats the entry with a “Mailto” format or tag. So when I click on the cell, my email client opens up with a blank [...]

Read More...

How To Create Excel Template

Dear Computer Lady, Is there a way to set Excel 2007 so that a header and footer appear on all new documents instead of entering it on each separate document? I read your column all the time. Thanks for all you help, Jayne

Read More...

Spreadsheet Programs

Dear Computer Lady, I got Windows 7 and I find that Microsoft Works is not there anymore. I want to do spreadsheets. Can you help? I have some of your lessons but haven’t seen anything about that. Thanks, Helen

Read More...

Mail Merge

Dear Computer Lady, Thanks for your newsletter. I always look forward to reading it. I have Windows XP, along with MS Word 2000 and Excel 2000. I have a spreadsheet in Excel that contains about 200 names, addresses, and phone numbers. Could you tell me how to print labels from Excel using this spreadsheet? Do [...]

Read More...

Quick Access to Excel Commands

Dear Computer Lady, I read your answers faithfully, and I hope you can help me learn how to get used to the new 2007 version of Excel. It seems like finding common commands is a lot harder than it used to be. For example, printing my worksheet used to be one click, but now, I [...]

Read More...

Movie Database

Dear Computer Lady, I am trying to find a simple database program that will let me enter all of my movie DVD’s. All of my movies are on shelves in numerical order. I need to enter the movies into a database starting with the number and then the title of the movie. After all of [...]

Read More...