Regarding the autocalculate field on the bottom right of excel 2003 where you
can do sum, count, average etc., the field is sometimes too small for me to
see the entire number. Is there a way to make this field bigger so that I can
read the number out to all decimals that it ...

I'm trying to enter a formula so that the cell where the formula is being
entered displays the current date, so I wrote in F6
[=TODAY()*(IF(E6="done",TRUE,FALSE))], which works, but when the word "done"
is deleted F6 then displays 1/01/1900.  Can I correct this so that F6 is

Excel 2003 / Win XP
How can I Tab text in a cell.
Using the Tab key just tabs the Cursor but doesn't take the text with it.
I've tried all combinations of Shift/Ctrl/Alt with Tab but no luck.

Hope I can get an answer here!! Otherwise I'm going to be at work all night.
Here is the problem:
I used to be able to click and drag some info (date, amount, qty) from a
website and paste it on an Excel file, this would place each (date, amount,

I am copying a large spreadsheet - I am getting an error.
THIS OPERATION REQUIRES THE MERGED CELLS TO BE IDENTICALLY SIZED
CAN ANYONE TELL ME WHAT THIS MEANS?
I WOULD APPRECIATE IT.

So i'm trying to Filter my database by dates. (For example, filtering
information that is in the month of Jan. 08). When I try to filter by dates,
it is not working, any suggestions?

One of our consultants was copying and pasting headings for a table in a
worksheet and the next thing he knew, he was at the end of the spreadsheet,
at column IV. Now whenever he opens up a new workbook or spreadsheet it opens
at column IV. He can use Ctrl+< to get to column A, ...

I have a workbook with a sheet "Lot Information" where the homeowners
name and lot number is listed:
Column A - Lot #
Column C - Owner Name

A                 B  C        D
1          2.0              1.0 U       3.5
2          2.3              2.0          3.1
3          2.5              1.3 I        2.5

when i go to open a file, i have them listed by date, but the subfiles are
listed last and i want them to list first, by date modifed as well, and then
list the files by date modified
please resond to my email

=INDIRECT($A$3&"!B53")
I want to autofill down my column but have the B53 change to B54, B55, etc.  
How do I set that up.  I think it has something to do with "rows"?  Thanks,
Eden 397

In certain cells that contain formulas, the results gives me a Zero or where
the results gives me an error message....I want to see this on the screen,
however, I do not want these results to print. Here are my examples:
C40  =SUM(C8:C38)  ....nothing has been entered into C8:C38, ...

Is it possible to have a cell linked to multiple cells in a different column.
I want A1 to have a dropdown so I can select my dated title of my
information on A2.  Then I would like for B2-B4 to display when I select A2.  
And when I select A3, B5-B6 will display informaton.

Using the Microsoft Project "Analyze Timescaled Data in Excel" feature (View,
Toolbars, Analysis), I can export project Resource Work in summary to Excel.
The feature creates a spreadsheet with the timeline on Row 1, Resource Name
on Row 2, and Resource Work on Row 3 by ...

I have a workbook which has 16 worksheets within it. All worksheets are 1
Page each. Even though the Watermark that says "Page 1" on each worksheet
does not print, it is in the way and irritating operators of this
spreadsheet. How can I get rid of this Watermark from view??