hi, i have various worksheets and within that worksheet there are cells having #DIV/0!. I want this to be replace by zero. i know there is a formula which...

I am using Excel 2007 in XP home sp3. I have a printout with salesman names and their sales for the week. Can I scan that sheet of names and numbers into a...

Hi I need help with some formulas in a worksheet which records, over 16 weeks, all performances of an athlete while highlighting any improvements on their...

Seems that the format in windows xp is a different format in windows vista. I try to open an excel file sent from xp to vista and it gives me a message that...

need help for page set-up for excel to catalog small museum library, Category, ISBN#, Title, Author, Subject. I have very limited knowledge of excel but know...

I am wondering how to sort cells/rows in groups. Each group will contain many rows containing product info for a given day. Each group will also contain ONE...

Window XP Sp2 - MS Ofc 2000 / Excel I created a list in Excel by doing a copy/past from a web site. (List of name, address, phone, website) I did a save when...

I have a spreadsheet that comes to me daily with about 60K rows in it. One of the columns has cells with 15 digit numbers in it formatted as text. I need...

Hi, I am trying to create a pivot table of of some small data and when it is created it unsorts the dates. In my data sheet i have it as January 2008,...

I just edited a picture to the way I want it using Paint Shop Pro. I used jpg. format. It is a very clear and nice picture. When I go to insert it into Excell,...

Hi, I know it's a silly question, but... Is it possible to rename the header row in Excel, so that there would be sth else than A B C D E ... ? Thanks for...

Please recommend a basic Excel on-line training program for the beginning user

Example: Spreadsheet has a page for each year (2000, 2001, 2002, 2003, 2004) - each page contains same # of columns and same titles. How do I take all the...

If you use Excel everyday and spend lots of time on data/text processing, then you will find the this tool (UDQ Add-in) is very powerful and can speed up your...

OK, maybe that wasn't the best way to ask the question... I need to create this scenario: Question: "Lot Size?" Answered by "X" under "Small"(A3) "Medium"(A4)...

table: 1.5.2006 blue 2.5.2006 green 30.4.2005 green 21.5.2006 yellow 21.6.2006 blue how can I count all the green guys with the datum after...

Hi, How do I prevent excel starting a new instance of internet explorer whenever I click on a hyperlink in a spreadsheet. I have a spreadsheet with 3000+...

I have to combine my list of almost 800 names listed as last name, first name, with another list which has them as first, then last. Can I somehow correct my...

Is there a way to have a lookup value displayed when you starting typing the first couple of letters of the value in the box? Also, I would like to have a...

How do you make the date format 1/1/2004 appear as the day of the week Saturday?