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

How do i show comments not always without using mouse. I mean when i go to a
ceel using keyboard it should should comment. further, how can i give one
comment for entire one row and one column.

I have a DSN file that i've been using successfully for some time to
connect to my data source. It's in the format of:
[ODBC]
DRIVER=SQL Server

I have been putting together a financial model that includes drop down boxes
via the Data Validation facility in Excel. The problem I have is that I want
to put the range of data for selection on a separate sheet but seems that it
must be on the same worksheet as the drop down ...

How Can I hide formula without locking it. please help

I created a pivot table in Excel with Visual Report 2007. I'm using an
Outline Code with 2 leaves : Receipts and Expenses.
The pivot table created automatically a Grand Total so that $1000 Receipts
and $800 Expenses => Grand Total = $1800.

I have numbers in 7 columns (A-G) and 499 rows  (1-499).
-Question 1: How could I see if exist two or more same rows?For example:
          A                B            C            D            E
F            G

I'm wondering how best to achieve this -- I have an INSERT INTO statement
which exports data from my Excel worksheet to SQL Server, but I'm not sure
how I can query/retrieve this data from SQL Server, and have it populate the
EXACT cell from which it originated.

I have been trying to print a schedule for work and every time i try to print
it the paper comes out of the printer blank. What am i doing wrong?

I have created a check box from control toolbox but it does not work. I mean
i cannot do both check it and than uncheck it. Please help.

I've built a nice macro, but I want it to insert the date it is run in an
empty cell within the macro's range. When working within a spreadsheet, Ctrl
+; returns the system date, but I can't figure out how to put that command
into a macro.

Please tell me if a column can be filtered based on the value in the
middle of a word.
For eg.
Col A

I would like to toggle rows to hide/unhide based on the value "Hours"
in column B.  I think filtering is an issue to some blank seperator
rows and merged cell headings.  There are no merged cells involving
Column B.  Thanks.

Hi, I created a macro that filters data from a column into seperate
worksheets.  When I enter new data into the column and run the macro
again, I get a Run Time Error '1004'.  Can someone help me write a code
that either replaces or deletes the previous worksheets?  Thanks.

One of the users I support gets the following message when he opens some
.xls files
Timer:  Error:  91  Object variable or With block variable not set.
There are two scenarios where this happens.  In both cases the error message