General

Custom Number Formats for Excel 2007
Hello I open several Excel spreadsheets daily that include a date/time column. Every spreadsheet that I open I have to change the column formatting to "dddd dd-mmm-yy hh:mm:ss". This is not a format built into Excel 2007, is there a way to permanently add this format to the "Custom" section...or to Excel 200... 13 Apr 2010 18:30

Can a Excel Spreadsheet automaticly open only once a week?
Using the startup folder, I can open a Excel Spreadsheet automaticly everyday when the computer is turned on. Is there a way to just open one day a week, instead of everyday? ... 13 Apr 2010 16:13

sumif function
If there is a specific keyword, like "expense", in column A and I need to return all the values contained in another column, but several of the "expense" cells in column A have other words in the cell with it, is there anyway to search just on "expense" in the column A eventhough some of the cells have other wo... 13 Apr 2010 16:13

No left click
I am unable to us the left click on cells or tabs in any excel workbook. Can anyone help me restore the left click? ... 13 Apr 2010 15:06

Quarterly Formula
Hi! I'm trying to find a formula to extract a total within each quarter without including the year, thus avoiding on a yearly basis updating the year within the formula. The formula at present is : =SUMPRODUCT(--(D2:D1000="Blaaa"),--(A2:A1000="Blaaa"),--(B2:B1000>=DATE(2010,1,1)),--(B2:B1000<=DATE(2010,3,31))... 13 Apr 2010 17:22

xl 2007 how to validate that cell 1 invalid if cell 2 not blank
microsoft office 2007 xl - how do you validate a cell such that you cannot enter a value in cell 1 if a value has been entered in cell 2? ... 13 Apr 2010 15:06

Moving Hyperlinks
Hi, I am hoping I am not asking a dumb question here! I have a workbook that has a number of worksheets that all contain external links. I am running into a problem where if I have to insert data or a new link in a certian place, my hyperlinks don't seem to want to move with the cell contents. Maybe if I pr... 13 Apr 2010 17:22

how can we calculate the numbers of hours between two dates and
i need to calculate the exact number of hours between two different dates and times, e.x. 04/12/10 10:23 AM and 04/15/10 15:18. ... 13 Apr 2010 15:06

How do I strike through a row of datas?
... 13 Apr 2010 15:06

How to do - B2 is only valid if B1 is zero
Microsoft office 2007 XL. How do I perform a validation where cell B2 is only valid if cell B1 is blank or zero. Have read the help text on this including the section on "what is allowed on the context of another cell". As a result I tried many different things but cannot get it right (if it can be done). The d... 13 Apr 2010 13:58