General

Text Columns Function
The data I am bringing in to Excel comes in two rows for a single record. I need to reformat it so that all of the data is on one line. As there are several thousand records, I need to do find a way to automate this. Any suggestions? -- KKD ... 1 Apr 2010 13:32

Pulling Data
I have a large range of data that I would like to pull information from based on several factors. There may be more then one outcome. Is there anyway to pull that information and put it in a table on a different worksheet? ... 1 Apr 2010 15:47

Re-open worksheet saved as PDF?
Any recommendations of a good program to convert PDFs to Excel 2007? "Bob I" wrote: No but you can get software that will convert PDF to Excel. Gary''s Student wrote: Is there any way to get Excel to re-open a file saved as PDF?? ... 1 Apr 2010 12:24

Expand Conditional Formatting to all Rows
I cannot get my conditional formatting rule to apply to my entire data set. My data are set in rows. I want the entire row to format (color fill) when two specific cells within that row equal each other. I can get the single row to work properly, but I can't see how to expand this formula down to each row on my... 1 Apr 2010 13:32

How to change order of drop lines relative to the plotted data in Excel 2007 chart
What is the procedure for changing the order of drop lines relative to the plotted data in an Excel 2007 chart? I would like the chart;s drop lines to remain active, but appear "sent to the back" behind the plotted data. I attempted to help myself by searching extensively, but I was unable to find the solution... 1 Apr 2010 11:16

Excel 2003: Keeps applying auto-font settings I don't want
Hi This has finally started to seriously annoy me. I'm using Excel 2003 SP3. I have a pretty large list of information. A few rows above the first blank row, I have the whole row formatted Bold+Italic. When I enter anything into a blank row below - even though the cell format is set to normal font - as s... 1 Apr 2010 11:16

Spreadsheet (version 1).xls: file format is not valid
My question was not posted from Tuesday, March 30, 2010, so I am asking again. Windows 7, excel 2007, while spreadsheet open, not necessarily in the middle of editing, arbitrarily goes to recovering the spreadsheet, then document recovery comes up on the left and the message as in the subject line appears. A ... 1 Apr 2010 11:16

Protecting Xcel worksheets
Hi All, I want to protect and hide formulas for a whole array of cells in spreadsheet ... Is there a way of doing this but retaining the ability to apply the Autofilter (under 'Data' menu option)? Many thax, Don- ... 1 Apr 2010 11:16

Open TIF or MDI files in Excel
On your excel sheet, "Hyperlink" to the file that you scanned. Then when you click on the Hyperlink your document will open. "Bernard Liengme" wrote: Why did you OCR to a graphics format? Normally one OCRs to something like Word, WordPad, Notebook These can be copied or imported into Excel best wishe... 1 Apr 2010 10:10

macro for inserting one row between different data
Hi, I am using excel 2003, my file looks like below order no invoice no amount 123 S1000 $10 234 S1000 $20 456 S1001 $30 123 S1001 $40 I want to use a macro to insert a blank row to separate different invoice no, how to... 1 Apr 2010 22:28