My boss had me merge together a ton of data.  
       Group Name, Renewal Month, Broker Name, Broker Phone, Address,
Address 2, City, State, County, Zip, Employer Phone, Employer Key Contact,
EE's, SIC Code, Current Carrier, EE Rate, EE Rate2, Benefit Design, Status,

Does anyone know of a way to mass delete rows from an excel spreadsheet?  
I've got 5,000 rows I need to delete and don't want to have to click and
drag.  Is there a way to mass select?

A couple years ago I remember being able to tweak the UI (I don't
think I used TweakUI, but maybe) to let me right click on a
spreadsheet and choose to open it as read only.  This is as opposed to
explicitly saving a file as read only or read only recommended.

Set rng = Range("D2:D"&Cells(rows.count,"D").end(xlUp).row & ")"
When I extract only
Cells(rows.count,"D").end(xlUp).row  and drop it in the Immediate window
preceeded with a ?

Excel has a splendid way of copying your cell if it is repeat information. Is
there any way I can adjust this feature to recognise a number and it will
automatically place the name in the next cell? Thanks.

Is there a way in Excel to change a calculated field to an actual number?  
For example changing =B2 (10)+C2 (12)  to actually be 32?  I want to use this
field in a seperate system, can it will not copy since it is a calcuated
field.  Thanks.

Is there a way to select "Accounting" format as the default within a
pivot table?

I'm looking for a forumla that will tell me the best 7 days of a series of
data. I have a SS of the past daily values (roughly 5 years) for my division
and need to know which 7 consequtive days were the greatest in total.

trying to get the excel sheet to allow columns A and B to stay in one place
yet allow C thru infinity to move right and left with the scroll bar

Greetings all!
I have a spreadsheet created in Excel 2007 that I am looking to have the tab
of each sheet the same color as a specific cell within that sheet.  The cell
(M20) is a results cell that contains a short formula and has conditional

I used Ron deBruin information to had a drop down calendar to a worksheet
(actually multiple). Worked fine at first but I must have changed something.
First, the calendar date "default" is one day in advance. In other words
today is 5/27/08...but the default when the calendar ...

Some of the Excel worksheets that are saved show up as an xlr file and the
result is that Excel will not  open the file.  can someone explain why?  What
is the determining factor for an Excel file remaining an Excel file or
becoming an XLR file?  Thanks

I have Excel 2002, and came across a website that has a PayPal/eBay
calculator.  I needed an exact dollar amount, but forgot about the fees that
would be charged. I told my sister that I knew the percentage and additional
fee PayPal charged for receiving money which is: 2.9% plus ...

I have a list of numbers from G11 to G94 but I also am also using a filter in
other columns therefore I would like the average to change if I decide to
filter.
Basically I want the average to always be from the first number to the

I've figured out how to conditionally format my column graph columns
with help from Jon Pelletier's formula. I'd now like to add a line
graph to the overall graph to show overall business trending in
addition to the site trending in the columns. The existing graph