General

Variable Length Columns
I am trying to set up a template with formulas into which I can simply drop data into and Excel will then run the calculations. However, the data I will be entering will have many different lengths. How can I make formulas and equations to handle the variable lengths of my data? For example, how do I sum the ... 29 Apr 2010 14:41

How do I create a drop box in Excel to show a calendar?
I'm trying to create a drop box within a cell in Excel so that when the user click on the drop box, it shows a calendar and that the calendar will default to today's date. ... 29 Apr 2010 15:49

Div / 0
Hello all How can I get this formula to not return Div/0. N32=N34-Sum((P39/E52)+(P41/C32)+(P43/16.9)+N30)+P45/16.9 It works ok so long as one of either P39, P41, P43, P45 has a value greater than 0. If all are "0" then it returns Div/0. if all are "0" the I need N32 to = N34-N30 I hope you can follow this so ... 29 Apr 2010 20:22

unlock frozen cells
I opened excell program to add data but it is locked. I can't add nor delete data. None of the functions work. It opens, but is locked. Help ... 30 Apr 2010 10:36

Pivot Table limiting user selection
Hi, I have a pivot table with different region and different Operational Directors' performance. I would like to limit the user to their own data without seeing others' numbers. How would I do that? For example, let say, there are 3 operational directors A, B and C, if person A opens the spreadsheet, is it ... 29 Apr 2010 14:41

Grouping difference between 2003 and 2007
In Excel 2003, when you right clicked a numeric field, and selected group... you would be given a dialog where you could enter the start, end and increment for the PivotTable. In 2007, Group does not present any dialog, and instead complains that it can not group the field. If the entire set of data is select... 29 Apr 2010 13:33

Columns Problem?
I have made use of most all of the columns available thru IV, minus aprox 10 cols. with minus 5 cols, at one time was able to expand 1 column size (to trick xl? column space available so I can: cut / past / insert columns). Error getting: cannot shift objects off sheet. I now have difficulty inserting, etc... 3 May 2010 20:57

auto complete only for one row down?
I am using 2000, and have seen this behavior in more than one spreadsheet which i use for logging in resposes. In all cases my left column is a form num,ber, so there are no completely blank rows. In one column, autocomplete works even though there may be many blank cells above it. In another column farther to... 29 Apr 2010 12:25

Viewing 2 tabs in same workbook
Is there a way to view 2 tabs in a workbook at the same time, so I don't have to keep switching back and forth to grab numbers from one tab to another? ... 29 Apr 2010 18:05

Row 3 data
I have recently notices that when I type data in Row 3, especially cell A3, the cells sometimes appear blank on the screen and I need to look in the formula bar to see the data. This also occurs when I highlight multiple cells. I have attempted to force any updates, but it does not seem to be working. ... 3 May 2010 05:31