How do you password protect a spreadsheet. I can't find anything in the help
section.

I'm pretty much a novice at using Excel but made a formula a couple
years ago to calculate freight.  There are 2 basic scenarios, if the
weight falls between a certain brackets it gets a set price or it gets
multiplied by a percentage.  I think the max number of if than

I am making an invoice that will figure a discount for a certain amount of
sale, all from the same cell, if the subtotal is < 500 then they will get no
discount, if it is > 500 they will get a 5%, and if it is > 750 they will get
a 10% discount, what formula do i use??

I have this 2 columns. I want to copy this two and paste them to a new
row with exact the same formula, value and cellreference.
='Z:\Företag\[filename1.xls]Bestånd'!$A$4
='Z:\Företag\[filename1.xls]Bestånd'!B18

Excel 2002
When I tab through the unlocked cells in a template I do not get the
expected results.  It tabs through the first 6 fields as would be
expected but then it reaches two cells in the middle of the form that

How can I show the name of the spreadsheet -after Microsoft Excel- ( on top
of the Main Menu Bar).
Thanks a lot in advance.
Humberto

Is it possible to change the limit of 1000 items at the drop-down lis
while trying to filter records using the auto filter  ?
If not - is there any other way to do so ?
than

I've got a problem in my code I've written below.
The loop works for the first, third and fourth graphic: that is,
it saves them. But it doesn't save the second graph.
I've put a "pause" at the start and at the end of the loop, but

I'm pretty much a novice at using Excel but made a formula a couple
years ago to calculate freight.  There are 2 basic scenarios, if the
weight falls between a certain brackets it gets a set price or it gets
multiplied by a percentage.  I think the max number of if than

I am trying to write a formula to be placed in the conditional
formatting to color code certain cells but am having some trouble
coming up with the formula.  Basically I have about 240 rows of data,
the columns are by date.  What I want is for whenever a daily reading

Hi!  I was wondering if there is a way to do conditional drop-down
lists through validation.  For example, in the first cell the user
chooses the State (using a validation list to restrict the selections).
Then in the next cell I want to use validation that presents a

I am haveing a weird problem.  When i insert a whole number, such as
2145, after hitting enter, the value in the cell becomes 214.5.
If I put in the decimal place, i.e. 2145.0, the number stays as is.
Any ideas what is the cause of this?

Howdy All,
I have a budget workbook which contains a worksheet for every month and I
need to format certain cells to show a value from a specific date forward.
Example:

How should be IF function for the below mentioned request?
IF something is equal to 2 or 3 or 4  do something otherwise do another
things.
Thanks

I need a macro to transpose data in the excel.The data that i have is
in the following format:
Summary
Some data