I have sales data on a worksheet. The data entries contain the day in
column A,  month in column B, the year in column C and corresponding
sales figures in column D.
THere can be many lines of data for January 2006, not just one per day.

Eu gostaria de saber porque a planilha do exell vai somente até a coluna IV
(totalizando 256 colunas), caso ela vá até mais eu pediria para que alguém me
ensinasse a adicionar colunas além da IV, obrigado! OBS: eu já tentei
adicionar pelo método convencional.

I'm trying to use 'ISTEXT' with 'SUM' but it doesn't seem to be working.
Excel 2002 on Win2K.
A worksheet I downloaded (from Microsoft) using the formula works fine,
but when I try to use it in another sheet, it gives me 0.

Happy New Year,
  I know how to add columns,  but how do I subtract, can't find the - minus
it saids arithetic operator  lost from there  HELP  thanks

I have a time card that I created and want to take the name from one of the
cells that is in a vlookup table, and use that name to add a new worksheet
with that name. When I record the macro it uses the name that is in the cell
originally, but when I run the macro it still uses ...

If I open more than one Excel WB, and then close one of them, they all
close.  How can I stop that from happening?
Marv

How do i hide sheet name /tab without hiding the sheets?

I have an excel file that has about 30,000 cells containing names.
How can I quickly change the font color of all the cells depending upon what
word is in the cell.
For example, is there a way to search for the word John amonst the 30,000

Can I change the height of rows to 12.27 ?
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I

Aim: to select from a drop down box one's salary range and then spit out the
marginal tax rate. The rates are as follows:
     Australian 2006/2007 Income Tax Rates
     $0 - $6,000 Nil

If I open more than one Excel WB, and then close one of them, they all
close.  How can I stop that from happening?
Marv

I ran a MS-Access query to pull in some data from our database and one of
the date fields has the data formatted as either MM/DD/YYYY or YYYY-MM-DD.  I
want to change the data on the Excel sheet so that all rows display this date
as MM/DD/YYYY.

I have a list of expenses in a spreadsheet as so;
date--------description---------amount
1/1/06     entertainment     £28
3/1/06     fuel                   £50

I've created a two page excel spreadsheet.  Tab 1 has all the raw data.  Tab
2 has a 31 day calendar template and it is automatically filled in and/or
updated once the data is changed in tab 1.
The only manual work I have to do is put the days of the week at the top of

How do you insert a new row imbetween rows
without bringing down the Color of the above
row?
It always happen's