I just need a quick bit of advice on how to get a cell to be blank instead
of showing the above error whenever no data is entered in a selected cell
range.
The formula i'm using is something like

Excel adds coumns b,c,&d and enters the total into column d.  I need to move
column d to column a.  How can I copy or move column d and still retain the
formula to total it there?  Thanks.

I would like to set up codes for faster data entry, similar to SPSS options.
For instance:
Entering 1 would display Minimal
Entering 2 would display Moderate

I had a Macro which was made using Excel 2003, which looked up Excel files
in a folder, formatted them, saved them, and then repeated the process for
every excel file in the folder.
The Problem is that the I.T in my company upgraded me to Office 2007 today,

I'm trying to copy a worksheet.  In the old excel, I could use Insert
Worksheet and check off "copy sheet" .  I searched for copy sheet in Excel
2007 HELP and can't find it.   I don't want to insert a sheet and then copy
the contents, because it doesn't bring over all of the ...

Sorry just a follow up question. If I have a column filled with 1's, 2's and
3's how can I count each number i.e. there are seven 1's, six 2's and eleven
3's?

I have a stats sheet on a workbook and I would like to be able to get it to
read a "Yes" as a 1 and a "No" as a 0
Thanks for your help

I am holding shift (or Ctrl) and adding data to the cells in all the sheets.
However the page does not appear to move on the other sheets although the
data has been input.
Eg. all sheets when viewed start at Col A Row 1.  I add data to col Z row 1

Is there a way to use Countif to count the number of cells in the range that
are not errors - in other words - they are NOT #VALUE and NOT #DIV 0 etc.
=COUNTIF(A1:A5000, ??????)

I am opening a CSV file in which the first column is a text field.  The text
field contains a 9 digit alpha numeric characters.   Excel makes the
assumption that the field is a number, which then alters the content of the
alpha numeric text data by removing all leading zeros and ...

In Excel, how do I set up so that if I enter an "X" on one cell it would
color the entire row a certain color?
Thanks!

I am comparing 2 percentages.....B5 & B6.  In Cell C6, I have calculated the
difference.  Based on that number, I want B6 color coded.
I am using conditional formatting.  If greater than or equal to .01, green.  
If less than -.01 red....all other yellow.  My problem is that if the ...

for both Word & Excel - the paper default is A4 & needs to be changed to letter

I have a worksheet with 3 columns. I would like to return the value of column
C to another worksheet based upon the values in Col A & B.
A              B       C
21057       1        63.50

I have a large number of cells that I "reset" to a default value.  Is there
anyway to assign all of the cells to the default value at one time without
using a loop?