I created an excel document and I used it for years. From time to time
I fill in a new row, only with numbers.
Recently I noticed that some of the cells change color when I
introduce any number in them.

Good afternoon:
Is it possible to enter data on one worksheet and populate another protected
worksheet in succession and remain there after the original data is erased
from the "working worksheet"?

Excel 2003 - How do I set up a formula for the following:
I wish to have a running total of a $ amount brought forward in a column,
starting cell J3, followed by an additional amounts in G4+G5+G6-H7+G8
+G9-H10 etc. J4 would then show J3 plus G4 and so on with a final total

Have file folders with dozens of spreadsheets and noticed the CHART
LEGEND fonts a too BIG. I'd like to change ALL chart legend font sizes
on all worksheets in a spreadsheet at once.. using a tool or script,
etc. Any solutions?  There are simply too many charts to open and

why does a cell return a decimal when text is linked in an "if statement"????
.. the format of the cell is set to fractional.
This statement """=IF(G4=0,"",G4&"'' x")""":  retuns (a decimal): I.E .375"
x   -----

I work in an assessment office and I enter alot of tables that involve pin
numbers, property address, owner, owner address, as well as other
information.  I would like to be able to 'freeze' the rows and be able to
sort by these different categories without the rows getting all ...

I just downloaded an Excel trial. Why can I not enter data in the cells? Is
the trial version just to show me how pretty the program is, or can I
actually try it out? Whats wrong here, am I being stupid?

I have a spreadsheet with strike out text combine with regular text in a
cell.  How do I remove only the strike out text from the cells?  The column
is over 7000 rows and it would be great if I can accomplish this task
automatically.

Is there a built-in keyboard shortcut for the Format Painter?
If not, is there a way to to assign to some key combination? I know I
can assign a key combination to a macro, but I would prefer not to
write a macro just to get a keyboard shortcut for a standard function.

The answer to this is most likely extremely simple, for which I
apologize.
I have 10 columns, each representing an inventory item.
Each row represents a name and the qty ordered per item .  The number of

I am trying to use the macro recorder in Excel 2003 to create a macro
that will copy selected data from one spreadsheet into another
spreadsheet.  The copy to spreadsheet is an Excel database and I need
the macro to find the first blank row in the database and then do the

I was hoping that I could reference a cell in another worksheet in another
workbook using indirect and address in my formula and I appeat to be missing
something or I am doing it wrong.
Target workbook = "c:\myworkbook.xls"

I am using Office 2003. I have copied some data from a word file in Office
Clipboard. Now I want to paste this all data in MS-Excel. When I
choose the "Paste All" option it pastes all data down side, while I want to
paste the data right side / left side. How can I change it's ...

I have to find out how old is the past date from today's date? Example
- Date of birth (A1) = 01/01/1978 and today's date (B1) = 08/15/07 so
on C1 (B1-A1) = ?
Thank you,

Occasionally I run into this problem:  when working with an involved
spreadsheet with numerous defined names and ranges, Excel fails to
update.  This often happens when I try to change one of the
definitions:  let's say, for example, the discount rate, on which a