ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Autofill (https://www.excelbanter.com/excel-discussion-misc-queries/263122-autofill.html)

dewheatley

Autofill
 
I'm having a problem with autofill. I can drag and drop but when I want to
see the options, before I can mouse over to the options box, the box vanishes
as soon I've moved off the initial cell that was copied. I'm not fast enough
to get to the options, so it would be good if someone could tell me how to
keep the options box available.



kristain via OfficeKB.com

Autofill
 
The Auto Fill Option button is displayed after you select the AutoFill option
in the Series dialog box. To show the Series dialog box, use one of the
following procedures
In Microsoft Office Excel 2007, click the Home tab, and then click Fill in
the Editing group.
In Microsoft Office Excel and in earlier versions of Excel, point to Fill on
the Edit menu, and then click Series. The options that are available depend
on the type of content in the cells and on the format of the data. You can
use the Series command to find the AutoFill option and other options.

--
kristain Hayes

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/201005/1


Malin D

Autofill
 
You can also drag the autofill button with your RIGHT mouse button instead.
Then you will get a menu to choose from right away.


--
Best regards

Malin D
Office consultant/Trainer


"kristain via OfficeKB.com" wrote:

The Auto Fill Option button is displayed after you select the AutoFill option
in the Series dialog box. To show the Series dialog box, use one of the
following procedures
In Microsoft Office Excel 2007, click the Home tab, and then click Fill in
the Editing group.
In Microsoft Office Excel and in earlier versions of Excel, point to Fill on
the Edit menu, and then click Series. The options that are available depend
on the type of content in the cells and on the format of the data. You can
use the Series command to find the AutoFill option and other options.

--
kristain Hayes

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/201005/1

.


bala_vb

Quote:

Originally Posted by dewheatley (Post 951250)
I'm having a problem with autofill. I can drag and drop but when I want to
see the options, before I can mouse over to the options box, the box vanishes
as soon I've moved off the initial cell that was copied. I'm not fast enough
to get to the options, so it would be good if someone could tell me how to
keep the options box available.


Here is one short cut in excel 2007 to appear auto fill otpions

Alt+H THEN press keys "fi" (F for France, I for India)


All times are GMT +1. The time now is 04:18 AM.

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