View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default how do I drag to extend a series across lots of cells quickly?

Click the cell in the top left corner, scroll to the bottom right corner,
hold Shift and select this corner cell.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"sjSQW" wrote in message
...
In Excel, it is possible to drag a cell down (or across) to extend a
series
(e.g. a formula) by selecting the cell and using the square in the bottom
right of the cell.

This is fine for relatively small numbers of cells. But is there a quick
way
of extending a series across a large number of cells without just being
very
patient?