When I enter 1, 2, 3 in a1, a2 & a3, respectively, then select the cells and
drag down, the numerical sequence continues (4, 5, 6, etc). However, if I do
the same with a, b, c, dragging merely repeats the order (a, b, c, a, b, c)
rather than continuing the sequence (d, e, f, etc ...

I have been using Excel 2007 since about March with no problems. Recently I
started experiencing a problem when the application is stated. It randomly
(maybe 2 out of 6 times) does not open to the "grid" screen but rather a
light blue screen with nothing on it except the Ready ...

Can I lock Row heights so that inexperienced users don't inadvertently change them, losing site of some of the content, then thinking something is wrong?

Hi I have this formula
=-(D18-(VLOOKUP(C18,'Data Table'!$B3:$G12,5,0)))*(VLOOKUP(C18,'Data
Table'!$B3:$G12,3,0)*E18/1000)/((VLOOKUP(C18,'Data Table'!
$B3:$G12,3,0)*E18/1000)*(VLOOKUP(C18,'Data Table'!$B3:$G12,5,0)))

Hi I have this formula
=-(D18-(VLOOKUP(C18,'Data Table'!$B3:$G12,5,0)))*(VLOOKUP(C18,'Data
Table'!$B3:$G12,3,0)*E18/1000)/((VLOOKUP(C18,'Data Table'!
$B3:$G12,3,0)*E18/1000)*(VLOOKUP(C18,'Data Table'!$B3:$G12,5,0)))

I know there are a plethora of dynamic charting posts, but I have a
question that I don't see an answer for. I need the data to update on
a daily basis as new data is added. I have to do this for 50 different
graphs so an easy way to do this would be excellent!

I would like to format my numbers this way:

= 0  --> Black
< 0  --> Red

In Excel 2007 is there a way to sort a column and have the sort ignore
leading "the" and "a"?  For example, I have a list of titles and many of
them start with "The" as in "The Man Who Shot Liberty Valance" or a
leading "a" as in "A View to a Kill".  I'd like to sort these and ...

I am using excel 2000 and having some problems with two particular cells
(which contained formulas) in my worksheet. I have been using both
conditional formatting and VBA to change the color of two cells according to
some conditions:

I do our employee schedule and I have a problem with putting employees in two
places on the same day. Is there a formula that I can use to not let me put
to people on the same day in a column? Please Help I do schedule for 96
employees.

I have created a button (using the VB toolbox) in a 2003 version of excel. I
then saved the workbook and opened it up in excel 2007. When I click on the
button it runs through the macro behind it. However when I right click on
the button there is no functionality and so I can't ...

I have on a notebook a cell with a hyperklink to a image of .jpg type. When
i click on hyperlink, excel (2003) run Internet Explorer 7 application, bat
i want to open and to run Picture Manager application.
On my desktop, for the sames conditions, run Picture Manager: Can i change

We have Field Tickets used by 25 different men. These tickets are identical
and are emailed to each man in the field. Each man adds hours, descriptions,
saves the ticket by a job number and emails the completed Field Ticket back
to the office.  Periodically the office receives a ...

A customer can't use "Copy Special" in Office 2007.
He has upgradede Office 2007 from 2003.
When he copy cells to another workbook, the formulas aren't copied.
And when he tries the "Copy Special" a windows comes with questions about