Dragging cells that are non-consecutive

**JGitler** · 06-11-2009, 04:05 PM

Hi,

My question relates to trend growth for excel cells. For example, i want to isolate certain results that all appear in the same row but different columns, specifically 9 columns apart. Is there a quick way to drag this? I want to be able to return the following trend growth in consecutive cells without having to do it all manually. (e.g. =F17, =o17, =X17)

Thanks,

James

**shg** · 06-11-2009, 04:22 PM

No, you can't drag a non-contiguous selection. You'll notice the drag handle goes away.

**starryknight64** · 06-11-2009, 04:33 PM

I'm not sure if this is what you're wanting, but try this:

Please Login or Register  to view this content.

Where A11 is the number associated with the column you want. (It's a terrible description... I know...

)

I've attached an example spreadsheet.

I hope this helps!

**JGitler** · 06-12-2009, 11:25 AM

thanks - unfortunately i don't think it's possible.

Thanks anyways.

Dragging cells that are non-consecutive

LinkBack

Thread Tools

Rate This Thread

Display

Dragging cells that are non-consecutive

Re: Dragging cells that are non-consecutive

Re: Dragging cells that are non-consecutive

Re: Dragging cells that are non-consecutive

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions