Hi, I'm going through a large data base and need to invert the data so the reverse route is shown. A B A B e.g. 1 2 ...

In a workbook, a number of worksheets have been hidden. Periodically it is necessary to ‘unhide’ and display all these worksheets. Is it possible to do...

I have a workbook that I need a summary page that will breakout 2 different tabs and subtotal it Is there a way that if 1 tab holds Part #, Desc, and...

How do I calculate what percentage of a year has elapsed? I have the date 31/12/09 in cell A1 and the date 31/05/09 in cell B1 and then I do this: =B1/A1*100...

I recently got Excel 2007 @ work. When I type =D12/2 in the cell I expect to see the answer (whatever D12 is divided by 2). What I get is =D12/2. That...

Hi, I am new to this form of help! Sounds good! I am trying to print a spreadsheet and after I set the print area and save, My printout only prints the...

I am new to Excel 2007 and I want to put the basic mathematical symbols ie + - * / on the tool bar but can't find them!

Hi all, Greeting for the day. I have serial number in a column like 0123456789 that is 10 digits however it has to 990123456789 The actual requirement is...

Hi. I copied and pasted to an Excel worksheet, photos and text from a web-site. How do I eliminate the feature that allows me to click on photo or word and...

Hello I read that using PMT you calculate your instalment/EMI on particular amount of Loan. GoalSeek on the other hand finds out the max loan you can get if...

Hello Using =PMT formula, I input B1=pmt(14.5%/12,60,A1) and in GoalSeek, I set cell B1 to 5000 by changing cell A1 and I get 212,510.21 as the result...

Hello, I want to enter text into a cell, with the text chosen from a limited number of options (probably listed in a separate sheet). I suspect I need a...

How do I turn off autocorrect for dates in a cells. I type in a date such as 2006 and it changes to 2009?

Hi Don, As promised latest test figures by area these include David's latest tests. -- Steve

I have read other advice in several similar answers, but nothing works, so far. "Tools, options, general, ignore other apps" does not work; "Tools, options,...

I am trying to use the print screen key and paste it to excel, and I got an error message"Microsoft Office Excel can't paste the data"

I have a fomula in a cell that takes the name of a person (from cell 2B), their License number (from another cell 2C)and the Date that License Expires (From...