General

Find Duplicate names and delete problem
Typed in "Name1" into C2 "Name2" into C3 "Name3" into C4 Selected these three names and copied them down through cell C26 Using Data-filter-Advance filter Action - copy to List range C2:C26 Clicked the Unique records only and selected E2 Clicked okay Results was Name1 Name2 Name3 Name1 Any idea ... 12 Mar 2010 13:56

Text colour keeps changing to grey
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 spreadsheet is opened. I'm able to get it to go back to normal by going to Tools-Options-Color-Reset, but is there any way of stopping it from doing it ... 12 Mar 2010 08:19

Trailing Spaces in Merged Cells
Hi, I have a large spreadsheet with data in merged cells. When I look in Excel, the trailing spaces doesn't appear and when I copied the data onto Notepad, the spaces are shown. I have tried TRIM (works for single cells not merged cells). Any help would be greatly appreciated. ... 12 Mar 2010 22:54

Insert Comment
Hi Using Excel 2003. For some unknown reasons, the sheet in my excel file don't allow me to insert comment (ie. the Insert Comment is greyed out) How to solve it? Thanks ... 12 Mar 2010 02:52

Locked for Editing
There is an excel workbook that is locked for editing and it has at this state for over a week. I need to be able to forcibly delete this file, renaming as a different file name is not an option. Is there anyway that I can forcibly delete this file? ... 11 Mar 2010 23:35

Pivot Table help
I previously asked about consolidating rows of data that I was looking at and got the following response that worked great: I took your Source data and did the following... Created a pivot Table from the data (I think you are good to here) Placed the Duty Location in the Left Column (not top row) Placed the S... 11 Mar 2010 19:08

Consolidating and totaling rows into single row
Sorry for resetting such an old thread. I've added two additional fields of data to this data set: Status Code and Reason Code. I have the data for these fields only for FY09, none for FY10. When I ran my pivot table as Jim explained below I got position titles appearing in FY09 and FY10 along with the same ... 11 Mar 2010 19:08

Prompt if data is not entered after so many times
Is it possible to highlight a cell if that data has not been entered after so many times? For instance, if I have a column where I have entries of A,B,C, & D and say B hasn't been entered for 7 times since the last entry of B, is there a way to highlight that last B then? Hopefully my question is clear enough... 11 Mar 2010 21:22

deleting temporary excel files
My computer crashes when exiting excel on all files. I remember that you can delete temporary excel files and cannot remember how to locate them and delete. Will this fix my problem Dave ... 11 Mar 2010 18:01

Looking up your previous questions
I am really in need of looking up a past question I asked here, but cannot find it through the search function. Is there a way to retrieve the messages that you've posted here? Thanks in advance! ... 12 Mar 2010 02:52