Is there anyway to protect selected cells from editing without having to
protect the entire worksheet?  I know that I can lock or unlock certain cells
when I protect the worksheet as a whole, but when I use worksheet protection,
it interferes with some of my code and user ...

I have in  row B2 and B3  a static number in them ie 5000, in C2 and C3 a
entered number, and in D2 and D3 it is the difference between these.
In E5 this is the total amount required to balance B@ and B3, I can work
this out but what I require in E5 is a 0 if cells C2 and C3 are ...

i have used special paste before to transfer data from one cell in one
worksheet to a cell formed by 4 merged columns in another worksheet--using
copy-special paste-formula.  Works like a charm.  Now when i try to use
special paste i get a totally different dialog box with ...

Hi, I really dont have that much knowledge in this area.  I have about 200
worksheets all with the same structure of columns.  They have differing data
and all need to be put into 1 workbook.  Copy and pasting would obviously do
it but due to the number it would take forever.  ...

I am having trouble wrapping my brain around this one.
I have a listing of columns for months (in reverse order).  In each row
is that months budget numbers.  What I want to do is have a column that
sums the year to date based on a value that is typed into a cell.

I have a group of letters that I would like to change to numbers. namely B to
1 and P to 2.
Thanks for your help.

I'm wondering if anyone knows of way to reference Named Ranges in functions,
but in a way that makes the reference a variable based on values in another
cell.
For example, say there are four named Ranges in the spreadsheet

In the file menu, I click on page setup, nothing happens.  It is not grayed.  
It works in Word documents, but not in Exel document.  What did I do?

I am trying to create a workbook where I use list boxes to select the year,
month, and salesperson, after the selections are made I enter the data in
specific cells.  From there it will be put in differnt sheets and formula
throughout the workbook.  The issue I am having is that ...

Is it possible to apply conditional formatting to a cell which is NOT the
cell being modified?
For example, if I enter a 5 in cell A1, can Excel change the background
color of cell B1 to yellow?

I have a column of numbers. Some of the negative number with negative sigh
at the end of the number. How to I convert the negative sign from back of the
number to the front of the number. ( x- -> -x)
Thanks

I have a list of customers our company sends birthday cards when they
come around.  I am importing the list from Access to Excel and then
using Sort to put them in order of month and then day, both descending
so that I can delete everything but the month that I need.  Excel puts

I'm trying to use an intersection for a cell.  I want the first term to be
the value that shows up in one cell and the second term to be the value from
another cell.  I'm having trouble figuring out how to use the single quotes
that are needed, along with the value of the cell.  ...

Control Home brings the cursor to Cell A1.  Fine.  But why Control End takes
the cursor to a distant cell, where there is no data at all, other than
selecting the end of the table or the current region?  Can anyone say the
reason and how to prevent it.

I am creating schedules and have the whole month in one document, each week
has its own tab. I want to have all the formatting the same.(i.e. all in
landscape with equal margins, print size 70%, showing gridlines) I know how
to do each of these tasks, but not on the Whole excel ...