I have a workbook with 4 sheets, 3 sheets just have some organagrams that dont take up much space. the 4th sheet has about 120 small pictures on it, of maybe...

My column and row headers/titles are missing (for example, the ABC at the top of the sheet for a column and the 123 on the left side for rows). Any ideas on...

Lotus has a nice easy function that looks sort of like hexdec or something just as simple. Is there anyway I can get Excel to convert a column of numbers...

Here is my IF...

Does anyone know how to convert snapshot files (.snp) to any sort of file (besides .PDF) that can be manipulated such as Word, Excel, or even Notepad?

does anybody know about the way how to retrieve data into pivot table which is locked as form ? Example: I have the form and I need only to update daily data...

Users are having a problem opening Excel within Access in that it creates a 'psuedo-database' (they are not importing). Access is creating a database with the...

Hello: Could anybody please tell me how to get the last value that has been calculated on a column? IE: Say the column has 100 spaces but only 50 have been...

I have a list of transaction in an excel sheet. It looks like this: Client #, City, Transaction 125 A 125148 125 A 125168 125 ...

Hi, A newbie here (groan). I need a tool to take data in excel tables and generate text documents with the data rearranged in new forms, eg to look somewhat...

I have created a web query in Excel to download "key statistics"for a stock into my spreadsheet. The url and query is ...

Hi, I was wondering does anyone know what can cause the fonts in my excel worksheet to change colors automatically? I originally had my font color to be...

These are my data: ColumnA ColumnB ColumnC Smith William Jones Weston Ashby Albert Aaron Fred Smith ...

Hi, I have about 20 columns in an Excel spreadsheet that contain name, address, etc. in various forms of capitalization. I believe I can use the proper...

Is there a way for me to make a spreadsheet in excel and then distribute it to users who may not have excel and they be allowed to enter data into it? Thanks!

The problem is that the data in ("F1") is variable. When i record a macro, the data that is in ("F1") the first time stays in "criteria1". I need it to change...

I'm using Excel 2000. I use FORMAT/COLUMN/AUTOFIT to adjust the width of the column to fit the cell contents. I then save and close the worksheet. When I...

Can anyone advise on how to export/save an Excel file to a fixed length text file?

Hi I have 1200 lines of text and numbers in the form below Gross Sales 1200 1500 2400 1100 Garden 40 50 65 ...

I would like to put a date in a cell. Then fill it down. How to do that? Like.... Tuesday, July 06, 2004 Wednesday, July 07, 2004