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

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.

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,351
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,351
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,351
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.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,168,159
Messages
5,857,712
Members
431,891
Latest member
shirazx3

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