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?
 

Some videos you may like

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result

shades

Well-known Member
Joined
Mar 20, 2002
Messages
1,550
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
Joined
Apr 28, 2004
Messages
76,267
Office Version
  1. 365
Platform
  1. Windows
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
Joined
Jan 14, 2005
Messages
5
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
Joined
Apr 28, 2004
Messages
76,267
Office Version
  1. 365
Platform
  1. Windows

ADVERTISEMENT

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
Joined
Jan 14, 2005
Messages
5
yes your formula works
but do you know why it does not work the way i am trying?
 

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,267
Office Version
  1. 365
Platform
  1. Windows
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,127,326
Messages
5,624,021
Members
416,006
Latest member
PCaffrey

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
Top