Filling Non Adjacent Cells

Walt1306

New Member
Joined
Oct 27, 2002
Messages
4
I have been struggling with this for a while. I am trying to fill a formula throughout a row. The formula is similar to (6*A$1) . However, when I drag it automatically goes to (6*B$1). I want to formula to skip cells. For instance, I want the cell order A1,C1,E1,G1,I1 . Instead I am getting A1,B1,C1,D1,D1. Is it possible to fill non adjacent cells.
 

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).
L

Legacy 11779

Guest
Alternatively (for academic interest only, since only good up to column Z) :-

=6*INDIRECT(CHAR(COLUMN()*2+63) &"1")
 

Walt1306

New Member
Joined
Oct 27, 2002
Messages
4
Thank You, but one more question relating to this. How do I apply these functions to the case where I am copying cells from another page. For example

='[TR-OCT02.XLS]LR6-1'!$B$3
 

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092

ADVERTISEMENT

What is your formula and in what cell?
 

Walt1306

New Member
Joined
Oct 27, 2002
Messages
4
Well, in this case there is no formula. I am trying to copy information from one excel file to another excel file. For instance I want to copy information to cell A1 from another cell located at
'[TR-OCT02.XLS]LR6-1'!$B$3 and have that information
go to the sequence b3,d3,f3,h3,j3 etc.
 

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
Enter this formula in cell A1:

=OFFSET('[TR-OCT02.XLS]LR6-1'!B3,0,COLUMNS($A1:A1)-1)

and copy across as far as is needed.

If you want to break the links, select all the cells containing the formula and choose Edit, Copy then Edit, Paste Special, check Values and click OK.
 

Forum statistics

Threads
1,144,510
Messages
5,724,774
Members
422,576
Latest member
kayth891

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