dragging cells

You can use edit-copy and then paste or you can use edit-fill to copy the info.

Don

Drag using the Right mouse button. You'll be given choices to Copy Cells or Fill the series plus other variations.

If you're dragging cells either in horizantal (by rows) or vertical(by columns) directions, you either select the first two cells or the only cell, click the right mouse while you drag (using the fill handle) and release the right mouse whenever youwant to stop the auto fill. This stage, you're given an option like "Copy Cells", "Fills Series", "Fill Formats", "Fill Values", etc. Try to explore this technique.

I hope this will help your problem.

If you have a single series of a number, click on the cell and in the lower corner of the cell, there is a crosshair. left click and hold mouse button on crosshar and drag the column. If there is a series of numbers that you want to continues, highlight the series and do the above process

This question was closed by the author