I have a worksheet that contains many rows of information, sorted by manager name. Is there a way to quickly split the worksheet into multiple worksheets...

I am trying to enter numerical data into Excel2002. It worked just fine this morning, but now if I try to enter a number into a cell, the workbook jumps to...

In 2003, there was a nice feature that allowed you to go to Tools, then Customize and click Command. Then you could select the Tools category and locate the...

I have a spreadsheet that has a column containing results from a formula. In these columns, about half of the cells are blanks, resulting from the formula. I...

I have data which is 3 columns Emp no Hours Amount When I create a pivot table I get the output below emp no Data Total 536 Sum of hours...

I have an Excel workbook with a number of sheets within it - the first sheet is a summary of the data contained in the subsequent sheets and contains...

I have a pivot table based on an external source. There are 2 column items, one called Types and the other is Data, which shows policy count and value. The...

Hello I have an add-in in Excel that pulls in data from an accounts program called Exchequer. When you call the function, you are prompted for an OLE login...

Hi, I facing a problem with one of my computer. When I type M&E (Caps Letter) and press "enter or tab", it will show parmanert in the cell. Pls help. --...

Millä saadaan aikaan kaarisulut { } kaavoihin ja mitä ne tarkoittavat. T Juha

Hi, I'm trying to work out if this is possible to do in one cell. I have a spreadsheet with time based data. Column A has the time values in 15min intervals,...

Is there any way round this message? I have tried switching off error notification and automatic calculation, but to no effect. Sheet has a large number of...

When is it more appropriate to "center across" selection rather than "merge" cells? What are the advantages/disadvantages to these two types of...

I use "Center across selection" and almost never "Merge cells", which is generally a bad choice (across columns anyway). I wish to add an icon or otherwsie...

i have two columns, one is sales price and one is asking price. i need to highlight all the sales prices that are greater than there corresponding asking...

I am not able to create a pivot table - error message is appearing saying that pivot table field name is not valid. it also, says, to create a pivot table,...

Excel 2007 Pivot Table - The "Number Format" option does not appear in the field settings for one of my columns that is formatted in the data table as a...

I have the following formula in place in a spreadsheet and have for the last 6 months. I just noticed a problem. This formula is counting occurrences that...

Worksheet automatically zooms when cell is selected.