Hi Something strange is happening, when I go from one cell to another the screen appears to update, but gets mixed up. The only way I have found to fix it...

I have a 'summary' tab and a 'detailed' tab. Cell C16 on both seem to be linked somehow. When I change C16 on the 'detailed' tab to be the text I need, it...

I am looking to print different orientations on the same excel sheet does anyone know if this is possible or do they all have to be the same?

I would like to use rich text boxes in my forms. I read that you can use this un-allowed tools in forms if you make a change to the browser. Does someone out...

Hi! I have area numbers in column A and the number of produkts ordered in column B I want to count the number of entries in a particular area bearing in mind...

I inserted a combo box form control in a cell and found problems with changing the value. Another cell on the worksheet contains a formula using the value in...

I hope that it will be very helpful if Microsoft add an option button in Paste Special Dialog box for pasting the formulas in any of the cell with the...

When you use Advanced Filter to copy the outcome to another location, Excel would only let you copy to the same (active) worksheet. Is there a way to get...

If I have multiple ranges or tables on one worksheet, can I create a Pivot Table based off of more than one range or table? For example, if a worksheet has...

I am trying to sort via auto filter. In column A, I have a part description, in column B I have a COUNTIFS function which counts the instances of Column A...

Suddenly my headings are numbers instead of letters. I want to use letters.

I have a worksheet that I need to split data in one cell into another. Text to columns not working because there is no common denominator. An example: Group...

On Worksheet "Record Sheet" cell C5 I need a formula which will do a VLookup on a variable number of sheets (all of which have a name that begins with "Round...

Which function would I use to link data entered in to cells to the corresponding value in the chart. A B C D 1 1 ...

I have a conditional format in xl2007 that works (fill 9 adjacent cells), but only if I leave the page and return. This CF is dependent on the value in...

I want to insert math symbols as text but they keep turning into equations.

Hi, I have a formula =COUNTIF('Details 2007'!A:A,"October 11, 2007") and i would like to fill the cell below ii with =COUNTIF('Details 2007'!A:A,"October 18,...

Hi, I want to use 2 different spreadsheets - 1 which displays information for all staff and 1 which displays information for management only. How can I make...

I have a spreadsheet that has the following: Column 1 = Person's name Column 2 = Amount due I need cells to change colour if the amount due is not paid by the...

I need some help. I am trying to build a simple vacation tracker for the office. I have built a small calender with each cell as one day in the year. For...