excel 2000 *

  tron200 21:28 16 Jan 03
Locked
  tron200 21:28 16 Jan 03

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 03

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 03

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.

LG G6 review: Hands-on with LG’s bold, big-screen shot at perfection

1995-2015: How technology has changed the world in 20 years

How the painting-like animated sequences in A Monster Calls were created by Glassworks Barcelona

The 22 best Safari extensions | Best Safari plugins: Improve Apple's Safari web browser with these…