Is it possible to automatically embolden totals in a pivot table (the entire
row where a total or subtotal is)
ive looked every where and can only find template formats but nonr for a
plain pivot table with bold total rows.  

Is there a code to delete rows automatically once it reaches row 100. But to
delete from row 1.

I have used dynamic ranges to create a chart that expands as new data is
added.  I get economic data from an external provider which I update/download
daily or weekly.  New data  is added in new rows I refresh from the data
source and the chart expands automatically.  The data is ...

When I run a macro I've disabled some screen flicker using
ScreenUpdating=False which works fine. But part of my macro is to open then
close another workbook, and when it opens it automatically displays for a
second until it closes again. Is there any way I can stop this?

Here is the quick explaination.
I work as a trainer where each person in my class is assigned up to 40
classes in an online university program.  I can produce an excel sheet from
within the program, that will list everyone for a set range of time.  Problem

I want to inset a text box in my excel sheet, but options are all grey.  It
is a shared drive.  How can I unprotect it.  Option for that is greyed out
too.. I can make other changes in the sheet, but can't insert a text box, so
that doesn't make sense.  Why else would they be ...

I have a graph that is linked to a data set in my workbook.  However, when I
try to hide the cells that the graph is linked to, the graph goes completely
blank.  Is there a setting or something I can change so the graph will read
hidden cells?

Hello. I am trying to do an =sum for 205 rows.  The result is 0.  I checked
Tools | Otpions -- Automatic is set.  The cells leading into the =sum are
formatted as numbers.  (Also tried it with General). The cells that lead into
those cells are not text.  Any ideas on what is ...

I'm currently trying to calculate an average for all cells in a row,
starting with the first cell that is greater than zero.  The only salient
example I found on the web has apparently been unable to permeate my morning
fog, so here I am.  The example I located was using a ...

i have a column that i type in insurances.  
i have four different broad types of insurances, medicare, medicaid, self
pay, and commercial insurance.  The commercial insurance is listed by the
specific company.

I frequently use the Data/Subtotals feature in Excel.
After forming the subtotals, I would like to work on them alone without the
underlying data showing up.
Is there any way to extract the Subtotals ONLY to another worksheet and to

Ok i have 3 series, 2 of them i am doing trendlines but the lines go all the
way on the chart and I just want them to cover the same space as the data on
the series how can I make that trendline only go with the data?

I have 2 sheets. The first contain a number in 11 consecutive cells and the
other sheet contains the same number in 6, sometimes, consecutive cells. What
I need to do is go into the second sheet and for each cell that contains that
number, I want to extract values from other ...

I have 11,000 long text strings in Excel... I had used LEFT operation to
limit the strings to 500 charaters, now I need to trim the strings to the
last available "." so that I can delete those uncompleted sentence after the
last "."

I stumbled across a great tool on this website (that was linked to Ron de
Bruin) for copying multiple text files into one Excel workbook. This could be
extremely useful to me. However, I'm stumped on altering the code for
assigning the column widths. Below is the code that was ...