Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 . |
#4
|
|||
|
|||
Quote:
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)
__________________
Thanks Bala |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
AutoFill A to Z | New Users to Excel | |||
autofill | Excel Worksheet Functions | |||
Autofill | Excel Discussion (Misc queries) | |||
Autofill | Excel Worksheet Functions | |||
Autofill: Need to autofill one week block, (5) weekday only into cells. | Excel Discussion (Misc queries) |