Originally Posted by CNWatsonJr

Does C3 have a value or a formula in it? If it is a value, click on C3 and then press CNTRL-C (if you are on a PC or Command-C on a Mac) and then click on C4, C5 and C6 (by either holding the Shift or Control key down) and then press CNTRL-V (or Command-V on a Mac).

If C3 has a formula and you haven't locked the cell reference with $ ($C$3) then the cells you copy into will self adjust the formula. If C3 is a formula and you want to copy the value, then press CNTRL-C and then highlight the cells you want to copy into, right-click and then choose Paste Special / Values.

You can also put the formula =C3 in the cells C4, C5 and C6 and that will place the data that is in C3 in the selected cells.

Hope this helps you some.