help wanted

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bormans Erwin - 23 Oct 2003 13:10 GMT

Hello, i must teach some lessons of excel and i get some questions that i
don't know the answer, so maybe you can help me.

1) When you select a row or a kolom and want to change the height or width,
with me the standard value's are 12,75 and 8,43 but i don't know what it is.
Is it milimeters, centimeters (but that's not possible), pixels, ...

2) When you enter 3 numerical value's, leave then one row open and then you
put there a function to count them up, it works just fine. But when you
enter a fourth numerical value it automatic recalculated and takes the fouth
value with: for example
A1 100
A2 200
A3 300
A4
A5 = SOM(A1:A3)

Is this an option or is this always like that, i use MS Excel 2000 SP-3. And
i think that excel has no right to do that so i want it to be undone. Is
this possible?

I'm sorry for my bad englisch, but i still hope you understand me!

Kind regards Erwin

Erwin Bormans
Docent Aron
www.aron.be
erwin.bormans@aron.be

Reply to this Message

Paul Cundle - 23 Oct 2003 16:34 GMT

> 1) When you select a row or a kolom and want to change the height or
> width, with me the standard value's are 12,75 and 8,43 but i don't
> know what it is. Is it milimeters, centimeters (but that's not
> possible), pixels, ...

I don't think the number means anything that you would see anywhere else. A
column which is 20 wide is twice as wide as one which is set to 10, but the
numbers don't mean much on their own. When you drag a column or row to
change its size, you should also see a number in brackets () which is
pixels.

> 2) When you enter 3 numerical value's, leave then one row open and
> then you put there a function to count them up, it works just fine.
> But when you enter a fourth numerical value it automatic recalculated
> and takes the fouth value with: for example

Go to Tools-->Options-->Edit and turn off the option "extend list formats
and formulas"

> I'm sorry for my bad englisch, but i still hope you understand me!

Your questions were far easier to understand than many English posters in
newsgroups manage :)

Paul C,
--

Reply to this Message

Ormand - 12 Nov 2003 20:29 GMT

From Ormand,
(1) When you say 'height' or width' in Excel, it means
how many characters(fonts) could be displayed....
( you might get this information by HELP or else..)
(2) What is 'SOM'?
Do you intend to mean 'SUM' instead of SOM?
(3) A5=SUM(A1:A4)
{{{ instead of A5=SUM(A1:A3) }}}
Then you can enter any value into A4, then you will get sum of them
automatically.
you can insert any number of lows betwee lows 3 and lows 4,
automatically change the formula of very bottom of A's lows of
your
original A5 ... etc.

I suggest that:
Very top is to be SUM instead of bottom.
for example:
A1=SUM(A2:A100)
( any number of lows or colums if you like... )
Good Luck!

> Hello, i must teach some lessons of excel and i get some questions that i
> don't know the answer, so maybe you can help me.
[quoted text clipped - 25 lines]
> www.aron.be
> erwin.bormans@aron.be

Reply to this Message