[jaws-uk] Re: Excel.
- From: "Jim Williams" <jwbr33694@xxxxxxxxxxxxxxxx>
- To: <jaws-uk@xxxxxxxxxxxxx>
- Date: Thu, 17 Jan 2008 19:35:49 -0000
Sue,
If you want to add up from cells A1 to A10 do the following:
1. Place your cursor where you want the calculation to appear.
2. Type in =SUM(A1:A10) and press Enter.
3. If you have other columns you want to total up (E.G cols B to D) with the
cursor in the cell where you have your first total, hold down the shift key
and cursor across to col F.
4. Press Ctrl+R and you will have your other totals. This copies the first
formula across.
If you want to copy a formula down a column instead of across then use
Ctrl+D.
HTH
Jim Williams
-----Original Message-----
From: jaws-uk-bounce@xxxxxxxxxxxxx [mailto:jaws-uk-bounce@xxxxxxxxxxxxx]On
Behalf Of sue morgan
Sent: 17 January 2008 19:11
To: Jaws; jaws-users-list@xxxxxxxxxxxxxx
Subject: [jaws-uk] Excel.
Hi.
I'm a bit rusty on the old spreadsheets. I did E C D L last year and I
can't remember how to calculate from say A 1 to A 10. I remember using
shift down arrow to highlight the row numbers I wanted to use in the
calculation, but I've forgotten how to work out the total in those rows.
Please could someone jog my memory. I now wish I used spreadsheets more
often because when you do something all the time, you don't forget. Never
mind, I'm sure someone on this list can help me. I think there's a quick
way of doing this calculation without typing open bracket then equals and
all of that.
Thanks.
Sue.
e-mail sue@xxxxxxxxxxxxxxxxxx
mobile 07968825286
msn sue@xxxxxxxxxxxxxxxxxx
skype suemorgan1006
Other related posts:
