View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.newusers
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default Subtracting Two Tables

the little cross in the lower right-hand corner
is some mechanism for copying.


Yes, it's called the fill handle, that small black square in the lower-right
corner of the selection. When you hover your mouse over it the cursor
changes to a "skinny plus sign".

--
Biff
Microsoft Excel MVP


wrote in message
...
wrote:
T. Valko wrote:
In A7 enter =A1-F1 or =F1-A1.

Copy across to D7 then down to A10:D10.

I don't seem to be able copy down from d7. I'm guessing when I settle on
a7, after entering =f1-a1, that the little cross in the lower right-hand
corner is some mechanism for copying. All works well for row a7 to to d7.

Ah, I had to copy down each column from the first row, 7. Thanks.

--
Wayne Watson (Watson Adventures, Prop., Nevada City, CA)

(121.015 Deg. W, 39.262 Deg. N) GMT-8 hr std. time)
Obz Site: 39° 15' 7" N, 121° 2' 32" W, 2700 feet

Solid waste produced to generate electricity per person
over a lifetime:
Nuclear power -- 2 pounds in a coke can
Fossil (coal) fuel -- 68.5 tons in six 12-ton RR cars

-- Power to Save the World, Gwyneth Cravens

Web Page: <www.speckledwithstars.net/