General

Columns distributed evenly in worksheet
I have a table I need to add to an Excel document. The data above it and below it are different cell widths. I need to be able to insert the table with evenly distributed columns. Inserting something like a continous page break (like in word) would work but I can't seem to find anything like that in Excel. I ... 2 Jul 2008 17:03

How do I do this??!
I have a table where users need to assign a score to an item... so for example: Item 1 |criteria for the item to receive 5 points blah blah |_________| |criteria for the item to receive 4 points blah blah |_________| |criteria for the item to receive 3 points blah blah |_________| |criteria for the item to re... 2 Jul 2008 14:59

Excel2007 limiting Pre-2007 Worksheet protection passwords to
Thanks for the quick response Ed. My Excel2007 about info shows SP1 has been installed, the update option said my version was up-to-date, and the diagnose & repair did not find any issues. Thanks for the reminder about the password crackers. At some point, I would like to learn what types of excel passwords are v... 2 Jul 2008 13:57

counting the number of two different variables
I have a speadsheet with several tabs that I need to count two variables on different pages. Simply, there is one (1) summary page and one (1) page I want to point the formula at. The page I need to count has 2 columns, one contains years (2004, 2005...etc) and another column contains 2 phrases (early term and ... 2 Jul 2008 14:59

Excel Worksheet Data Lost
I created a phone call log using Excel 2007. Worksheets were created for each entity with whom I make regular phone contact. Columns include dates, times, notes, etc., with rows representing each call entry. When entered, data is manually saved often. I openend my log today and noticed a 2 week time gap of lost... 2 Jul 2008 20:08

Sort a text column that contains alphanumeric
I want to sort the following which is all formatted as text: REA240 REA250 CAP010 TIP031 CUP001 When I hit sort, it converts everything to numbers, although it is still formatted as text, so I end up with the column looking like: 221001 221041 221051 How do I prevent it from chaning my fields? ... 2 Jul 2008 20:08

Work Days
Column A = Date of Service Column B = Date of Approval Ok, my question has two parts. First, how can I identify the day that is 6 months into the future from the "Date of Approval". Then, how can I identify the next business day from this date. The second part of my question is how can I create a formula th... 2 Jul 2008 14:59

In adding a single column, it's always out 1 cent, why?
Help! Only certain times I get an addition out by 1 cent. When I check the column with a calculator, my numbers are right, but the Excel answer is out. Why? ... 2 Jul 2008 13:57

Using a lookup function to output a cell address
I want to be able to search for a text string in a column, and have a function output the cell address. Basically I want to link to a cell that is offset from a certain text string, however I don't know wheere this cell will be located. Any ideas? Thanks Adam Bush ... 2 Jul 2008 17:03

Sum Button Doing wrong Function
Somehow, my Sum botton, in the toolbar, is doing a subtotal function instead of a simple Sum. how can I change this back to the original function? ... 2 Jul 2008 20:08