General

to copy pivot table as new sheet with same format
How I can copy a pivot table to another worksheet without missing its format. But in the new worksheet should behave as normal sheet can possible to insert a new column , delete a column . Please kindly request ur advice Pol ... 5 May 2010 16:03

Hiding VB Code
I am using Windows XP and Excel 2002. I have written a small code in THIS WORKBOOK. I want to know if there is a way to protect anyone else from going into VB editor and seeing the code? I'd like to make it not visible except to me or by password just for the code. Thanks in advance. ... 5 May 2010 13:48

Data Validation
Hi, I need to prevent data from being entered into a cell if there is already data in any cell left or right of it in the same row. Thanks Gotroots ... 5 May 2010 13:48

Pivot Table With Text Values
Hi, Is there any way that I can use Pivot Table or any other similar function so that I can get text not numbers in the ∑ Values field? Sure my intention is not to sum up text! -- tarig ... 5 May 2010 12:40

How do I show all words in a cell?
I am trying to help my daughter do a crossword puzzel project for school. At the bottom of the puzzel, we were trying to put the clues. How do we show all the text in a cell without expanding the cell ot wrapping the text? ... 6 May 2010 13:05

Formula To Split Name
I have a list of names in colum B, that I would like to split into column C and D. The names in column B have a first name, middle intial and a last name. I would like the last name to go into column c and the first name and middle initial to go into column D. Column B Column C ... 5 May 2010 21:37

Use Find and Replace in Excel
I have the following in cells after using a formula. #INVALID_DATA. The reason is there is no data in the cell. If i use the Find and Replace to remove the unwanted data in the cells I first use the find all command. I change the Formulas to Values. I can see the unwanted data at the bottom. I then use the Repl... 5 May 2010 12:40

Change scroll rows from 1 to 3 with mouse wheel
Does anyone know how to set the mouse scroll amount from 3 rows to 1 row in Excel 2007? There used to be an option in 2003, but I can't find one in 2007. ... 5 May 2010 12:40

remove bullet from sheet in Excel, imported from Powerpoint
Hi guys, would appriciate your help with the following. I have an Excel sheet where I copy information from Powerpoint presentations. When there is a bullet in the powerpoint which I copy it is impossible to remove it from the excel sheet. The bullet is not located in a particular field but 'floates' (so to spe... 5 May 2010 12:40

Sumproduct Dynamic Range - XL2003
I have a sumproduct formula(s) that is calculating very slowly in my workbook. =SUMPRODUCT(((Data!$D$2:$D$10000=$E22)*(Data!$A$2:$A$10000='H-Code SS Report'!F$21)*(Data!$K$2:$K$10000))) I'd like to insert a dynamic range to improve performance, but haven't had any luck. Any suggestions would be greatly a... 6 May 2010 04:12