Anyone have any idea why I wouldn't be able to delete rows in a worksheet?
It doesn't seem to be protected for row deletion.
I am selecting the whole row (from the left side of the sheet) & then going
to the end of the sheet to grab the bottom.

I am developing a quiz template.
After the question is answered I want to display or activate a "Next
Question" command button  (affording the test taker the opportunity to review
the answer and explanation of the answer before progressing to the next

My spreadsheet is a calendar that counts the days of call for my 3
physician partners and myself.  Last year's was in Excel 97 and
through a lot of cutting and pasting I have the 2010 calendar all
set.  When I go to "page break preview", page 1 is seen, but the rest

Can any one help i want to count how many times a number appears in several
locations on several spread sheets any ideas?

Hi.. right now I have a worksheet in which I Multiply a particular
amount of cell H45 with a no. of days of Month (i.e January contains
31 days. feb containt 28 )
Right now I m doing this: ( =h45*31) for feb ( h45 * 28) etc

I have several cells containing calls to offset of the form:
    =OFFSET(Col1,Index,0)
    =OFFSET(Col2,Index,0)
    =OFFSET(Col3,Index,0)

I have a very big spread sheet. Each row goes across 15 cells. How can I have
the row outline in a different color to show what row i'm on and once I tab
to the cell I need how do I get the colunm outlined in a different color

Using this template, named "Commercial Invoice", as an example
(http://office.microsoft.com/en-us/templates/TC300018851033.aspx?CategoryID=CT101
172551033),
look at the lower 1/4th of the form, left side, just below the "sub-total"
section, there is a section named "Total Number ...

After I removed the pagebreak, my worksheet prints out very small.  Also,
without actually signifying the number of pages to print, it trys to print
1000s of pages ... that just started.

I am trying to backup workbooks upon closing.
I run a save all macro and then Application.Quit .
All workbooks are saved  no backup is done unless I close the book.
The application does not quit. and all the workbooks are still open.

I am new to excel 2007 and I can't get it to work the conditional
formatting to work the same way as in 2003.  If I have a date in cell
"A1" for example and I have a bunch of dates from C2 to C1000, how can
I get the cells with the C2:C1000 range to highlight if they are

I am using Excel as a database for Labels to be created in WORD.  My
Excel Doc is populated as follows:
Column A1-30:Name
B1-30: Address

I would like to output excel pages in XBRL.
Anything on the cards yet anywhere?

Hi Howard
I built the invoice template and it worked for about 8 times and then an
error came into the cell where the number is it states "The number in this
cell is formatted as text or preceded by an apostrophe". I have played

I can't figure out how to do this.  I think SUMPRODUCT might be the
key but I can not figure it out.
I need to extract the monthly sums of expenses incurred from a range
of data.