I want to be able to scroll a table  only up and down NOT left and Right.
Could anybody help me Thank you

I have several text statements, each within its own cell, A1:A10
I want novice users to be able to pick and mix one or more of these, string
them together in any order, e.g. A2, A5, A1, in another cell (A15), then
edit that cell to link the statements into a single grammatically ...

Using Excel 2000
Column A contains user names
Column B contains their department
Column C thru X contains number of years in certain field

I have an excel workbook containing about 80 tabs.
All tabs contain data in the same format.
Some tabs contain quantities, some do not.
If a tab contains quantities, they are in columns J and K.

I seem to have a strange problem with Excel 2007 .
I have a simple formula but it doesn't work .
=if(A6=6 1 0)
When I get a xls 2003 worksheet with this formula it works fine.

Excel 2007 with password. When you put in the password it comes up: "The file
is corrupt and can not open". Works with every other computer. If we copy the
worksheet and do not put a password on it opens fine. The moment we put a
password on it, it will not open.  Any help is ...

=(IF(ISNUMBER(G3),G3,E3))
I am using the following very simple if statement. If "TRUE" i want the
reference from G3 to be
green and if false the reference E3 to be red.

I have two requests:
1) How do I create a hover message when a pointer moves over a cell?
2) How do I create a flashing warning Message in a cell?
Thanks

how do i calculate sqaure roots in excel

Had a message when trying to hide column: "cannot shift objects off sheet"
what should I do??

I have a weekly sheet where I have inserted a macro button to remove
data from a previous week when starting a new one.
I want to put a warning message on screen first before the Macro is
executed. How do I do this?

Hai I am maintaining a template which having values and blanks. I want to
delete the blank rows. I wrote program as
Sub DelRows()
Dim c As Range

what these two lines do in formula, please
=SUMPRODUCT(--($K$17:$K$200=O17)*--($G$17:$G$200="s"))
after SUMPRODUCT(--
after =017)*--

if col a12 is todays date I would like to have b2 to cz2 backgroundcolor GREEN
otherwhise leave B2 to cz2 as white background.
I cannot seem to get it to work Any help wouldbe appreciated
Thanks

Can anyone please tell me why I can not use a conditional format (<>=)
to identify if a date is greater or smaller then another. Everytime I
try it, Excel does it right in the first column but misses by 2 days
in all following. It also appears to have problems with the years.