When I follow the suggested procedure to disable autocomplete in cells in
Excel 2007 by unchecking the box in options, advanced and then enter "OK"  
.....autocomplete remains active.  Very frustrating.  Has anyone observed
this.

For my children I wanted to have practice in using log table while
multiplying and dividing.
For this I have a book Clark's Tables (Science Data Book) by Orient Longmans
This has Log and Anti Log tables.

Spreadsheet with many columns:
In     All column, Row4    I have dates:
What I like to do is:
"IF" I am in Column y "Any row" I would like to go up to Y4 and copy that

Hi I have a huge spreadsheet
Column A has numbers
Column B has dates
If I wanted to write a formula that shows count the number of times there is

I'm trying to write a formula to round a number with the following
conditions:
1. If the number in the thousandths place is a 0, 4, 5, 6, 7, 8 or 9
round to the hundredths place

I have a list of dates in column A, and numbers down cols B-E.  Off to
the right, I need a table that lists the month/year and the totals for
each of the columns.  It needs to be a separate table, rather than a
pivot table, so it can be copied-and-pasted by others.

I'm trying to create a formula to minus one date from the next. So i've done
the standard equation in column d (=c1-b1) and i get my answer. but in some
cases some cells in column b are not filled in. so in column d i get these
really big numbers. i dont want those numbers there ...

I call a subroutin inside my main macro.there is a conditional
statment inside the subroutin which if it true,the program must give a
message,and terminate.My code look something like this:
sub macro1()

How would I set up a formula that consists of  sum of a column on page 1, sum
of  column on page 2, sum of a column on page 3,  a sum of column on page 4
and posting the results  out on page 5?

Hi there….
I have 14 columns on the excel spreadsheet.   The first column should
set the size “10” and other 13 columns to set fit automatically.
When I use the code like this  >>>   ExcelWorksheet.Columns.AutoFit

I am trying to view my validation table in my spreadsheet but because of all
the columns I am viewing my spreadsheet at less than 100%.  The validation
table options are displaying so tiny I cannot read them.  Is there a way to
increase there font size?  All other fonts even at ...

How would I set up a formula that consists of  a sum on page 1 + a sum on
page 2 + a sum on page 3 + a sum on page 4 to = out on page 5?

Is there a way to reset the command button counter?
I just put 1 button in this workbook and the command button number is 6120.
Although I had command buttons in this sheet before, they have been deleted
and now this is the only button.

I am hoping I can use excel to sort this problem.
I have received an email from turkey to UK and the keyboard is different so
some letters come out as `ı` I think it refers to the letter i.
I seem to recall in excel that one could take a letter or number and

Excel 2003
As per the example created below I'm using a formula to return a number
value (in D1) that can be anywhere between 0.00 & 6.00 (including 0.00 & 6.00)
I want my formula (in E1) to compare the value (D1) to min & max values in a