# relative row formatting fill not working

#### reeder123

##### New Member
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?

### Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},\$Z\$1:\$Z\$99,\$Y\$1:\$Y\$99),2,False) to lookup Y values to left of Z values.

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

#### Norie

##### Well-known Member
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

##### New Member
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

##### Well-known Member
reeder123 said:
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

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

#### Norie

##### Well-known Member
reeder123 said:
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.

Replies
1
Views
186
Replies
5
Views
439
Replies
2
Views
337
Replies
2
Views
199
Replies
2
Views
358

1,172,044
Messages
5,878,875
Members
433,380
Latest member

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back