I want to force long text in a single cell to wrap at a particular place.
What is the keystroke to do this?
Old Ed

This comes up all the time. I need to create a table with a header
row, some variable number of data rows, and a totals row. These tables
get rows added from time to time, sometimes at the top, sometimes in
the middle, and sometimes at the bottom.

I want to get a total of range b3:af3 for cells that has s= a number ex 2,5,3
and have a formula to give me totals for those entries?

I am new to this newsgroup, so nice to meet everyone!
I have an Excel dilemma that I’d like help with.
I’d like to apply some macro programming logic to a data validation cell
entry, so then when a certain data value is selected in the pull down, the

I have an issue that has developed with Excel 07.
When ever I would click on a *.xls file I would get a short hourglass but
nothing would happen.  If I opened Excel first then the files would open
normally.

I have in column J some codes and  in column R some numeric values. In
J data has duplicates. I want a macro that adds all the values of each
code but without duplicates. Something like this:
J                             R

When I paste a hyperlink into a cell (e.g., http://www.yahoo.com), I
want Excel to treat it like any other text.
I realize I can accomplish this with the "remove hyperlink"
functionality, but I'd rather not have to go through that hassle.

I created a spreadsheet (excel 2003?) with January to December tabs.  I did
them one at a time.  Is there a short cut to add all at once i.e Jan - Dec
or 1 to 10 etc....
Thanks

Does someone know how to create a randbetween function or function
that will randomize
only thru the following strings?
group 10

I have a worksheet with a column for Name and a column for Amount.  The
subtotal in the inserted subtotal line does not show the subtotal amount
in bold, though the subtotalled name is in bold.
Is there some way to show the subtotalled amount in bold as well?

How can I get a UDF to change the contents of several cells other than
the one from which it was called?
Can I use named cells or must I use A1 addressing?

I have the following formula in my spreadsheet:
=CONCATENATE('C:\Users\John\Documents\Miscellaneous
Stuff\[productindex.xlsx]productindex'!D2,"
",'C:\Users\John\Documents\Miscellaneous

I have an Excel 2000 file created in Office 2000.
What I do is 1) Save the file as Excel 97-2000 format from Office 2000. 2)
Open it on a machine that has only Excel 97 installed. 3) "Save As"
Microsoft Excel File.

I have 3 columns of experimental data (C:E).
Row 30 contains the sums (C30:E30).
I need a formula that will examine the three sums and return the
column number that has the lowest sum. If more than one column is

I have three Excel 2007 lists, around 200 rows each.  I've now found I need
to insert a blank row after each list entry.  Is there any easy way to do
this?  I'm pretty decent with Excel, but don't know VBA.  I thought of
recording a macro, but didn't know how to edit it so that I ...