General

Excel Data Compression
Hi I thought in 2003 there was a way to repair/compress your data in an excel file. Does that same capability exist in 2007? Thanks. ... 23 Mar 2010 18:22

Value or Formula
How can I enter a value in a cell that contains a formula but without deleting the formua? ... 23 Mar 2010 19:31

Excel
How can I enter a value in a cell that contains a formula but without erasing the formula? ... 23 Mar 2010 18:22

Remove selected data from a list
i have a list of sequential numbers eg 1 to 100. I have a second list of numbers eg 5,6,23,38,90 I want to remove the numbers in the second list from the first list. Leaving me a list of numbers 1 to 100 minus the 5 numbers in the second list. ... 25 Mar 2010 08:00

CSV error when trying to save
I'm using Windows Vista X86 and Word 2007 and I'm trying to save a workbook in the CSV file format. Everytime I save, it gives an error saying the file name.csv may contain features that are not compatible with CSV (Comma delimited). I was wondering if I would lose data or if data would be corrupted because of ... 23 Mar 2010 19:31

Excel 2007 Recent Documents List
Hi, I know that the new upper limit is now 50 (GREAT!), but when I go to the Office Button, 50 entries can not be displayed. How can I hold 50 Recent Documents AND have the displayed. THANKS! Gene:) ... 24 Mar 2010 15:52

Sort / Filter in excel
I have a row of data that has strings of numbers / characters. Is there a way to sort of the charaters whether they are at the beginning or end? Example: P224 24P 26A 28376A A20958 I would like to sort by the Charater - when it either at the begining of the string or end. Thanks, Kelly ... 23 Mar 2010 17:12

Tracking Sheet
I have a tracking sheet that is set up in excel07 and used to track an entire project for capital equipment builds. The spreadsheet has columns A thru BA and the number of rows are dependent on the number of parts within that project. However, the headings are universal. My issue is that there are crossfunction... 24 Mar 2010 02:15

subtotal groupings not appearing to the left of the row numbers?
... 23 Mar 2010 16:00

Summarize a range referenced in a separate worksheet
What is the best way to add a sum in Worksheet #2 for a range of data in Worksheet #1. Example. Worksheet #1 Date Week # $$ 1/1/10 1 10.00 1/2/10 1 10.00 1/3/10 1 10.00 Worksheet #2 Week $$ Total 1 30.00 (looking for a formul... 23 Mar 2010 17:12