ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel 2007 fill a series using keyboard commands (https://www.excelbanter.com/excel-discussion-misc-queries/134750-excel-2007-fill-series-using-keyboard-commands.html)

EchoPapa42

Excel 2007 fill a series using keyboard commands
 
In Excel 2007 is there a way to fill a series using keyboard commands? The
fill handle is very cumbersome for filling a column several thousand rows in
length, for example.

(In Excel 2003, the keyboard commands were Alt-Edit-Fill-Series and then
choose type and unit).

Thanks in advance.

Teethless mama

Excel 2007 fill a series using keyboard commands
 
Home tab Editing ribbon select down arrow icon


"EchoPapa42" wrote:

In Excel 2007 is there a way to fill a series using keyboard commands? The
fill handle is very cumbersome for filling a column several thousand rows in
length, for example.

(In Excel 2003, the keyboard commands were Alt-Edit-Fill-Series and then
choose type and unit).

Thanks in advance.


EchoPapa42

Excel 2007 fill a series using keyboard commands
 
Thanks a ton - I completely missed that editing box!


"Teethless mama" wrote:

Home tab Editing ribbon select down arrow icon


"EchoPapa42" wrote:

In Excel 2007 is there a way to fill a series using keyboard commands? The
fill handle is very cumbersome for filling a column several thousand rows in
length, for example.

(In Excel 2003, the keyboard commands were Alt-Edit-Fill-Series and then
choose type and unit).

Thanks in advance.



All times are GMT +1. The time now is 10:36 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com