I am unable to insert a row in a spreadsheet (2003 format but working on it
in 2007) - each time I get the message "Can't shift objects off sheet".
Don't know what objects this message is referring to, this is a simple sheet
with no macros or objects that I can see.  Anyone know ...

Hiding columns on a spreadsheet ( which we do frequently). Error message
says: 'cannot shift objects off spreadsheet'.
WHat does this mean and how do I work around it?
Thanks!

oh boy...
I got a "cannot shift objects off sheet" error message on a worksheet I'm
editing.  Never saw this before. Tried to search for answer using "Help" -
using the phrase (with quotes):  "cannot shift objects off sheet"

Can any one invent a formula for this case. I sell the same products in 4
stores, some of the stores are having more quantities of the products
comparing to the quantity needed & the others they are missing products
comparing to the quantity needed. I want a formula which help me ...

I need 2 conditions to meet else it should be an empty sell.
My code is
=IF(AND(K47="abc", B3>=I49), (H49-B3)*J49*1000, (H49-I49)*J49*1000)
I still get the calculated value, even if cell K47 is blank.

I am trying to say if I4 has something in it and K4=X, then put 200 in this
field, but if not see if I4 has something in it and J4 >0 and L= YES then
times J4 by 1.5, if not put 0.  my formulae is
=+IF(AND(I4>0,K4=x),200,IF(AND(I4>0,J4>0,L=YES),J4*1.5,0))

how do i specify a maximum lenght allowed in a cell.
example:
A1 = 8 digits
B1 = 3 characters

Can I have a drop down list that, I can either choose from or input something
different?

I want to look up a column on another worksheet to look for a code and then
copy information from that row into the new worksheet. I am using a IF
formula at present but I want the correct answers at the top of each page. Eg
code =2 on sheet2 code =3 on sheet 3 but want the ...

I am trying to achieve multiple lines of text in a single cell.  I want the
right edge of the cell block to stop the text and kick it down to a new line
of text, but still within the same cell.  Is this possible?

My C drive crashed. Had to reinstall Office 2007 Professional. Trying to
create a simple spreadsheet this morning, I can not drag/drop page breaks and
I do not have access to the PAGE SETUP toolbar in PAGE LAYOUT tab.  I can
access Page Break, Print area, and background only.  I ...

I HAVE A DATABASE OF INVITES FOR A CORPORATE FUNCTION. ON A SEPERATE
WORKSHEET I WAS ABLE TO DO A COUNTIF SO I KNOW HOW MANY INVITES A SALESMEN
REQUESTED TO BE SENT.  WHAT I NEED HELP WITH IS:   A COUNT OF HOW MANY "YES"
RSVP'S A SALESMAN RECEIVED AND A COUNT OF HOW MANY "NO" ...

OK here's another problem I need help with.
A     B       C     D
x      x       x     Certifiy Now, In Training
I need a formula that provides me with a flag (in cell D1) depending upon

I can use COUNTIF to determine the number of times a name shows up in a
column.  I want a formula that will determine the number of times that a
certain name in a row also has a lower case x in another column in the same
row.  I cannot figure out how to use two COUNTIFs in the ...

What am I doing wrong?
thanks,
gary