Is there anyway that I can put a picture as a background to a worksheet. Would appreciate any help.

I'm too lazy at the moment to find the thread in which someone asked about the relative merits of SUMPRODUCT vs SUM(IF(..)) when there were...

I have a file with numerous tabs (potentially up to 50), each representing the financial profile for a particular project. I also have a summary tab within...

I have a column of cells which all contain the same formula: eg. =C20-(C20/1.175) As this is a currency cell, even if there is calculation can be done on...

I have a file that automatically assigns a number to a percent format. For example if I type a "1" in a cell it puts .01 if there are two decimal places...

Hi All, I just want to ask for help regarding this problem i had with excel files. Everytime i open a file directly by double-clicking the file name, the...

I have a ComboBox, not in a Userform, where the ListFillRange property is a named range Favorlist which is a dynamic...

In a report i have I was using the MAX function, which i thought was pulling the last value in a column. Instead that function just picks the highest value. ...

Does anyone know how to change the date format in excel to read (ie) 20020429 instead of 04/29/2002..... Is there a formula or something? I tried changing...

I have conditional formatting on a worksheet but cannot copy the formatting to another cell using format painter. Also on this worksheet and another for which...

Hi All- I have tried following the instructions in the various messages for getting the 2002 download to work for Office 2003, but I am having no luck. I have...

Here is the following formula that is giving me an error. =SUM(A1:A(B1)) I want to total items in column A depending on the number I type in cell B1. So if I...

I have recently switched from the MS NT operating system to the MS XP Professional os. My problem is I have an Excel macro that used to work with the NT system...

i am creating a time sheet and want the days to fill down the sheet once a month has been selected from a drop down box in B2 want the dates of the month e.g...

When referencing a cell range in a formula, is there a way to represent the cell range by referencing another cell. What I want to do is this, for...

Anyone face same problem? I'm using WinXP Prof (OEM) and OfficeXP 2003 (OEM) Excel will hang up after a few minutes of work.

How to find paired values (e.g. Surnames or Names) in one column --- Message posted from http://www.ExcelForum.com/

Hello, I have a spreadsheet with appx 100 columns and 500 rows, that we use as a source for 15 odd pivot tables. When we refresh, about 30-40% of the time,...

I have imported a list which only gives the whole name for an individual. In some cases there is a first and last name, other have a middle name, or a middle...

I can't seem to get Excel to accept the lower case text: "e.g." or "i.e." instead it insists on capitalizing the first letter to "E.g." and "I.e" It can be...