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]
