all long column of cells equal to whatever I put in B2

For some reason I am getting nowhere trying to do a very simple thing.

I have a column with many of the cells for a long stretch that I want to be
equal to whatever number I put in B2. As I'm building this spreadsheet, it
seems to me that it should be a very simple matter to "tell" all those cells
to just be equal to whatever is in B2, they using format painter, etc.,....
they don't copy "=B2" part of the previous cells, but instead just copy
whatever the number is .... which means that when I change the number in B2,
it won't change them.

Any ideas?

thanks.

Hi!

In the first cell that you want to link to B2 enter:

=$B$2

Drag copy down as far as needed.

Biff

<[email protected]> wrote in message
news:[email protected]...
> For some reason I am getting nowhere trying to do a very simple thing.
>
> I have a column with many of the cells for a long stretch that I want to
> be equal to whatever number I put in B2. As I'm building this spreadsheet,
> it seems to me that it should be a very simple matter to "tell" all those
> cells to just be equal to whatever is in B2, they using format painter,
> etc.,.... they don't copy "=B2" part of the previous cells, but instead
> just copy whatever the number is .... which means that when I change the
> number in B2, it won't change them.
>
> Any ideas?
>
> thanks.
>

Biff;

Thanks a bunch ... that's what I needed.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~


"Biff" <[email protected]> wrote in message
news:%[email protected]...
> Hi!
>
> In the first cell that you want to link to B2 enter:
>
> =$B$2
>
> Drag copy down as far as needed.
>
> Biff
>
> <[email protected]> wrote in message
> news:[email protected]...
>> For some reason I am getting nowhere trying to do a very simple thing.
>>
>> I have a column with many of the cells for a long stretch that I want to
>> be equal to whatever number I put in B2. As I'm building this
>> spreadsheet, it seems to me that it should be a very simple matter to
>> "tell" all those cells to just be equal to whatever is in B2, they using
>> format painter, etc.,.... they don't copy "=B2" part of the previous
>> cells, but instead just copy whatever the number is .... which means that
>> when I change the number in B2, it won't change them.
>>
>> Any ideas?
>>
>> thanks.
>>
>
>

Glad to help! Thanks for the feedback.

Biff

<[email protected]> wrote in message
news:[email protected]...
> Biff;
>
> Thanks a bunch ... that's what I needed.
>
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>
>
> "Biff" <[email protected]> wrote in message
> news:%[email protected]...
>> Hi!
>>
>> In the first cell that you want to link to B2 enter:
>>
>> =$B$2
>>
>> Drag copy down as far as needed.
>>
>> Biff
>>
>> <[email protected]> wrote in message
>> news:[email protected]...
>>> For some reason I am getting nowhere trying to do a very simple thing.
>>>
>>> I have a column with many of the cells for a long stretch that I want to
>>> be equal to whatever number I put in B2. As I'm building this
>>> spreadsheet, it seems to me that it should be a very simple matter to
>>> "tell" all those cells to just be equal to whatever is in B2, they using
>>> format painter, etc.,.... they don't copy "=B2" part of the previous
>>> cells, but instead just copy whatever the number is .... which means
>>> that when I change the number in B2, it won't change them.
>>>
>>> Any ideas?
>>>
>>> thanks.
>>>
>>
>>
>
>