If AutoFill isn’t familiar to you, you could benefit greatly from our free Basic Skills E-book, which will show you the basics of Excel formulas, functions and AutoFill.
If you use AutoFill often, you’re probably used to double-clicking on the AutoFill handle to fill down a whole column of data, but you might wonder if you could do this more quickly by using a keyboard shortcut.
Tip: To turn off autofill in Firefox on Mac, just turn to 'Disable Autofill in Firefox' part. Now, if you’re looking at how to remove autofill on Mac this way you’re going to spend a lot of time at it. Going through each browser, one at a time, and deleting all of your information is going. Aug 14, 2020 The following tips tell how to use autofill in Microsoft Excel to quickly enter lists and repetitive formulas like a pro. Excel can automatically continue a series (list) of numbers, dates or time periods based on a pattern you establish. You can also set up custom lists and use autofill to automatically replicate them in new worksheets.
There isn’t a specific keyboard shortcut for AutoFilling in this way, but there are some alternatives that could be useful.
Flash Fill was first introduced in Excel 2013. It’s a form of AutoFill that tries to intelligently figure out what kind of data you are trying to fill and automatically provide the values you need.
It’s important to note that Flash Fill does not work with formulas; it will only work with ordinary values.
You can Flash Fill a whole column of data by simply pressing the <Ctrl>+<E> shortcut keys.
Flash Fill is explained in depth in the free Basic Skills E-book.
There actually is a shortcut key for the Fill Down feature: <Ctrl>+<D>
Unfortunately this doesn’t behave in the same way as double-clicking the AutoFill handle. Nothing will happen if you press <Ctrl>+<D> with only a single cell selected. For this to work you need to first select all of the cells that you need to fill down to, which usually takes longer than using the AutoFill handle.
Although there isn’t a shortcut key or Ribbon command that does the same thing as double-clicking the AutoFill handle, Excel still recognizes it as a command. This means that you can use Excel’s Repeat feature to AutoFill as many times as you need after you have done the first AutoFill manually.
The shortcut key for the Repeat command is <Ctrl>+<Y>, but you can also add this command to your Ribbon or Quick Access Toolbar.
Customizing the Ribbon and Quick Access toolbar is covered in our Essential Skills Books and E-books.
Safari User Guide
How To Use Autofill Excel
In the Safari app on your Mac, use AutoFill preferences to fill in contact information, user names and passwords, credit card information, and other forms on webpages. To change these preferences, choose Safari > Preferences, then click AutoFill.
Autofill Excel Macro Last Row
Option | Description | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
Using information from my contacts | Complete forms with information from any contact card in Contacts. To view or edit information, click Edit. | ||||||||||
User names and passwords | Securely save user names and passwords you enter on webpages, then easily fill in the saved information when you revisit the same webpages. Click Edit to view or edit your saved information. | ||||||||||
Credit cards | Securely save the credit card number, expiration date, and cardholder name you enter on webpages, then easily fill in the saved information when you use the card again. Click Edit to add or remove saved credit cards, or to change the information for a saved credit card. | ||||||||||
Other forms | Securely save information you enter on webpage forms, then easily fill in the saved information when you revisit the same webpages. Click Edit to see or remove websites for which Safari has saved AutoFill information. |
If your Mac has Touch ID, you can use Touch ID to fill in user names and passwords and to fill in credit card information. See Change Touch ID preferences.
See alsoAutofill credit card info in Safari on MacAutofill info from Contacts in Safari on MacAutofill your user name and password in Safari on MacUse iCloud Keychain to keep information safe on MacUse Touch ID on Mac