ExcelBanter - Excel fill handle use -advanced

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Excel fill handle use -advanced (https://www.excelbanter.com/excel-discussion-misc-queries/216273-excel-fill-handle-use-advanced.html)

Pete G[_2_]

Excel fill handle use -advanced

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

Mike H

Excel fill handle use -advanced

Hi,

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

Mike

"Pete G" wrote:

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

All times are GMT +1. The time now is 01:16 AM.