I want to display the path of the excel file in the header, but it changed "&D" into a date. How do I prevent Excel from doing this?

I am trying to toggle between comments in Excel but I have to use the toolbar and I wanted to see if there are any keyboard short cuts that would allow...

When saving Excel files I received from an e-mail, rather than being directed to my "My Documents" folder, they are directed to this strange folder: OLK7. I...

I have a workbook in which there are formulas that pull through from other workbooks. I want to make the workbook so that it doesnt ask me to update...

Hi..I have workbook with 10 worksheets and I would like to extract data from each worksheet to worksheet 11 that shows me everyone who has bought 50 + boxes.....

I have two similar worksheets within the same workbook. One sheet is sorted by name and the other sheet is sorted by a date for a speicfic name. Is there a...

I want to check the value of one column (A) and then depending on the outcome add the value in the same row but column B to a total. Can I do this in a single...

I am trying to import a text file with 50,000 data entries into a worksheet but the importing function seems to allow only extraction to a single row which...

Hi! I have an Exel spreadsheet where the charts work dynamicaly. Every time data is entered into successive cells the chart will fully expand to...

When I am working with a spreadsheet in Excel using MS Office Professional Upgrade 2003, every time I have to format a cell or font the program delays for more...

I use conditional formatting in some of my spreadsheets and I noticed that if the conditions are not in the right order, it doesnt work as well as I...

Hello How to make a version of a table by changing source data in another workbook and retain original version of the table easily? I lose the original...

I have a simple address book spreadsheet. I would like to create a Search form, where the user can enter the Last Name of the person they are searching for.

Hi I am trying to write a function to return an address but instead I get #VALUE!. Public Function fnd(a, b) fnd = Range(a).Find(b).Address End Function

I have used conditional formatting on some spreadsheets, so I know how to use it. My problem is that on other spreadsheets I cannot choose it from the Format...

=IF(A1="yes",RAND(),"") -- HTH RP (remove nothere from the email address if mailing direct)

I have three columns of data, column A, B & C. I want to write an IF statement that looks at column A, and if it either retruns the contents of column B...

Hi I have a problem with external data. In the Data Range Properties, under Data Layout. There are 3 options after 'If the number of rows in the data range...

I have a database of 12 different numbers, contained in the same column, on 12 successive rows. Does anyome know if Excel is able to check whether a number...

Hello, Below you can find an example of my worksheet (A1:A9): DC03210 FE65520 BD92940 CT84170 GT99280 SE38734 FT01484