excel 2000 *

  tron200 21:28 16 Jan 2003
Locked
  tron200 21:28 16 Jan 2003

I can multiply d1+e1 and get the result in f1,
but now i want to do the same for rows 2 to 500.
how can i do this without typing the formula again and again line after line?
(d1 is £ , e1 is just a number)

  Chisman 21:37 16 Jan 2003

Highlight cell f1 and then either (1) use your keyboard (ctrl + c) and higlight rowns f2 to f500 and then press (ctrl + v) or (2) using mouse right click on cell f1 and select copy then higlight cells f2 to f500, right click and select paste.

  Pauper 22:42 16 Jan 2003

Or...highlight f1 and move the cursor to the bottom right corner of the cell where it will become a cross, left click and drag down to row 500

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Best phone camera 2017

Stunning new film posters by Hattie Stewart, Joe Cruz & more

iPad Pro 10.5in (2017) review

28 astuces pour profiter au mieux de votre iPhone