use same cell w/in a function in a entire column.

[collegeboy28]

I want to be able to create a entire column in which every cell in the column
pulls a data point from the same cell. If I high light and paste from my
initial, lets say B1 to b2 through b100. It changes the A1 data in each cell
to the next to a2 a3 a4 a5 a6 a7 a8 ect.. i know this is simple but thanks
anyway. Todd

[bpeltzer]

Put a $ in front of the row reference (ex: a$1 instead of a1) to keep the row
from advancing as you fill down. (Similarly you could put a $ in from of the
column reference to keep the column from advancing as you fill right). Check
Excel's help on 'cell and range references', especially 'the difference
between relative and absolute references.'


"collegeboy28" wrote:

> I want to be able to create a entire column in which every cell in the column
> pulls a data point from the same cell. If I high light and paste from my
> initial, lets say B1 to b2 through b100. It changes the A1 data in each cell
> to the next to a2 a3 a4 a5 a6 a7 a8 ect.. i know this is simple but thanks
> anyway. Todd

[Rowan Drummond]

change your original refernce from A1 to $A$1. See Help on absolute
versus relative references.

Hope this helps
Rowan

collegeboy28 wrote:
> I want to be able to create a entire column in which every cell in the column
> pulls a data point from the same cell. If I high light and paste from my
> initial, lets say B1 to b2 through b100. It changes the A1 data in each cell
> to the next to a2 a3 a4 a5 a6 a7 a8 ect.. i know this is simple but thanks
> anyway. Todd