Just a clarification: Highlight the row BELOW the row or rows you want
frozen, then select Window > Freeze.
Paul wrote:
For freezing rows, highlight the row, then select window > freeze...
Concerning Matrix calculations (from calc help):
Assume you have entered 10 numbers in Columns A and B (A1:A10 and
B1:B10), and would like to calculate the sum of each row in Column C.
1.Using the mouse, select the range C1:C10, in which the results are
to be displayed.
2.Press F2, or click in the input line of the Formula bar.
3.Enter an equal sign (=).
4.Select the range A1:A10, which contains the first values for the sum
formula.
5.Press the (+) key from the numerical keypad.
6.Select the numbers in the second column in cells B1:B10.
7.End the input with the matrix key combination: Shift+Ctrl+Enter.
/paul
On 6/12/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
hello,
i am having difficulty in two parts, PLEASE help me:
1. how o 'freeze' a row in a large size spreadsheet? i want these to
show as a heading.
2. how do i enter data for a matix.
thanks very much.
reuben
==============
We Only Charge $1.00 a Minute. You Could Be Paying More, But WHY?!
www.LimousineDrive.com
P.O. Box 52
Palo Alto, CA 94302
eMail: [EMAIL PROTECTED] and/or [EMAIL PROTECTED]
Palo Alto 650~326~9484 (Listed in Palo Alto White & Yellow Pages of
Phone Directory)
San Jose Office 408~404~3172
Mobile 650~630~2927
San Francisco 415~410~6368
7-7 7 Days a Week!
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
