I am trying to change the color of one of the gridlines in my line chart (not
all of them). Since I have not seen any sort of formatting option along these
lines, I used the autoshapes function to simply add a colored line on top of
the desired gridline; however, I want to be ...

I have a worksheet that has 45 pages.  I inherited the worksheet from a
coworker.  The worksheet has six columns that contain data.  The column
headers used to appear at the top of each printed page.  The worksheet
recently became corrupted and now I am unable to figure out how ...

In Excel 2007 the file open directory sorts in horizontal order instead of
vertical order as it did on previous versions.  Can this be changed?

I have a data column that has names listed like this; Ann & Bob Smith, Ann
Smith & Bob Smith. I know I can use the data-text to columns-delimiter for
names such as Ann Smith, but with space in between the examples above I am
getting rows of useless data and deleting the column ...

I have a cell containing the formula "=TODAY()" .  This formula returns and
displays the current date in the cell. I want to ADD the TEXT "Today's Date"
to the SAME CELL without interfering with the functioning of the formula.  Is
it possible to do this in Excel?  If so, what is ...

2 cells.  One for feet(A1), one for inches(A2).  A3=(A1+(A2/12))
-Ok lets do the samething again.
2 more cells.  One for feet(B1), one for inches(B2).  B3=(B1+(B2/12))
-One more time

I would like to create an if statement that could somehow read whether or not
a check box is checked.  I'm pretty familiar with Excel programming, but not
much beyond that.  I would like to do something like if(checkbox=true, 15).  
Something like that.  Does anyone know if I have ...

I would like to know what I can do to keep the cell under my checkbox from
displaying the CK value ("TRUE" or "FALSE").
Can somebody help me out with that?

I'm working in Excel 2002.  If there is a formula already in place and I
change a number it will not recalculate; but if I redo the formula after
entering the number it will recalculate.  Ex.  AutoSum C1:C10 - if I put the
formula in with no numbers present it will NOT calculate ...

The labels on the worksheet tabs are too small to read.  Is there a way to
increase the size of the font?

I have a column with names such as Ann & Bill Smith, I know that I can select
the column and use the Data/Text to columns with single first /last name but
what if this is the way my names are in the cells?

Have a working validation list...however, some users are complaining that
when they choose a value from mid point in the list and move to the next
wrong...the list stays at the mid-point and does not reset to the start of
the alphabetically sorted list.

I have used an excel workbook for a couple of years with no problems but it
has now decided to print only on portrait although the print settings are for
landscape - any anwers?

I need to calculate years of service. I have the hire date in date format
(ex: 10/04/1998 - in cell C4). I have extracted the hire year in D4 using
=YEAR(C4). So far, so good.
C4=hire date

I have this macro to pull multiple excel files into one sheet, it works fine.
However it puts all the files into a new workbook. I will like it to add the
files the workbook in which I run the macro from. Can anyone helop me out?
Sub CombineExcelFiles()