Excel AutoComplete and AutoFill keyboard shortcut

0 votes

Is there a keyboard shortcut for Excel that, instead of using the mouse, conducts AutoFill and AutoComplete simultaneously? The shortcut is selection (1 2 3) + double-click (bottom right-hand side):

+--- +-------+
|Rank|  A    |
+--- +-------+
| 1  | a     |
| 2  | b     |
| 3  | c     |
|    | d     |
|    | e     |
|    | f     |
|    | g     |
+--- +-------+

I know a keyboard alternative: ALT+E+ENTER+I+S+F+ENTER but this does not do the whole job (auto-complete as the mouse-double-click).

Oct 31, 2022 in Others by Kithuzzz
• 38,010 points
699 views

No answer to this question. Be the first to respond.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.

Related Questions In Others

0 votes
0 answers

Excel 2010, how to keyboard shortcut to filter dropdown checkboxes?

how do I get to the filter ...READ MORE

Feb 10, 2022 in Others by Edureka
• 13,670 points
202 views
0 votes
1 answer

"Advance" an Excel formula via keyboard shortcut while in edit mode?

As requested, you can carry out the ...READ MORE

answered Dec 10, 2022 in Others by narikkadan
• 63,420 points
273 views
0 votes
1 answer

datatable remove column on export to pdf and excel

When we are using jquery datatable for ...READ MORE

answered Feb 17, 2022 in Others by gaurav
• 23,260 points
3,632 views
0 votes
1 answer

Excel VBA if file closed, then open and paste, else just paste data

Slightly re-worked to add full workbook/sheet qualifiers ...READ MORE

answered Sep 21, 2022 in Others by narikkadan
• 63,420 points
586 views
0 votes
1 answer

Average TIME Calculation differs between Excel and PowerBI

They are calculating different things. In Power ...READ MORE

answered Sep 21, 2022 in Others by narikkadan
• 63,420 points
2,718 views
0 votes
1 answer

Excel stock and sales data management

you must attach the event handler each ...READ MORE

answered Sep 23, 2022 in Others by narikkadan
• 63,420 points
353 views
0 votes
1 answer

Retrieve epay.info Balance with VBA and Excel

This code should log you in, provided ...READ MORE

answered Sep 5, 2018 in Blockchain by digger
• 26,740 points
916 views
0 votes
1 answer

ImportError: openpyxl is required for loading excel format files

Forget the PsychoPy complications for the time ...READ MORE

answered Oct 3, 2018 in Python by Priyaj
• 58,090 points
834 views
0 votes
1 answer

In Blue Prism how to split excel column data into TWO columns

This is how I am doing it. Dim ...READ MORE

answered Oct 15, 2018 in RPA by Priyaj
• 58,090 points
4,102 views
0 votes
1 answer

Excel Power Query: Using List.MatchAny on a column value

try this. let TableA = ...READ MORE

answered Oct 22, 2018 in Power BI by Annie97
• 2,160 points
3,852 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP