I created a sales invoice from a template that I like with the invoice number
starting at 1001 in cell E5.
Is there a way to make the next invoice by either (move/copy sheet) or a
button that would make the next invoice increase the invoice number to 1002

Please advise of a cheque requisition template

Is there a function or formula similar to SUMIF that will work for average,
median, & mode?  
I have an array of numbers with corresponding values similar to the following
Nbhd    Size

There are 26 column of data starting from A to Z for 100 rows.  I would like
to create a correlation matrix to show all combinations of 2 sets. Does
anyone have any suggestion on how to create a correlation matrix in excel?
Thanks in advance for any suggestions

I have a spreadsheet where the lines have been drug completely up as if
hidden, but they are not hidden as a command. How do i bring them down w/o
doing it one by one.

I recently administered a test in Excel 2007, and it is fairly obvious that
one student cheated by using someone else's completed test.  Although I'm 99%
sure of this, I wondered if there is metadata in the Excel file that would
prove it.  For instance, does metadata show all the ...

I have several excel files used for bidding purposes and each one is set up
exactly the same with multiple worksheets.  How can I copy a change or add
formula to one and be able to copy that to all of them without  it linking to
the original worksheet that I made the change to.

Using Excel 2003. Opened a workbook and on each sheet, a dash is displayed
through each row number and column letter. It's present if I add a new sheet,
too. Anybody know what this means? I don't see any unusual formatting on the
sheet.

I have Excel 2003. I a column containing 30 rows. I would like the numbers in
each row of the column to be to two decimal places, i.e., xxx.yy. I am
currently in row 2 of the column. What do I do to automatically general
number to two decimal places in the remaining 28 rows?

I have a column of numbers formatted as h:mm and I want a sum.  I have read
the posts about formatting the result cell with brackets around the h.  When
I do this, and use the autosum button, I get the pop-up message that there is
an error in my formula.  Any suggestions?

Good afternoon,
I could probably event code do this in VBA if I had more time, but is there
any way of using standard conditional formatting to say "colour this cell red
if the cell 10 coumns to the left contains a value" ?

Sometimes I've imported spreadsheets where the top row was hovering when
scrooling down.
How can I enable this feature on one of my rows? Could be wicked..

If I type a ' symbol as the first character in a cell it appears on the
formula bar but isn't visible within the cell.  Can it be made visible and if
not what is Excel interpreting this symbol as and doing with it?

I exported data from Crystal Reports to Excel.  I have a huge spreadsheet,
and a lot of blank rows in between records of data.
Is there a way to "tell" Excel to get rid of any and all blank rows, rather
than having to manually go through the tens of thousands of rows of the

We have a group of formulas that we always add to a certain spreadsheet.  
Right now, we either retype the formulas or try to copy them from another
sheet (although at times it will only copy the value, not the formula itself).
Is there a way to store a given formula or multiple ...