I have a problem for an excel formula. In my example, there is one value in
cell D1: 15, and I want an excel formula which can convert it to 5.  The
objective of the excel formula is to convert 45 to 5, 10 to 10, 20 to 10, 30
to 10, 39 to 9 etc.

I do have one page of Excel with resume information that want to add as the
second page of my resume.  The first page of my resume is in the Word
program (it prints well, no problem with that),  then I want to add a second
page to print on the back of this first page (which is ...

I am trying to hyperlink a cell in one single sheet spreadsheet to a
specific sheet in another multisheet book. I don't need to get to any
specific cell in the second spreadsheet, just the specific sheet.
Thx, Chris

I have a pivot table in my worbook with some customized formatting (totals
in bold, borderwidth, ....)
My problem is when I refresh the table I loose the formatting. Can somebody
help me understand why? Is there any way that I can set the fomatting once

i have a bunch on companies on left
top has may-08 jun-08
under mos. 1    5        8...
under        thu  mon  thur...

I am creating a profit and loss acounts in excel with several worksheets : ie
one for wages, one for motoring expenses and one for telephony expenses etc.
On some of the worksheets I have totals from 3 different items such as land
line telephone and mobile telephone ect each with ...

I have a file that has 7 sheets. I want to protect it so that it can be
viewed but not edited.
I know how to do this by sheet but when I do 'protect workbook' it makes no
difference. how do you do it in one go rather than going into every sheet

I did not add any links.
Yet suddenly, I started getting messages about a data source link.
The link was to ATPVBAEN.XLA.
I use a lot of XIRR functions but never before had the link.

Is there an easier way to format columns, to total 4 columns over a 30 row
span?
I need to create a cost tracking system to analyze cost vs: budget over a 30
day period containing four items; Material, Labor, Equipment, and

I am working with a 20,000 line spreadsheet of clothing - style, color,
sizes, etc.  I have already done sorts to get my products in a consecutive
listing the way I want.
Now, is there a way to separate, highlight, or underline or something

Is there a way to reset the end of a spreadsheet to the last cell that has
information in it? When I press End Home, I am landing on row 6,448 even
though I selected rows 500 - 6448 and hit delete.  Also, another basic
question.  Sometimes a range of cells will increment to the ...

I have typed quite a bit of text in a text box, but I cannot see some of the
text.  Is there a limit for text in a text box? I have inserted lines but,
the end of the text is not visible.

I need to know how to disable the wrap text function after im done with it.I
only wanted to extend for a couple of letters without stacking them on top of
each other.

I have a complex calendar in Excel. Each week, admins Ctrl-drag cells among
different locations in the primary calendar worksheet. I have a second
worksheet that needs to list those cell values in a fixed configuration, e.g.
the value in Sheet1!A1 needs to always appear in the ...

when I try to open a file on Excel it just hangs, no error messages
and windows doesn't even tell me it stopped responding (it does say
'not responding' on the title bar). I notice it says "running virus
scan" I've turned of the virus scanner and it still won't open. It