When I do a subtotal, I would like that the values that I sum stay
bold like the inicial data.
How can I do this?
Thanks.

I want to choose a name from a drop down box in cell D7 and then have cells
D10, J10, M10 auto fill with the correct street address, city and state
respectively. I don't know where to start.
Joe

I'm using Excel 2003 and need to add a button that users can click to sort
new data. Once a row has been updated with new data, I want the users to
simply be able to click this "button" in order to sort the new data in
descending order.

I have posted this 2 days ago but didn't see it in group! don't know Why?
Posting for second time.
Two workbooks (of different names) that has the same worksheets with the
same names. Adjustments in formulas were made to one worksheet in book1.

Can someone give me some guidance on how I can retrieve the closest value in
a column to a target number, whether it be larger or smaller than the target
number.  VLOOKUP doesn't seem to work for what I am trying to accomplish.
The problem is analogous to a series of guesses for ...

I've been told that there are practise files for use in Excel. Having no data
to practise on, these would be very useful. Could anyone tell me if these
exist, and more importantly, how to get to them? Many thanks.

When a user opens an existing workbook in Excel 2007, it displays a blank
worksheet. When he minimizes and then maximizes the workbook, the correct
worksheet displays. Is there a setting that was changed that made this occur?

How do I create an ivoice with self numbering?

I am using Excel 2007 and want to break up a large worksheet into many small
sheets but retain the original data in one sheet. When pasting the coipied
data as a link the copied data is inserted into the new worksheet but sans
the original formating such as currency, number ...

In a cell where format is set as Currency, I enter 3+5 and it gives a
string, in stead of the calculation result (8 in this example). I have to
enter the equal sign first: = 3+5, then this accept it as a formula, showing
a green triangle in upper-left corner. Is there a default ...

I had to reinstall windows and MS Office XP on my computer.
Now the "Answer Wizard" and "Index" tabs are blank.  The
"Contents" tab still has the help tree.
What did I do wrong?

Help!   When using Excel 2003, it takes a very long time for me to
clear the contents of a large number of cells. The delay occurs
whether I clear the contents manually in Excel, or within a VBA
macro.

I'm looking for a macro that is compatible with Excel 2007.  I've
searched the forums and shareware sites, but can't find anything
current enough.  I have a workbook with many sheets, too many to
conveniently navigate through with just the basic Excel GUI.  I have

I'm looking for a utility that will allow me to make bulk edits of phone
numbers in Excel (for reimporting into Outlook as a CSV file).
I need to be able to convert numbers in formats such as:  00123 456 7890  or
[123] 456 7890  into the correct 'canonical' format:  +123 456 7890, ...

Excel 2002 SP3
Win XP HE
*Follow-up to: microsoft.public.excel*
Hi,