Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Filling / Extending serie
Hello,
If I want to extend a serie (or copy a column) from A1 to A65536 I have to hold the fill handle (bottom right of the cell A1) and drag it from A1 to A65536. Is there another way like selecting A1 and then Shift selecting A65536 to select the whole column from A1 to A65536 and then pressing another key to copy or fill? Thank you. Eric. |
#2
|
|||
|
|||
After selecting the range use Edit, Fill, Series.
-- Jim "Eric" wrote in message ... | Hello, | | If I want to extend a serie (or copy a column) from A1 to A65536 I have to | hold the fill handle (bottom right of the cell A1) and drag it from A1 to | A65536. Is there another way like selecting A1 and then Shift selecting | A65536 to select the whole column from A1 to A65536 and then pressing | another key to copy or fill? | | Thank you. | | Eric. | | |
#3
|
|||
|
|||
Eric Wrote: Hello, If I want to extend a serie (or copy a column) from A1 to A65536 I have to hold the fill handle (bottom right of the cell A1) and drag it from A1 to A65536. Is there another way like selecting A1 and then Shift selecting A65536 to select the whole column from A1 to A65536 and then pressing another key to copy or fill? Thank you. Eric. Select A1, then, while holding the shift key down, press END then the down arrow. Release the shift key, press CTRL+D to fill A1 to the end of the column. HTH Bruce -- swatsp0p ------------------------------------------------------------------------ swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101 View this thread: http://www.excelforum.com/showthread...hreadid=465999 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
filling information from one cell and filling another. | Excel Worksheet Functions | |||
Removing a serie in a chart | Charts and Charting in Excel | |||
In a column with no data, only color filling, how can I filter fo. | Excel Discussion (Misc queries) | |||
Second serie doesn't use X-as values | Charts and Charting in Excel | |||
Zero Filling | Excel Discussion (Misc queries) |