Excel fill handle use -advanced

P

Pete G

Whwen you use the fill handle it fills say A1, A2, A3 , A4 etc.

Can someone say how to cause it to fill in every other eg

A1,A3,A5 leaving out A2,A4,A6

much obliged if you can

regards

Pete G
 
M

Mike H

Hi,

Manually enter your formula into A1 and A3 then select A1 - A4 (4 cells) and
then drag the fill handle.

Mike
 

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

Copy a formula using Vlookup 2
How to use cell reference? 9
Advanced excel fill handle Question 2
Excel Fill issue 2
Fill Help 3
Copy value from cell above 7
Fixed vlaue in the Fill handle opperation 2
Filtering of data in a master excel sheet from multiple sheets 3

Top