Excell 2003. Simple Problem

  • Thread starter Thread starter longside1
  • Start date Start date
L

longside1

Hi guys,

firstly apologies for the simplicity of this question but to be honest
i never use excel and cant find my manual :confused:

Basically i have a really simple spreadsheet, one of the fields is for
a "sent date" and another field is for a "due date". The due date
should be fourteen days after the sent date. Now i can do the simple
formula for one of the records eg =(a1+14) but how do i repeat this
command throughout the spreadsheet.

Once again apologies for this crude question :rolleyes:
 
Generally, you need to copy and paste this formula (also referred to as
replication), and it will automatically adjust itself.

Assuming your dates are in column A, and your formula is in cell B1,
the easiest way is to use the fill handle - this is the small black
square in the bottom right corner of the cursor. If you double-click
this with B1 selected, then the formula will be copied down column B
for as many dates as you have in column A (assuming no blanks).

An alternative is to select B1 and click the <copy> icon (or CTRL-C) -
you will see dotted lines around B1. Then click to a cell that you want
to copy the formula into and click the <paste> icon (or CTRL-V). You
can keep clicking to another cell and CTRL-V for as many cells as you
need to paste into. Press <Esc> to get rid of the dotted lines after
you're done.

Hope this helps.

Pete
 
Back
Top