I follow the ms instrucs and always get the answer #VALUE! WHY??? I have tried formatting the answer cell in every way possible but with no success. Thanks...

is there a way to crop word art in excel? i seen somewhere that it said to save it as JPEG, but i cant find a way to save the wordart as JPEG.

I really know very little about Excel and I need this answered for my job. Any help would be greatly appreciated. In my job I'm often given two spreadsheets...

I want to enter birthdays into a cell. I use the "format cell" for style 5/10/89 (for example). When I actually enter the birth date in this fashion 52952...

I have a range of cells in a column, each cell only contains one letter. I am trying to do a countif to determine how many instances of the particular...

Hello, I created an Excel workbook which retrieves Data through ODBC from a Sybase Dababase. I can retrieve actual data by clicking on the exclamation mark in...

Hi, sometimes when I paste text from a webpage onto my spreadsheet into one cell, the pasted text takes over two or more cells. I don't mean the text just...

Hi, is there anyway to have a formula which I have in a cell in the second row of a worksheet to fill down the entire column of that worksheet, until infinity?...

Hi I hope I can explain this okay. I have a userform which contains several labels whose captions are taken from various cells on a sheet, activated by a...

Hi, I have 2 large data spreadsheets and want to compare/match data between the 2 files. For example both spreadsheets contain columns which have an invoice...

What are the basic differences between Excel 97 and 97 SR-2?

I am trying to write a bit of code that will look at a cell and covert what's in the cell to some sort of code. e.g. Hello Goodbye Yes No The above...

Hello, I am looking for a max if statement if there is such a thing. Same theory as sumif I just would like it to return me the max number in that column for...

When I Drag and Drop cells in excel, I get a pop-up message that says "Cannot empty the Clipboard". Once I click OK, the cells are moved. How can I stop...

Hello, I'd like to take a group of horizontal fields and "rotate" them 90 degrees to have a set of vertical fields. Is that possible? (I'm trying to take a...

I've got extensive pivot tables and a wide variety of other worksheets that look up data in those pivot tables. It all works great on my machine, BUT I have...

I need to make a button on my excel sheet that will sort a pre-defined area (A2:K103) on my sheet the same way as selecting the area manually and...

Hello, I got a response yesterday to a question about the "MAX" function. My question was can I use Max like "sumif". I would like to know what the MAX time...

I'll try and make this as clear as I can... I am looking for a function that will check column b,c,d,e for an entry if there is an entry then check row n in...

I use Excel 2002 w/ XP Pro. Is there a way to enable /turn-on the "quick view" function? Perhaps the newer versions don't have quick view. TIA, Alan