relative row formatting fill not working

[reeder123]

how do you auto format across
I want cells to go across the columns
=b3 =b4 =b5 =b6
if i use =$b3 then try to autofill across its not working
=$B3 =$B3 =$B3 =$B3
=$B4
=$B5
=$B6
why?

 

[shades]

Howdy. The dollar sign ($) means that it is making the B absolute, so it won't change. Take $ out of the cell reference.

 

[Norie]

Where do you want the results?

Try putting the following formula in C3 and copy it across:

=OFFSET($B$3,COLUMN()-3,0)

Is that what you want?

 

[reeder123]

I am looking for the numbers to change and the letter stay the same as I copy across the columns
Like this:
=$B3 =$B4 =$B5 =$B6
but the autofill does not work like this

 

[Norie]

but the autofill does not work like this

As far as I know it isn't supposed to work that way.

Is the formula I posted of any use?

 

[reeder123]

yes your formula works
but do you know why it does not work the way i am trying?

 

[Norie]

but do you know why it does not work the way i am trying?

Because as far as I know it isn't meant to.