Excel filling using fill handle

  • Thread starter Thread starter Pete G
  • Start date Start date
If there is a formula in cell A1, grabbing the fill handle in the lower right
corner of A1 and pulling it down WILL copy those formulas down to cells A2
and A3. Any cell references that are NOT preceded by $ signs will adjust
themselves accordingly during the fill-down.

Does that answer your question? It was a little vague.
 
In B1 enter =INDIRECT("A"&(ROW()-1)*2+1)

Copy down to return every second cell from column A


Gord Dibben MS Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel fill handle use -advanced 1
How to use cell reference? 9
Advanced excel fill handle Question 2
Fill handle increments year instead of day 1
Calculate (Auto Fill) cells with numbers and text. 3
Fill options 1
Fixing some values on Fill 1
How can I transpose reference cells by Auto-fill? 3

Back
Top