Excel has a way via its internal file-open mechanism any worksheet as read only. This is great if you want to prevent damage to a sheet (yours or god forbid...

have a worksheet made from imported data - all cells have ' in them (doesn't show) - need to delete this where the cell is (otherwise) empty - tried find &...

Does anyone know of a formula which will give the minimum value of a range (ex. A1:A200) excluding the zeros (0).

Ok, Instead of raw data I have a frequency table, and I want to do a statistical analysis. For example 100 students take a test with 10 questions and their...

Just got a new computer with Windows XP Home Edition. The old computer was Windows 98. Whenever I try and open any of my Excel 97 spreadsheets, I get error...

Hi Ruffy, SYMPTOMS When you attempt to save a workbook, you may receive the following error message: Document Not Saved CAUSE This problem may occur when...

hi what formula should i use if i want to work out the date of say the 15/6/04 plus 5 months from now?? thanks :) --- Message posted from...

Good Morning, I'm trying (and failing miserably) to insert a graphic into a header in Excel. I've tried inserting it into the main body of the spreadsheet and...

I have a number of workbooks driven by links with a central workbook. Some of these workbooks are monthly monitoring statements that once the month end has...

I receive data each day exported into an excel file. In column A there is a list of Areas, in column B a list of months from April to whatever the month we are...

Hi Under a range of data, I have cells with formulas or calculated totals based on all of the data in that range. When trying to filter on this data, I wish...

Hello, I hope I am posting to the correct group. I have received a spreadsheet from someone that has subtotals in it (Data, Subtotals), but instead of the...

I get the warning message Fixed Objects will move in an Office 2000 Excel spreadsheet. This occurs when filtering. To proceed with the filter operation I have...

i know you can password documents, protect cells, and worksheets. But what i want to know is if you can password certain tabs in the workbook ? So only users...

Using Microsoft query I manually edit the SQL to the following. select gl30000.ormstrid as customer, sum(gl30000.crdtamnt) as credt, sum(gl30000.debitamt) as...

I opened a 97 spreadsheet in 2003 and now each time a user form is initialized a runtime error comes up in the following line in the...

I'm really struggling here. I've inherited a very complicated data sheet that can not be split up in to different worksheets. I have lots of supplier spend...

Hello all. Is there a way of defaulting the floating formula bar that pops up when you select a formula to appear somewhere other than the top left corner, I...

I have a list of lotto winning numbers in excel such as: row column a 1 11-12-13-14-15-16-17 2 18-19-20-25-29-30-34 3 ...

Hi there; I am a newbie to excel would be great if u could help me, Ok; I have to sketch the graph of "Log(f) against Phase Shift" underneath "A" I have put...