relative row formatting fill not working

reeder123

New Member
Joined
Jan 14, 2005
Messages
5
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

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.
Howdy. The dollar sign ($) means that it is making the B absolute, so it won't change. Take $ out of the cell reference.
 
Upvote 0
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?
 
Upvote 0
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
 
Upvote 0
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?
 
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,222,022
Messages
6,163,451
Members
451,837
Latest member
gmc

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?

Disable AdBlock

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
Back
Top