General

How to set the default format on excel?
Does anyone have any suggestions on how to set the default format on excel 2003? such as font, size, center align, whenever I open, it is all set. Thanks in advance for any suggestions Eric ... 4 Jun 2010 19:13

Excel inserting slow
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, for example, and click "insert" and than "picture" it first freezes 3-4 seconds. I can than browse my network with normal speed, but when I than again ins... 4 Jun 2010 02:43

Average time
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' (#DIV/0!) How do I fix this? ... 4 Jun 2010 01:38

Office Password Unlocker
The option may differ for different office programs, but I know it's there for word and excel 2007. You can also click the Office button and click Prepare and click Restrict Access. Or, you can using Office Password Unlocker tools. Sang-Wook Chu wrote: excel password 22-Aug-09 I forgot the password for... 3 Jun 2010 23:26

Coloring cells
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 numbers. Is this possible in either Excel 2007 or Excel 2003? Do I need a macro? OldEd ... 4 Jun 2010 01:38

Increment Value By 1 Each Time Spreadsheet is Opened
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 #'s each time a requisition form is completed. Is there a way to accomplish this in Excel? Thanks for your assistance. ... 3 Jun 2010 20:10

Copy and insert multipel rows after each row of data
I need to copy a row and insert it 19 times in the rows below it, for 100+ rows. ... 4 Jun 2010 01:38

Convert to hrs:min
hello Is there any way to convert the following numbers to show as hrs:min without manually insterting a colon? e.g.15:45 18:40 1545 1840 2015 2300 2045 2105 1700 1815 1825 1840 1850 2000 1835 1900 ... 4 Jun 2010 20:18

Filtering data based on historical values
Hello everyone, I am trying to sort a list of temperatures to analyze a chillers operation. The chiller turns on when the outside air temperature is 80, and turns off when the outside air temperature is 70. I am trying to find the time when the chiller is on (temperature was above 80 and didn't drop below 70) an... 4 Jun 2010 04:52

divide a string words separated by (number)
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 number in parenthesis . Thank you A (1.) White Dog (2.) Black Cat A B White Dog Black Cat ... 3 Jun 2010 21:16