ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Is there a shortcut key for Auto Fill (https://www.excelbanter.com/excel-discussion-misc-queries/198458-there-shortcut-key-auto-fill.html)

Craig

Is there a shortcut key for Auto Fill
 
Hi

Is there an alternative to autofill rather than using the small black cross
or using the standard Fill, Series, Autofill command?

thank you!!

Peo Sjoblom[_2_]

Is there a shortcut key for Auto Fill
 
If you have formulas, assume the formula is in B2, then select as far as you
want it copied down
(B2 included) and press Ctrl + d

--


Regards,


Peo Sjoblom

"Craig" wrote in message
...
Hi

Is there an alternative to autofill rather than using the small black
cross
or using the standard Fill, Series, Autofill command?

thank you!!




Craig

Is there a shortcut key for Auto Fill
 
Hi,

thank you but it doesnt work with titles like qtr 1...so control d is fill
not autofill...there may not be a shortcut key for autofill perhaps

thanks anyway



"Peo Sjoblom" wrote:

If you have formulas, assume the formula is in B2, then select as far as you
want it copied down
(B2 included) and press Ctrl + d

--


Regards,


Peo Sjoblom

"Craig" wrote in message
...
Hi

Is there an alternative to autofill rather than using the small black
cross
or using the standard Fill, Series, Autofill command?

thank you!!





Peo Sjoblom[_2_]

Is there a shortcut key for Auto Fill
 
I said it would work with formulas, never said it would work with text
entries. Btw, autofill is part of fill.
--


Regards,


Peo Sjoblom

"Craig" wrote in message
...
Hi,

thank you but it doesnt work with titles like qtr 1...so control d is fill
not autofill...there may not be a shortcut key for autofill perhaps

thanks anyway



"Peo Sjoblom" wrote:

If you have formulas, assume the formula is in B2, then select as far as
you
want it copied down
(B2 included) and press Ctrl + d

--


Regards,


Peo Sjoblom

"Craig" wrote in message
...
Hi

Is there an alternative to autofill rather than using the small black
cross
or using the standard Fill, Series, Autofill command?

thank you!!








All times are GMT +1. The time now is 06:28 PM.

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