software

I need some help to create a nested quot;SUBSTITUTEquot; formula.

client is looking to save an excell file to a work doc as a button that would
need to be clicked on to open. any help would be greatly appreciated.

On a large worksheet, is there a way to fill the blanks in a column with the
last filled cell without using the autofill handle? My worksheet is over 2000

How can I show the name of the spreadsheet -after Microsoft Excel- ( on top
of the Main Menu Bar).

I have an Excel address list of 400 contacts. I'm using mail merge to get
these into Word for label printing. When I edit the Excel chart by hiding

In Excel 2003, can no longer insert new worksheet into an existing workbook.
There's about 70 sheets at the moment, but we have several books with more

How do I change the default file for inserting a picture

Although Excel provides Database processing (DSUM etc) it does so with
quot;externalquot; criteria - quot;externalquot; meaning that they are defined in cells

Hi,
I have following data in columns A and B. Column A is the average price

I subtotaled (sum) on 3 columns based on changes in a 4th column. There is a
5th column (repeating text info in all cells in the subtotaled groups) that I