Is there a formula that can tell me whether a cell's value is a keyed value (probably a number, if that helps) or if it was determined via a formula. What...

I have a spreadsheet with a list of 40,000 account numbers. I can only handle them in batches of 1000-3000 so I select cell 4000 and hold the mouse as I...

I have a dialog box that pops up when I click in a cell, but it is not a comment. How do I change or clear this? Thanks in advance for your help!

I have a large excel file with many tabs. I would like to be able to save each tab to their own file with a simple process -- in as few steps as possbile. ...

Is there a hot key function for Auto Format Width?

We have a workbook with multiple worksheets. Many users view and add data. Now when we open the workbook, there are two excel files attached. First file...

How do I adjust Excel cell margins in Office 2007? I thought it would be under format cells, but there only margin settings I can find are for the entire...

i am able to create a list "drop down" through data validation. my problem is my choices are sentences, and i can only use so many characters in the list. i...

When I import from my text file into an already developed spreadsheet - instead of placing the text into the cell that I have designated - Excel inserts a...

I need help creating a macro. I dont not know to write codes, I just record a macro, doing the steps. See eg. below. I have been able to copy the vendor...

How do I set my pivot table so that it does not display any sums of values that are equal to zero? Thanks, Barb Reinhardt

Is there a quick and simple way of deleting multiple different blank rows from a sheet? - Other than indivdually clicking on them (with ctrl) and then...

I have a workbook creater with Excel 2000 just a few days ago but there's no way to open it. Coud anyone give me any suggestion?

My department is responsible for data analysis and create numerous reports daily. We would like to have a legal statement on the bottom of all our...

How would you add weekdays to a formula? ex. A1 = 1/1/10 If I want to add 80 WORKDAYS (excluding weekends), what formular would I use? =(A1+80) does't...

Dear experts, I have a small doubt could you clarify that??? That is I find duplicate name but I want to delete one name only, if I filter DUPLICATE….. both...

I have an excel file and formulae in two of the columns is changing to "#VALUE!", whenver a new file is opened and cells updated with data in the new file....

I have a table where I want a value based on looking at data in two columns as follows; Table: A B C 1 Bore Pressure Length 2 ...

I'm finding that the text within several of my spreadsheets (though they were all based on one original master spreadsheet), sometimes shows as grey when the...

Want to auto fill as follows: 3, 3.1, 3.2, 3.3, 3.4 What method works? Can only seem to get sequence on primary number, example: 3.1, 4.1, 5.1 I want the...