If I install ms excel by using the option "run from network " at the time of installation, does it use microsotf license for each machine or use only...

hi i want to select a few sheets and move it before a sheet name total. i have to program as : Sheets(Array("Q1 2005", "Q2 2005", "Q3...

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...

I have Windows 98 on my home computer. I received an Excel spreadsheet and cannot open it in Works. What do I need to do to open the xls spreadsheet and...

an U help me out,,,, Number separator of the excel according to the Indian Standard For e.g. 1000 is displayed as 1,000 10000 is displayed as 10,000 100000...

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 would like to create a footer that displays the version number of the document. This information is located in the file on a worksheet of its own. I would...

Rather than selecting the "Automatic Size" for each cell comment ONE AT A TIME, is it possible to set your options so that all cell comments start out with the...

I have multiple databases in Excel with similar data that I need to pull into one large database. The only way I know to combine the information is cut...

Hi, I have got an excel spreadsheet which has 500+ hyperlinks. I need to extract the address behind the text to be able to import the actual address into a...

Does anyone know how I can change the font color on the worksheet tabs? Thanks in advance. Mike in Chicago

I have a column of cells that each have a comment attached to the cell. Is there a way to take those comments, and keep them attached to the record of data...

I am not sure I understand what I want here. The name of the item is Data Table. My customer wants the following info to be completed: Rate 3% Investment ?...

I'm using the formula below rather than getting blank if the statement is false, I'm getting a zero, can you help? =IF(-K17=K16,-K17-K16-K40," ")

Hi, I do not arrive to create this personalized format who is responding to these 3 conditions (number is displayed in percentage). 1) if 0 the colour...

I'm trying to get the following formula to work. I16 is a data validation list (drop down list) and I keep getting the circular reference error message, can...

Hopefully, I'm not asking for the impossible. On my worksheet I have among other things, 2 cells. The first cell is simply a $; the second cell is...

This is probably a stupid question, but is there anyway to retrieve a page you have been working on if the program crashes? The Dr. Watson box came on the...

I have a column of numbers formatted without dollar signs & decimal points: 1234 5678 9100 I want to apply Currency formatting with decimal points. I select...

I am trying to build up a YTD value in a cell on a worksheet named YTD. The YTD value is the sum of cell ref "A17" on each worksheet named JAN, FEB, MAR...etc...