My data in Excel includes among other fields age and annual salary. I would
like to prepare a 2-way frequency table, without the use of pivot table,
giving a count of salary earners between 1000000 to 150000, 150001 to 200000
and 200001 and above for those aged between 20 and 30, ...

i have a general field     100-11-11-00
i want to remove the -  and make it 100111100

In most applications it is Edit -> Invert selection. I've spent time
searching help, the KB, etc and can't find it. I'm sure it's quite simple and
I'll feel like an idiot once someone points it out...
Thank you.

I have a large xls doc and some cells have entries that end with
<li>.  I want to remove only this last instance of <li> and only when
it is the last thing in the particular cell.
For example:

I am working on a spreadsheet and all tab sheets have to be in Page Break
View. In the background there is an annoying PAGE 1 that is in the middle of
the page. I know it's a dumb question, but if it is possible, how do I get
rid of that?

I have the following  sub total table:
    Subtotal Table           
    A     B    C    D
1    Area    Product    Date    Amount

Dear Sir,
I have the following table to be formatted :
    A    B    C
1    Product    Invoice    Amount

I have:
Col A    Col B
Dog        5
Cat         3

If I change my page margin set-up settings by making the left margin larger,
the header position stays at a certain default offset.  How do I change the
header left (and right for that matter) margins to be aligned with the page
margins?

I am making a sheet where for example 'the cell A1 has a data validation
list' and depending on the selection in A1 cell the data validation list in
cell B1 will change.
for example:-cell A1 contains the list of  team leaders depending on the

I installed Excel on my Macbook Pro and now everytime I start my computer
Excel starts also. It's obnoxious and I'd like to get it to stop opening
automatically. Can anyone help me out?? Thanks!

I have defined range names that I want to use in more than one worsheet in
the same workbook, to refer to cells in the same worksheet.  However, Excel
always inserts the present-worksheet name in any name definition.
Is there any way to supress this, so that I can use names in the ...

When I double-click and Excel document, the program will launch but the
document is not displayed. Minimizing the window if it is maximized or vice
versa solves causes the document to show up. This only happens when opening
the document directly. It will display right away when ...

I need to have data in a chart at the top of my workbook AND data in another
chart at the bottom of my workbook but the two charts are independent of each
other....meaning that when I hide columns in the top workbook- those same
columns are not hidden in the lower workbook.

Searching through the discussion group I can see that several people seem to
have problems with the autofilter show all feature.  I have a protected
worksheet for a shared workbook.  Although other users are able to
Autofilter, their autofilter setting is saved when they close ...