My Excel file has 950 rows of data. Somehow, I now have over 58,000 rows of empty cells; the file size has grown from 500kb to 2100 kb. How do I delete the...

When trying to sign a macro project (with a valid certificate), I receive the following error message: "There was a problem with the digital certificate. ...

How do I launch Excel 2002 without a Blank Workbook

A person has a data base program of some kind that tracks students in a school. I have asked her to save the file in a CSV format and send it to me so that I...

Hi, No matter what file I try and open, Excel launches and opens the same .xls file on the computer. This occurs when trying to open an .xls or .xlt...

I have a list of names like so: Last Name First Name Middle Jones Kim A Jones Kim Jones Kim D I am...

Side note: Use a news reader like OE or Agent or one of the others and point it to msnews.microsoft.com CDO interface is not the greatest. Gord Dibben Excel...

What is the formula that is required to return a count of numbers in a given range while ignoring duplicate numbers? For example, a column contains the...

I have a spreadsheet and have setup and checked all of the print areas for each tab within it. I host a link to the spreadsheet from an intranet site and have...

One computer in our network has a problem. It has 3 printers intalled but Excel do not shows them to user in print dialog. Default printer works, but its...

Is there anyway to delete all macros in a file at one time, instead of picking one and hitting delete and then having to go back in for everyone. Thanks

I used the Insert, Name, Define, OK function in EXCEL to create a tab order, which works great. However, after protecting the sheet, the tab order doesn't...

I have the need to create a formula dealing with the positive or negative change in cells: Example: cell 1: 2.7 cell 2: 2.1 cell 3: 4.2 cell 4: shold equal...

I have a spreadsheet showing the purchases of various part numbers with the corresponding unit costs paid, there is normally more than one unit cost per part...

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

Hello, I am currently doing a project at work which requires me to take two Inventory Activity Reports and merge them into one so my manager can use them to...

My work for the day involves calling our suppliers and getting them to send us their price lists. I then take these price lists and format them in a certain...

I am creating a spreadsheet to log tapes. Column A is the Name of the tape. Column B is the names of the spots on each tape. Each tape could have up to 10...

I am looking for the following formula: eliminating blank cells from a list containing both data and blanks. Thanks.

Hi, I have a cell in Text format with "wrap text" enabled, And I copy from notepad multiple lines of text. The cell turns to show "################", Can...