General

Cursor location jumps automatically
What makes the cursor automatically jump from one cell to another in Excel when trying to change/enter either new/different alphabetical or numerical data? The data entered can't be seen on the screen in the first or last cell. I don't recall changing anything in the file (other than saving it) the last time ... 9 May 2010 03:34

Copy and paste to the last row
Dear ALL, pls help me for macro. I want copy the last row of column A, B and C. and Paste the row down. Example, my last row of A is A120, copy cell A120:C120. then Past to A121 Thanks so much ... 7 May 2010 21:10

How do I enter mins and secs in Excel without using caps/colon
Using Excell, I need to fill columns with minutes and seconds (ie 10:22). Having to use caps and colon to insert the colon between the minute and seconds is time consuming, is there any way round this anybody please? ... 6 May 2010 19:52

Conditional Formatting - Test Practice
I want to design a test for my students, who need to memorize -- verbatim -- a list of 37 characteristics. I would like to use an Excel 2007 spreadsheet to allow them to practice. Ideally, the practice spreadsheet would possess the following characteristics, based upon text-based input: - keyboarding the phrase ... 6 May 2010 18:45

SUMPRODUCT
Hello, I've used this formular to find work piece that gets done per department. =SUMPRODUCT(('Q2'!E13:E150="Done")*('Q2'!G13:G150="14532")) Department 14532 was not picked up even though other department's number was correctly counted. But if I put a letter, say like C (14532C) and adds C to my formular as ... 8 May 2010 09:01

Sumproduct Approach
Your formula contains some overlapping ranges I don't think were intended. Please consider the following: Client 2 Product 2 Client Product Amount Client 1 Product 1 1 Client 2 Product 2 2 Client 3 Product 3 3 Client 4 Product 4 4 Client 5 Product 5 5 Client 6 Product 6 6 Client 7 Product... 6 May 2010 17:38

Linking sumif formula to the data
Is there a way to link a sumif formula to the data on a different worksheet that makes up the sum of the formula. If I click on the cell that contains the sum, the data that makes up that sum will show up on a different worksheet. Don't know if possible. Thanks. ... 6 May 2010 19:52

Preview Excel 2007 files in Outlook from SharePoint
I'm not sure if this is the best place to post this, but it's a start. I have a SharePoint document library interfaced to Outlook and I've been able to preview Excel 2003 workbooks within outlook. We've converted the files that are saved in the library to .xlsm files and they can't currently be previewed. I... 6 May 2010 16:32

Formating Dates
I need to update a list of dates to show all days as 01. For example, where date shows 03/28/2009, I need it to read 03/01/2009. I appreciate any guidance! -- LL28 ... 6 May 2010 17:38

Change authentication in 2007?
How would one change a file from administrator (currently the default) to Windows authentication? Ideally, I would like to make Windows the default authentication, but one at a time is also an option. Let me know if you need more info, as I'm asking for my more experienced super. Thanks!! -- GD ... 6 May 2010 19:52