Forum Discussion
Solved
Drag to Copy Cells
I'm using a Mac with o365. Here is my scenario: Make a column of ascending numbers 1 - 10 (A1 - A10) Select the cell containing the 10 (A10) Grab the bottom right corner of that cell Drag down ...
Ah...I have found the issue. Just because a cell contains numbers, as well as text, it is not always eligible to be made into a series. That explains it.
Forgive my lack of comprehension, but what exactly do you mean by "copy AND increment" [emphasis added]?
I added the emphasis because the combination, frankly, doesn't make sense. Copying does not include incrementing; incrementing precludes copying. At least in my understanding of those two words.
So could you clarify
(a) what result you're seeking, and
(b) maybe what the larger context is here. What, in other words, is this part of? How will these copied OR incremented numbers be used, in connection with what larger endeavor?
I'm also on Macs with Office 365.
