We have an excel spreadsheet that is updated by changing select text to red and highlighting in a text cell. So there are only certain strings where the...

I have a spreadsheet that contains columns with text (such as name, job title, hire date, etc.) and several columns with amounts. I want to delete the...

In column B I have 1000 time entries with the following format. 9:30AM, 10:30PM. I would like to move the AM or Pm into a new column. I've tried "fixed...

In ColumnG I have the following formula array from row2 all the way down to row100 =IF(ROW(FilteredMonday)-ROW(E2)+1COUNT(F2:F100),"",...

How can I apply a format permanently in a Pivot Chart? For example, adding values to my data graphs and not losing this format upon changing a field to...

The text in some of my cells is turning blue for no apparent reason. The cells can't be changed back to black by reformatting or changing the cell type. It...

Frank, Thanks for replying... we use a report generating tool (access)that gets talks to the database - but the custom reports don't have all...

I have set macros to be automatically disabled with a notification but the message bar doesn't always come up. Does anyone know why this may happen and how I...

I have cells that say if value is equal a certain points will be given if a tie 2 points are given by comparing the score in 2 cells. the problem the games...

I am wanting to lock cell A1 from being able to be populated if both B1 & C1 are both empty. Is this possible?

On a complete new windows 7 64 bit pc with office 2007, it is running extremly slow when opening documents or inserting normal pictures. When I go to excel,...

When saving file, Xcel generates .tmp file xls.~RFe17931.TMP in same folder with the .xls file. Can manually delete, but if I open the file and save again,...

Hi... I was wondering how I can keep my find box open while I am entering and editing data in my spreadsheet. It is very frustrating to have to continually...

State : Type1 : Type2 : Type3 : Alaska Arizona Type1 Alaska1 Type1 Arizona1 Type2 Alaska2 Type2 Arizona2 Type3 Alaska3 Type3 Arizona3

I have cerated a macro button in a spreadsheet, and I would like to know if it is possible to save that button onto a toollbar so that I can use it on any...

Windows XP Pro SP3 Excel 2007 Suppose cells A1:A10 contain integer values. Now suppose cells B1:B10 also contain integer values. I'd like to conditionally...

I have an excel sheet in wich I paste everyday new information, replacing the previous day information. There's a clipart that has been pasted over and over,...

Only get error message on one machine, running MS Office 2003 on all machines Can only "paste link" within the same sheet, not between sheets of the...

In a sheet named "Confirmed" I have a spreadsheet which contains the following:- Column F (a list of languages) Column G (a list of languages) Column H (a fee...

I have cells that contain data such as: General Motors 22779 United States of America 1449 Carlsbad 712 Under 21 Children 12 I would like to parse the...