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...

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...

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

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...

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...

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...

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...

Is there any way to automatically adjust the fill color of a cell based on 3 values entered into 3 cells? Specifically, if I have entered the values 100,...

Hi - Someone (who shall remain nameless) saved changes to an excel spreadsheet but does not know what the changes were. Now when we open the spreadsheet it...

I have just upgraded from Office 2000 to Office 2007. In Excel 2000 I was able to insert a unique invoice number automatically by clicking "add number" on...

I am making a payroll spreadsheet for my work, and I need some help coming up with a consistent formula. There are three types of hours at work - Regular,...

HOT WATER HEATER:50766-1 HOT WATER HEATER:50766-10 HOT WATER HEATER:50766-2 HOT WATER HEATER:50766-3 HOT WATER HEATER:50766-4 This is the data that I am...

I neeed to merge 16000 rows of data with some duplicate vales. Poor record keeping lead to two lists and each was updated independantly if at all. Some...

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 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...