Hello, I ahve a list of names, with middle initials, that I need to break up. For example the names are formatted like the following: Bayer, Daniel E. I...

Hi, Can you please help me identify why this macro is failing with the following error? Runtime error 1004: Sort method of Range class failed Row 7 is the...

Is there a way to change the names of worksheets automatically? I use Excel 2007 for invoicing, but it's really a pain to have to rename each sheet to...

I received an Excel file, and for an unknown reason, the text in just one of the cells displays as all # symbols, even though I can see actual text in the...

I can't get my spreadsheet to automatically change the row height when using text wrapping IF I'm working with several merged cells in adjacent columns. It...

How do i copy data from one sheet to another, to include the footer and header. I created a log for work. I need 20 of them to be able to fit everyones name...

Hi all, Ik column K there will be a continuous range of which all cells have a certain fontcolor, the font color code is, say, 5. The range can be 1 cell up...

I am creating a purchase requisition form in Excel and when users open the spreadsheet I want the requisition # incremented by 1 so we have unique requisition...

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...

How can I remove columns that contain all zeros? Is there a macro? I craeted a sumif formula to flag columns subtotaling zero but I need a method to remove...

I would like to have the data that is in one cell parsed into two cells like in the example below. The data is always separated by a consecutive whole...

I forgot the password for my excel file. I have tried some programs such as Accent Excel password recovery, advance office password recovery. Neither did...

I'm running Vista Home Premium SP2, 2 GB RAM, Firefox, Spyware Doctor, MBAM, SAS and CCleaner, Office 2007. All of a sudden only one (of many) worksheets...

I have a column of numbers. Some are positive and others are negative. I would like to color "red" the cell with negative numbers and 'green' the positive...

I need to copy a row and insert it 19 times in the rows below it, for 100+ rows.

I have a list of mm:ss times in a column. I want to find the average of the list. I have tried different things, but I keep getting 'Divide by zero error'...

I have a cell with a full sentence in it. The cell is too small for that sentence so of course it carries over the cells to the right of it to display the...

A few days a go I read, in one of the previous pages, that the the DG are about to be shut down and we moving to the new Excel Forums. Was that a false alert...

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,...