Hey, i have a questionnaire - i'd like check boxes, but instead of the true/false i'd like three options true/false/na. True being a tick, false being...

I have two columns. First column contains dates, second column contains numbers. I want to sum all numbers for a specific month and year (i.e. sum all...

Downloading from SAP to Excel 2003, only dollars were treated as numbers, other fields were Text. Excel 2007, all fields that appear to be numbers are...

Is there a way, such as a key combination of enabling the cursor to navigate a formula or line of data while composing it, before its actually entered, and...

Hi, I have two workbooks open in the same Excel instance, but cannot copy and paste. The paste and paste special option is grayed out in the second...

Any simple way to have the background picture be also printed rather than being only displayed on the screen. -- Thanx & Best Regards, Faraz!

I have this formula: =COUNTIF(A1:A10,"sup") I want the sum of a few other acronyms as well. How can I retrieve the sum of several different acronyms within...

How do I copy a worksheet from an external source into a shared workbook?

Hi there, I have a spreadsheet in which Column A looks like this; 0034-MILTON KEYNES 0034-MILTON KEYNES 0035-MARBLE ARCH 0035-MARBLE ARCH 0039-EAST...

Date1 Date2 date3 1/1/2010 3/31/2010 2/5/2010 if date3 is between data 1 and date2 then true else false How can I enter this? -- deb

I wonder if anyone can help me please I'm trying to set up conditional formatting for a cell based on data in range of cells for example: cell D9 should...

How do I stop the creation of a 'backup' document every time I open a workbook? I have one document that creates a new backup automatically each time I open...

Is there any way to have the results of a formula appear in the formula bar when the cell is protected and hidden, and sheet protected? I have formulae that...

I have an excel spreadsheet on the network but opened through Sharepoint Small Business Server 2003. All the PCs on the network correctly open the XLS file in...

Hi all, is it possible to create a button to print to a certain printer? Please bear in mind this is not my default printer? Help would be much appreciated.

How do I restore the function of Edit cell by using mouse - right click?

We have a workbook that several people work with. Obviously if someone tries to open the workbook while someone else is already working on it they receive a...

I am a beginner. it may be a silly question. In excel, suppose in one cell a number is appearing as 9. I want to write in another cell as "Nine". How it...

Hello, I have used Excel for a long time and have never seen this. My arrow keys have been reversed. Up is down, down is up, left is right and right is...